Example usage for org.apache.ibatis.session SqlSession selectList

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession selectList.

Prototype

<E> List<E> selectList(String statement, Object parameter);

Source Link

Document

Retrieve a list of mapped objects from the statement key and parameter.

Usage

From source file:org.restcomm.connect.dao.mybatis.MybatisTranscriptionsDao.java

License:Open Source License

@Override
public List<Transcription> getTranscriptions(TranscriptionFilter filter) {

    final SqlSession session = sessions.openSession();

    try {/*from   w  w  w . j  av a  2 s  .c  o m*/
        final List<Map<String, Object>> results = session
                .selectList(namespace + "getTranscriptionsByUsingFilters", filter);
        final List<Transcription> cdrs = new ArrayList<Transcription>();

        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                cdrs.add(toTranscription(result));
            }
        }
        return cdrs;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.connect.dao.mybatis.MybatisUsageDao.java

License:Open Source License

private List<Usage> getUsageCalls(final Sid accountSid, Usage.Category category, DateTime startDate,
        DateTime endDate, String uri, final String queryName) {
    long startTime = System.currentTimeMillis();
    final SqlSession session = sessions.openSession();
    Map<String, Object> params = new HashMap<String, Object>();
    params.put("sid", accountSid.toString());
    params.put("startDate", new Date(startDate.getMillis()));
    params.put("endDate", new Date(endDate.getMillis()));
    params.put("uri", uri);
    fillParametersByCategory(category, params);
    try {//ww w .  j a  v  a  2s  . c o m
        final List<Map<String, Object>> results = session.selectList(namespace + queryName, params);
        final List<Usage> usageRecords = new ArrayList<Usage>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                usageRecords.add(toUsageRecord(accountSid, result));
            }
        }
        return usageRecords;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.sbc.dao.mybatis.MybatisBanListDao.java

License:Open Source License

@Override
public List<BanList> getBanLists(BanListFilter filter) {

    final SqlSession session = sessions.openSession();

    try {/*  ww  w.  java  2s. c  om*/
        final List<Map<String, Object>> results = session.selectList(namespace + "getBanListByUsingFilters",
                filter);
        final List<BanList> banLists = new ArrayList<BanList>();

        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                banLists.add(toBanList(result));
            }
        }
        return banLists;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.sbc.dao.mybatis.MybatisConnectorsDao.java

License:Open Source License

@Override
public List<Connector> getConnectorsByNetworkPoint(String pointId) {
    final SqlSession session = sessions.openSession();
    try {//from  w w w  .ja va2s .c  o  m
        final List<Map<String, Object>> results = session.selectList(namespace + "getEntriesByNetworkPoint",
                pointId);
        final List<Connector> entrys = new ArrayList<Connector>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                entrys.add(toConnector(result));
            }
        }
        return entrys;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.sbc.dao.mybatis.MybatisUsageDao.java

License:Open Source License

private List<Usage> getUsageRecords(Usage.Category category, DateTime startDate, DateTime endDate,
        final String queryName) {
    final SqlSession session = sessions.openSession();
    Map<String, Object> params = new HashMap<String, Object>();

    params.put("startDate", new Date(startDate.getMillis()));
    params.put("endDate", new Date(endDate.getMillis()));

    fillParametersByCategory(category, params);
    try {// w ww . j  av a  2 s.  c  o  m
        final List<Map<String, Object>> results = session.selectList(namespace + queryName, params);
        final List<Usage> usageRecords = new ArrayList<Usage>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                usageRecords.add(toUsageRecord(result));
            }
        }
        return usageRecords;
    } finally {
        session.close();
    }
}

From source file:org.solmix.datax.mybatis.MybatisDataService.java

License:Open Source License

protected Object executeWithSqlSession(SqlSession session, DSRequest req, OperationType type) {
    String statement = this.getMybatisStatement(req);
    if (DataTools.isFetch(type)) {
        return session.selectList(statement, req.getRawValues());
    } else if (DataTools.isRemove(type)) {
        return session.delete(statement, req.getRawValues());
    } else if (DataTools.isUpdate(type)) {
        return session.update(statement, req.getRawValues());
    } else if (DataTools.isAdd(type)) {
        return session.insert(statement, req.getRawValues());
    }//from   www.  jav  a 2s.  co  m
    return null;

}

From source file:org.sonar.core.permission.PermissionDao.java

License:Open Source License

/**
 * 'Anyone' group is not returned when it has not the asked permission.
 * Membership parameter from query is not taking into account in order to deal more easily with the 'Anyone' group
 * @return a non paginated list of groups.
 *///  w  w  w .  j  a va  2  s. co m
public List<GroupWithPermissionDto> selectGroups(PermissionQuery query, @Nullable Long componentId) {
    SqlSession session = myBatis.openSession(false);
    try {
        Map<String, Object> params = newHashMap();
        params.put(QUERY_PARAMETER, query);
        params.put(COMPONENT_ID_PARAMETER, componentId);
        params.put("anyoneGroup", DefaultGroups.ANYONE);
        return session.selectList("org.sonar.core.permission.PermissionMapper.selectGroups", params);
    } finally {
        MyBatis.closeQuietly(session);
    }
}

From source file:org.sonar.core.permission.PermissionTemplateDao.java

License:Open Source License

/**
 * 'Anyone' group is not returned when it has not the asked permission.
 * Membership parameter from query is not taking into account in order to deal more easily with the 'Anyone' group.
 * @return a non paginated list of groups.
 *//*from  w  w  w.  j  av  a  2s  . c  o m*/
public List<GroupWithPermissionDto> selectGroups(PermissionQuery query, Long templateId) {
    SqlSession session = myBatis.openSession(false);
    try {
        Map<String, Object> params = newHashMap();
        params.put(QUERY_PARAMETER, query);
        params.put(TEMPLATE_ID_PARAMETER, templateId);
        params.put("anyoneGroup", DefaultGroups.ANYONE);
        return session.selectList("org.sonar.core.permission.PermissionTemplateMapper.selectGroups", params);
    } finally {
        MyBatis.closeQuietly(session);
    }
}

From source file:org.sonar.core.user.AuthorizationDao.java

License:Open Source License

public Collection<String> selectAuthorizedRootProjectsKeys(@Nullable Integer userId, String role,
        SqlSession session) {
    String sql;//w w w . j  a v a 2  s.c o m
    Map<String, Object> params = newHashMap();
    sql = "selectAuthorizedRootProjectsKeys";
    params.put(USER_ID_PARAM, userId);
    params.put("role", role);

    return session.selectList(sql, params);
}

From source file:org.sonar.core.user.AuthorizationDao.java

License:Open Source License

public Collection<String> selectAuthorizedRootProjectsUuids(@Nullable Integer userId, String role,
        SqlSession session) {
    String sql;//from w  ww . jav  a 2 s .c o m
    Map<String, Object> params = newHashMap();
    sql = "selectAuthorizedRootProjectsUuids";
    params.put(USER_ID_PARAM, userId);
    params.put("role", role);

    return session.selectList(sql, params);
}