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.MybatisCallDetailRecordsDao.java

License:Open Source License

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

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

License:Open Source License

@Override
public Integer getInProgressCallsByClientName(String client) {
    final SqlSession session = sessions.openSession();
    try {//from   w w w .j  a  v  a 2s .  co  m
        final Integer total = session.selectOne(namespace + "getInProgressCallsByClientName", client);
        return total;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public Integer getInProgressCallsByAccountSid(String accountSid) {
    final SqlSession session = sessions.openSession();
    try {/*  w w w  . java  2 s.com*/
        final Integer total = session.selectOne(namespace + "getInProgressCallsByAccountSid", accountSid);
        return total;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public Integer getTotalRunningCallDetailRecordsByConferenceSid(Sid conferenceSid) {

    final SqlSession session = sessions.openSession();
    try {//from  w w w.j  a va 2 s  . c  o m
        final Integer total = session.selectOne(namespace + "getTotalRunningCallDetailRecordsByConferenceSid",
                conferenceSid.toString());
        return total;
    } finally {
        session.close();
    }

}

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

License:Open Source License

@Override
public Double getAverageCallDurationLast24Hours(Sid instanceId) throws ParseException {
    DateTime now = DateTime.now();//www . j  av  a2 s  . c  o m
    DateTimeFormatter fmt = DateTimeFormat.forPattern("yyyy-MM-dd");
    SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");

    Date today = formatter.parse(now.toString(fmt));

    Map<String, Object> params = new HashMap<String, Object>();
    params.put("instanceid", instanceId.toString());
    params.put("startTime", today);

    final SqlSession session = sessions.openSession();
    try {
        final Double total = session.selectOne(namespace + "getAverageCallDurationLast24Hours", params);
        return total;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public Double getAverageCallDurationLastHour(Sid instanceId) throws ParseException {
    SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:00:00");
    String hour = formatter.format(Calendar.getInstance().getTime());
    Date lastHour = formatter.parse(hour);

    Map<String, Object> params = new HashMap<String, Object>();
    params.put("instanceid", instanceId.toString());
    params.put("startTime", lastHour);

    final SqlSession session = sessions.openSession();
    try {//from w w  w.  j ava 2s.co  m
        final Double total = session.selectOne(namespace + "getAverageCallDurationLastHour", params);
        return total;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public ExtensionConfiguration getConfigurationByName(String extensionName) {
    final SqlSession session = sessions.openSession();
    ExtensionConfiguration extensionConfiguration = null;
    try {/*from  ww w .  j  a  v  a 2 s.c om*/
        final Map<String, Object> result = session.selectOne(namespace + "getConfigurationByName",
                extensionName);
        if (result != null) {
            extensionConfiguration = toExtensionConfiguration(result);
        }
        return extensionConfiguration;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public ExtensionConfiguration getConfigurationBySid(Sid extensionSid) {
    final SqlSession session = sessions.openSession();
    ExtensionConfiguration extensionConfiguration = null;
    try {//from ww w.j av a 2s.c  o  m
        final Map<String, Object> result = session.selectOne(namespace + "getConfigurationBySid",
                extensionSid.toString());
        if (result != null) {
            extensionConfiguration = toExtensionConfiguration(result);
        }
        return extensionConfiguration;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public boolean isLatestVersionByName(String extensionName, DateTime dateTime) {
    final SqlSession session = sessions.openSession();
    boolean result = false;
    int comp;/*from  w w  w .  j ava2s .c o  m*/
    try {
        final DateTime dateUpdated = new DateTime(
                session.selectOne(namespace + "getDateUpdatedByName", extensionName));
        if (dateUpdated != null) {
            comp = DateTimeComparator.getInstance().compare(dateTime, dateUpdated);
            if (comp < 0) {
                //Negative value means that given dateTime is less than dateUpdated, which means that DB
                //has a newer cnfiguration
                result = true;
            }
        }

    } finally {
        session.close();
    }
    return result;
}

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

License:Open Source License

@Override
public boolean isLatestVersionBySid(Sid extensionSid, DateTime dateTime) {
    final SqlSession session = sessions.openSession();
    boolean result = false;
    int comp;//from w ww.  j av  a2  s  . c o m
    try {
        final DateTime dateUpdated = new DateTime(
                session.selectOne(namespace + "getDateUpdatedBySid", extensionSid.toString()));
        if (dateUpdated != null) {
            comp = DateTimeComparator.getInstance().compare(dateTime, dateUpdated);
            if (comp < 0) {
                //Negative value means that given dateTime is less than dateUpdated, which means that DB
                //has a newer cnfiguration
                result = true;
            }
        }

    } finally {
        session.close();
    }
    return result;
}