Example usage for org.hibernate.type StandardBasicTypes INTEGER

Introduction

In this page you can find the example usage for org.hibernate.type StandardBasicTypes INTEGER.

Prototype

IntegerType INTEGER

To view the source code for org.hibernate.type StandardBasicTypes INTEGER.

Click Source Link

Document

The standard Hibernate type for mapping Integer to JDBC java.sql.Types#INTEGER INTEGER .

Usage

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.index.ContentIndexDaoImpl.java

License:Open Source License

@Override
public Integer getMaximumUsedInCollectionCount() {
    Session session = getSessionFactory().getCurrentSession();
    Query query = session.createSQLQuery(MAX_RESOURCE_USED_IN_COLLECTION_COUNT)
            .addScalar("maxUsedInCollectionCount", StandardBasicTypes.INTEGER);
    return (Integer) query.list().get(0);
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.index.ContentIndexDaoImpl.java

License:Open Source License

@Override
public Integer getResourceMaximumView() {
    Session session = getSessionFactory().getCurrentSession();
    Query query = session.createSQLQuery(RESOURCE_MAX_VIEW).addScalar("max_views", StandardBasicTypes.INTEGER);
    return (Integer) query.list().get(0);
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.index.ContentIndexDaoImpl.java

License:Open Source License

@Override
public Integer getCollectionMaximumView() {
    Session session = getSessionFactory().getCurrentSession();
    Query query = session.createSQLQuery(COLLECTION_MAX_VIEW).addScalar("max_views",
            StandardBasicTypes.INTEGER);
    return (Integer) query.list().get(0);
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.index.ContentIndexDaoImpl.java

License:Open Source License

@Override
public Integer getUpperboundQuestionCountInCollection() {
    Session session = getSessionFactory().getCurrentSession();
    Query query = session.createSQLQuery(UPPERBOUND_QUESTION_RESOURCE_IN_COLLECTION)
            .addScalar("upperbound_question_count", StandardBasicTypes.INTEGER);
    return (Integer) query.list().get(0);
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.index.ContentIndexDaoImpl.java

License:Open Source License

@Override
public Integer getUpperboundResourceCountInCollection() {
    Session session = getSessionFactory().getCurrentSession();
    Query query = session.createSQLQuery(UPPERBOUND_OTHER_RESOURCE_IN_COLLECTION)
            .addScalar("upperbound_resource_count", StandardBasicTypes.INTEGER);
    return (Integer) query.list().get(0);
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.JobRepositoryHibernate.java

License:Open Source License

@Override
public int getAverageRetryTime(long fileSize) {
    String sql = "SELECT AVG(time_to_complete) as average_time FROM job WHERE job.time_to_complete IS NOT NULL AND job.file_size  ";
    if (fileSize > 100000) {
        sql += "BETWEEN  " + (fileSize - 100000) + " AND " + (fileSize + 100000);
    } else {//from   w w  w  . jav a  2s. c o m
        sql += "BETWEEN  " + 0 + " AND " + fileSize;
    }
    sql += " AND job.status = 'Completed' LIMIT 100 ";

    Session session = getSession();
    Query query = session.createSQLQuery(sql).addScalar("average_time", StandardBasicTypes.INTEGER);
    List<Integer> results = query.list();

    return (results.size() > 0) ? results.get(0) : 0;
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.partner.CustomFieldRepositoryHibernate.java

License:Open Source License

private List<Object[]> getAllCustomFields(String accountUId, String searchAlias) {
    String sql = "SELECT data_column_name, name, group_code  FROM  custom_fields WHERE ";
    if (accountUId != null) {
        sql += " organization_uid =?";
    }//from  w w w .  j  a va2s  .c  o m
    if (accountUId != null && searchAlias != null) {
        sql += " AND ";
    }
    if (searchAlias != null) {
        sql += " search_alias_name=? AND add_to_search=?";
    }
    if ((accountUId != null || searchAlias != null)) {
        sql += " AND ";
    }
    sql += " show_in_response=?";

    SQLQuery query = getSession().createSQLQuery(sql);

    int currentParameter = 0;
    if (accountUId != null) {
        query.setParameter(currentParameter, accountUId, StandardBasicTypes.STRING);
        currentParameter++;
    }
    if (searchAlias != null) {
        query.setParameter(currentParameter, searchAlias, StandardBasicTypes.STRING);
        query.setParameter(currentParameter + 1, 1, StandardBasicTypes.INTEGER);
        currentParameter++;
    }
    query.setParameter(currentParameter, 1, StandardBasicTypes.INTEGER);
    return query.list();
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.partner.CustomFieldRepositoryHibernate.java

License:Open Source License

@Override
public List<Object[]> getSearchAliasByOrganization(String accountUId) {
    String sql = "SELECT search_alias_name, data_column_name,add_to_search,add_to_search_index,add_to_filters FROM custom_fields WHERE show_in_response=? AND account_uid =? AND add_to_search=? ";
    SQLQuery query = getSession().createSQLQuery(sql);
    query.setParameter(0, 1, StandardBasicTypes.INTEGER);

    if (accountUId != null) {
        query.setParameter(1, accountUId, StandardBasicTypes.STRING);
    }//  w  w  w  .  ja v a2s  .  c o  m
    query.setParameter(2, 1, StandardBasicTypes.INTEGER);

    query.addScalar("search_alias_name", StandardBasicTypes.STRING);
    query.addScalar("data_column_name", StandardBasicTypes.STRING);
    query.addScalar("add_to_search", StandardBasicTypes.INTEGER);
    query.addScalar("add_to_search_index", StandardBasicTypes.INTEGER);
    query.addScalar("add_to_filters", StandardBasicTypes.INTEGER);
    return query.list();
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.PartyRepositoryHibernate.java

License:Open Source License

@Override
public Integer getCountInActiveMailSendToday() {
    String sql = "select count(1) as count from party_custom_field p where p.optional_value != '-' and  date(p.optional_value) = date(now())";
    Query query = getSession().createSQLQuery(sql).addScalar("count", StandardBasicTypes.INTEGER);
    return (Integer) query.list().get(0);
}

From source file:org.ednovo.gooru.infrastructure.persistence.hibernate.PartyRepositoryHibernate.java

License:Open Source License

@Override
public boolean isUserBirthDayMailSentToday(String userId, String date) {
    Session session = getSession();//from w  w w .  j  a v a2 s  .c  o  m
    String sql = "select count(1) as count from party_custom_field where party_uid = '" + userId
            + "' and optional_value = '" + date + "' and optional_key = 'last_user_birthday_mail_send_date'";
    Query query = session.createSQLQuery(sql).addScalar("count", StandardBasicTypes.INTEGER);
    return ((Integer) query.list().get(0)) == 1 ? true : false;
}