Example usage for org.hibernate.type StandardBasicTypes INTEGER

List of usage examples for org.hibernate.type StandardBasicTypes INTEGER

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.type.*
  5. StandardBasicTypes
  6. 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.FeedbackRepositoryHibernate.java

License:Open Source License

@Override
public Map<String, Object> getContentFeedbackRating(String assocGooruOid, String feedbackRatingType) {
    Query query = getSession().createSQLQuery(FETCH_CONTENT_FEEDBACK_RATING)
            .addScalar("score", StandardBasicTypes.INTEGER).addScalar("count", StandardBasicTypes.INTEGER)
            .setParameter("assocGooruOid", assocGooruOid)
            .setParameter("feedbackRatingType", feedbackRatingType);
    return getRating(query.list());
}

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

License:Open Source License

private Map<String, Object> getFlags(List<Object[]> results, String sql, String type) {
    List<Map<String, Object>> listFlag = new ArrayList<Map<String, Object>>();
    StorageArea storageArea = this.getStorageRepository()
            .getStorageAreaByTypeName(StorageAccount.Type.NFS.getType());
    for (Object[] object : results) {
        Map<String, Object> flag = new HashMap<String, Object>();
        flag.put("title", object[0]);
        flag.put("description", object[1]);
        flag.put("gooruOid", object[2]);
        flag.put("category", object[3]);
        flag.put("createdOn", object[4]);
        flag.put("value", object[5]);
        flag.put("reportedFlag", object[6]);
        flag.put("userUid", object[7]);
        flag.put("product", object[8]);
        flag.put("reportId", object[9]);
        flag.put("reportCreator", object[10]);
        flag.put("reportCreatedOn", object[11]);
        flag.put("reportDescription", object[12]);
        flag.put("url", object[13]);
        flag.put("browserUrl", object[14]);
        flag.put("sharing", object[16]);
        flag.put("notes", object[17]);
        flag.put("reporterName", object[18]);
        flag.put("resourceCreatorName", object[19]);
        flag.put("thumbnail", object[20]);
        flag.put("hasFrameBreaker", object[21]);
        flag.put("mediaType", object[22]);
        flag.put("lastModifiedOn", object[23]);
        if (type == RESOURCE) {
            String temp = (String) object[15];
            if (temp != null) {
                String[] scollection = temp.split("!#");
                String scollectionList = scollection[1];
                String[] scollectionInfo = scollectionList.split("~");
                flag.put("scollectionCount", scollection[0]);
                flag.put("collectionId", scollectionInfo[0]);
                flag.put("scollectionTitle", scollectionInfo[1]);
            } else {
                flag.put("collectionId", null);
                flag.put("scollectionCount", null);
                flag.put("scollectionTitle", null);
            }/*from  ww w  .java2  s  .c  om*/
        }
        if (flag.get("thumbnail") != null) {
            flag.put("thumbnail", storageArea.getAreaPath().concat(flag.get("thumbnail").toString()));
        }

        listFlag.add(flag);
    }

    sql = "select count(1) as totalCount from (" + sql + ") as flag";
    Query query = getSession().createSQLQuery(sql).addScalar("totalCount", StandardBasicTypes.INTEGER);
    Map<String, Object> result = new HashMap<String, Object>();
    result.put("searchResult", listFlag);
    result.put("totalCount", (Integer) query.list().get(0));
    return result;
}

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

License:Open Source License

@Override
public Map<Object, Object> getContentFeedbackThumbs(String assocGooruOid, String feedbackRatingType) {
    Query query = getSession().createSQLQuery(GET_CONTENT_FEEDBACK_THUMBS)
            .addScalar("thumb_up", StandardBasicTypes.INTEGER)
            .addScalar("thumb_down", StandardBasicTypes.INTEGER).setParameter("assocGooruOid", assocGooruOid)
            .setParameter("feedbackRatingType", feedbackRatingType);
    return getThumbsVotes((Object[]) query.list().get(0));
}

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

License:Open Source License

@Override
public Map<Object, Object> getUserFeedbackThumbs(String assocUserUid, String feedbackRatingType) {
    Query query = getSession().createSQLQuery(GET_USER_FEEDBACK_THUMBS)
            .addScalar("thumb_up", StandardBasicTypes.INTEGER)
            .addScalar("thumb_down", StandardBasicTypes.INTEGER).setParameter("assocUserUid", assocUserUid)
            .setParameter("feedbackRatingType", feedbackRatingType);
    return getThumbsVotes((Object[]) query.list().get(0));
}

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

License:Open Source License

@Override
public Integer getContentFeedbackAggregateByType(String assocGooruOid, String feedbackType) {
    Query query = getSession().createSQLQuery(GET_CONTENT_FEEDBACK_AGGREGATE_BY_TYPE)
            .addScalar("count", StandardBasicTypes.INTEGER).setParameter("assocGooruOid", assocGooruOid)
            .setParameter("feedbackType", feedbackType);
    return (Integer) query.list().get(0);
}

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

License:Open Source License

@Override
public Integer getUserFeedbackAggregateByType(String assocUserUid, String feedbackType) {
    Query query = getSession().createSQLQuery(GET_USER_FEEDBACK_AGGREGATE_BY_TYPE)
            .addScalar("count", StandardBasicTypes.INTEGER).setParameter("assocUserUid", assocUserUid)
            .setParameter("feedbackType", feedbackType);
    return (Integer) query.list().get(0);
}

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

License:Open Source License

@Override
public Map<Object, Object> getUserFeedbackAverage(String assocUserUid, String feedbackCategory) {
    Query query = getSession().createSQLQuery(GET_USER_FEEDBACK_AVERAGE)
            .addScalar("count", StandardBasicTypes.INTEGER).addScalar("name", StandardBasicTypes.STRING)
            .setParameter("assocUserUid", assocUserUid).setParameter("feedbackCategory", feedbackCategory);
    return getFeedbackAverage(query.list());
}

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

License:Open Source License

@Override
public Map<Object, Object> getContentFeedbackAverage(String assocGooruOid, String feedbackCategory) {
    Query query = getSession().createSQLQuery(GET_CONTENT_FEEDBACK_AVERAGE)
            .addScalar("count", StandardBasicTypes.INTEGER).addScalar("name", StandardBasicTypes.STRING)
            .setParameter("assocGooruOid", assocGooruOid).setParameter("feedbackCategory", feedbackCategory);
    return getFeedbackAverage(query.list());
}

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

License:Open Source License

@Override
public List<Map<Object, Object>> getContentFeedbackAggregate(String assocGooruOid, String feedbackCategory,
        Boolean flag) {/*from  w  w w.  j av a  2s. co m*/
    String sql = "";
    if (flag) {
        sql = "select count(1) as count, t.value as name,cc.gooru_oid as collectionId from collection_item ci  inner join collection cn on (ci.collection_content_id = cn.content_id)  inner join content rc on (rc.content_id = ci.resource_content_id)  inner join feedback f on (rc.gooru_oid = f.assoc_gooru_oid) inner join content cc on cc.content_id = cn.content_id inner join custom_table_value c on  c.custom_table_value_id = f.feedback_category_id inner join  custom_table_value t  on  t.custom_table_value_id = f.feedback_type_id inner join  task_resource_assoc tc on tc.resource_content_id = ci.collection_content_id inner join content ct on ct.content_id = tc.task_content_id  where ct.gooru_oid =:assocGooruOid and c.key_value =:feedbackCategory group by f.feedback_type_id,cc.gooru_oid";
    } else {
        sql = "select count(1) as count, t.value as name,cc.gooru_oid as collectionId from collection_item ci  inner join collection cn on (ci.collection_content_id = cn.content_id)  inner join content rc on (rc.content_id = ci.resource_content_id)  inner join feedback f on (rc.gooru_oid = f.assoc_gooru_oid) inner join content cc on cc.content_id = cn.content_id inner join custom_table_value c on  c.custom_table_value_id = f.feedback_category_id inner join  custom_table_value t  on  t.custom_table_value_id = f.feedback_type_id  where cc.gooru_oid =:assocGooruOid and c.key_value =:feedbackCategory and cn.collection_type in ('collection', 'quiz') group by f.feedback_type_id";
    }
    Query query = getSession().createSQLQuery(sql).addScalar("count", StandardBasicTypes.INTEGER)
            .addScalar("name", StandardBasicTypes.STRING).addScalar("collectionId", StandardBasicTypes.STRING)
            .setParameter("assocGooruOid", assocGooruOid).setParameter("feedbackCategory", feedbackCategory);
    return getFeedbackAggregate(query.list());
}

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

License:Open Source License

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