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

List of usage examples for org.apache.ibatis.session SqlSession selectList

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. 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.MybatisMediaResourceBrokerDao.java

License:Open Source License

@Override
public List<MediaResourceBrokerEntity> getConnectedSlaveEntitiesByConfSid(Sid conferenceSid) {

    final SqlSession session = sessions.openSession();

    try {/* w ww  .j  av  a  2s  . co  m*/
        final List<Map<String, Object>> results = session
                .selectList(namespace + "getConnectedSlaveEntitiesByConfSid", conferenceSid.toString());
        final List<MediaResourceBrokerEntity> entities = new ArrayList<MediaResourceBrokerEntity>();

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

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

License:Open Source License

@Override
public List<MediaServerEntity> getMediaServerEntityByIP(final String msIPAddress) {
    final SqlSession session = sessions.openSession();
    try {//from   w  w w. j  a  v  a  2 s. c  om
        final List<Map<String, Object>> results = session.selectList(namespace + "getMediaServerEntityByIP",
                msIPAddress);
        final List<MediaServerEntity> msList = new ArrayList<MediaServerEntity>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                msList.add(toMediaServer(result));
            }
        }
        return msList;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public List<Notification> getNotifications(NotificationFilter filter) {

    final SqlSession session = sessions.openSession();

    try {//  w  w w .  ja v a  2  s.c om
        final List<Map<String, Object>> results = session
                .selectList(namespace + "getNotificationsByUsingFilters", filter);
        final List<Notification> cdrs = new ArrayList<Notification>();

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

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

License:Open Source License

@Override
public List<Organization> getOrganizationsByStatus(Organization.Status status) {
    final SqlSession session = sessions.openSession();
    try {//ww  w  . java 2s .  c o  m
        final List<Map<String, Object>> results = session.selectList(namespace + "getOrganizationsByStatus",
                status.toString());
        final List<Organization> organization = new ArrayList<Organization>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                organization.add(toOrganization(result));
            }
        }
        return organization;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public List<ProfileAssociation> getProfileAssociationsByProfileSid(String profileSid) {

    final SqlSession session = sessions.openSession();

    try {/* w ww .  j a v a 2s .  c o  m*/
        final List<Map<String, Object>> results = session
                .selectList(namespace + "getProfileAssociationsByProfileSid", profileSid);
        final List<ProfileAssociation> profiles = new ArrayList<ProfileAssociation>();

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

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

License:Open Source License

@Override
public List<Recording> getRecordingsByCall(Sid callSid) {
    final SqlSession session = sessions.openSession();
    try {//from   w w  w  .  j a va  2  s  . co  m
        final List<Map<String, Object>> results = session.selectList(namespace + "getRecordingsByCall",
                callSid.toString());
        final List<Recording> recordings = new ArrayList<Recording>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                recordings.add(toRecording(result));
            }
        }
        return recordings;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public List<Recording> getRecordings(RecordingFilter filter) {

    final SqlSession session = sessions.openSession();

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

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

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

License:Open Source License

@Override
public Registration getRegistrationByInstanceId(String user, String instanceId) {
    final SqlSession session = sessions.openSession();
    try {/*ww  w  .j  a  va 2 s. c  o m*/
        // https://bitbucket.org/telestax/telscale-restcomm/issue/107/dial-fails-to-call-a-client-registered
        // we get all registrations and sort them by latest updated date so that we target the device where the user last
        // updated the registration

        final Map<String, Object> map = new HashMap<String, Object>();
        map.put("user_name", user);
        map.put("instanceid", instanceId);
        final List<Map<String, Object>> results = session.selectList(namespace + "getRegistrationByInstanceId",
                map);
        final List<Registration> records = new ArrayList<Registration>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                records.add(toPresenceRecord(result));
            }
            if (records.isEmpty()) {
                return null;
            } else {
                Collections.sort(records);
                return records.get(0);
            }
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public List<Registration> getRegistrationsByInstanceId(String instanceId) {
    final SqlSession session = sessions.openSession();
    try {// w ww .j  a  va2  s  .  c  o  m
        final List<Map<String, Object>> results = session.selectList(namespace + "getRegistrationsByInstanceId",
                instanceId);
        final List<Registration> records = new ArrayList<Registration>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                records.add(toPresenceRecord(result));
            }
            if (!records.isEmpty()) {
                Collections.sort(records);
            }
        }
        return records;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public List<SmsMessage> getSmsMessages(SmsMessageFilter filter) {

    final SqlSession session = sessions.openSession();

    try {//ww  w . j a  v  a2 s.  c om
        final List<Map<String, Object>> results = session.selectList(namespace + "getSmsMessagesByUsingFilters",
                filter);
        final List<SmsMessage> cdrs = new ArrayList<SmsMessage>();

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