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

Introduction

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

Prototype

<T> T selectOne(String statement, Object parameter);

Source Link

Document

Retrieve a single row mapped from the statement key and parameter.

Usage

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

License:Open Source License

@Override
public Profile getProfile(String sid) throws SQLException {
    final SqlSession session = sessions.openSession();
    try {/*from  ww  w  .j av a 2s.  c  o m*/
        final Map<String, Object> result = session.selectOne(namespace + "getProfile", sid.toString());
        if (result != null) {
            return toProfile(result);
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public Integer getTotalRecording(RecordingFilter filter) {
    final SqlSession session = sessions.openSession();
    try {/*  w  ww  .  jav  a2  s.  c  o m*/
        final Integer total = session.selectOne(namespace + "getTotalRecordingByUsingFilters", filter);
        return total;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public Integer getTotalSmsMessage(SmsMessageFilter filter) {
    final SqlSession session = sessions.openSession();
    try {//from   www.  jav  a 2s .  com
        final Integer total = session.selectOne(namespace + "getTotalSmsMessageByUsingFilters", filter);
        return total;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public int getSmsMessagesPerAccountLastPerMinute(String accountSid) throws ParseException {
    SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    String date = formatter.format(DateTime.now().minusSeconds(60).toDate());

    Map<String, Object> params = new HashMap<String, Object>();
    params.put("start_time", date);
    params.put("account_sid", accountSid);

    final SqlSession session = sessions.openSession();
    try {/*from   ww w .  j  a v a  2s  .  c o m*/
        final int total = session.selectOne(namespace + "getSmsMessagesPerAccountLastPerMinute", params);
        return total;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public Integer getTotalTranscription(TranscriptionFilter filter) {
    final SqlSession session = sessions.openSession();
    try {// w  ww.j a  va  2  s .  co  m
        final Integer total = session.selectOne(namespace + "getTotalTranscriptionByUsingFilters", filter);
        return total;
    } finally {
        session.close();
    }
}

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

License:Open Source License

private BanList getBanList(final String selector, final Object parameters) {
    if (LOG.isDebugEnabled()) {
        LOG.debug("Params=" + parameters);
    }//from  w w  w .j  a va 2  s . c  o m
    final SqlSession session = sessions.openSession();
    try {
        final Map<String, Object> result = session.selectOne(selector, parameters);
        if (result != null) {
            return toBanList(result);
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public Integer getTotalBanLists(BanListFilter filter) {

    final SqlSession session = sessions.openSession();
    try {/* w w w.ja  va  2s  .c  o  m*/
        final Integer total = session.selectOne(namespace + "getTotalBanListByUsingFilters", filter);
        return total;
    } finally {
        session.close();
    }

}

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

License:Open Source License

private Connector getConnector(final String selector, final Object parameters) {
    final SqlSession session = sessions.openSession();
    try {/* w ww  .  j  a v a2  s .  c om*/
        final Map<String, Object> result = session.selectOne(selector, parameters);
        if (result != null) {
            return toConnector(result);
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}

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

License:Open Source License

private NetworkPoint getNetworkPoint(final String selector, final Object parameters) {
    final SqlSession session = sessions.openSession();
    try {//from   w  ww .ja  v  a2s  . com
        final Map<String, Object> result = session.selectOne(selector, parameters);
        if (result != null) {
            return toNetworkPoint(result);
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}

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

License:Open Source License

private Route getRoutingPolicy(final String selector, final Object parameters) {
    final SqlSession session = sessions.openSession();
    try {//from   www . j av  a  2  s.  c om
        final Map<String, Object> result = session.selectOne(selector, parameters);
        if (result != null) {
            return toRoutingPolicy(result);
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}