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:jp.xet.baseunits.hibernate.PersistentMinuteOfHour.java

License:Apache License

/**
 * ??
 * 
 * @since 1.2
 */
public PersistentMinuteOfHour() {
    super(StandardBasicTypes.INTEGER);
}

From source file:jp.xet.baseunits.hibernate.PersistentMinutesTimeOfDay.java

License:Apache License

/**
 * ??
 * 
 * @since 1.2
 */
public PersistentMinutesTimeOfDay() {
    super(StandardBasicTypes.INTEGER);
}

From source file:nl.rivm.cib.epidemes.geodb.jdbc.PostgisDialectExtended.java

License:Apache License

public PostgisDialectExtended() {
    super();//  w  ww .  ja  v  a 2  s .com
    registerFunction("Transform", new StandardSQLFunction("ST_Transform", StandardBasicTypes.STRING));
    registerFunction("AsGeoJson", new StandardSQLFunction("ST_AsGeoJson", StandardBasicTypes.STRING));
    registerFunction("AsGml", new StandardSQLFunction("ST_AsGml", StandardBasicTypes.STRING));
    registerFunction("AsKml", new StandardSQLFunction("ST_AsKml", StandardBasicTypes.STRING));
    registerFunction("Srid", new StandardSQLFunction("ST_Srid", StandardBasicTypes.INTEGER));
}

From source file:nl.strohalm.cyclos.dao.accounts.AccountDAOImpl.java

License:Open Source License

public Iterator<MemberTransactionSummaryVO> membersTransactionSummaryReport(
        final Collection<MemberGroup> memberGroups, final PaymentFilter paymentFilter, final Period period,
        final boolean credits, final MemberResultDisplay order) {
    final Map<String, Object> parameters = new HashMap<String, Object>();
    final StringBuilder sql = new StringBuilder();

    // Get the transfer types ids
    final List<Long> ttIds = paymentFilter == null ? null
            : Arrays.asList(EntityHelper.toIds(paymentFilter.getTransferTypes()));

    // Get the member group ids
    List<Long> groupIds = null;
    if (CollectionUtils.isNotEmpty(memberGroups)) {
        groupIds = Arrays.asList(EntityHelper.toIds(memberGroups));
    }//from   w w  w.  j ava 2 s  .c o m

    // Get the period
    final QueryParameter beginParameter = HibernateHelper.getBeginParameter(period);
    final QueryParameter endParameter = HibernateHelper.getEndParameter(period);

    // Set the parameters
    final boolean useGroups = CollectionUtils.isNotEmpty(groupIds);
    final boolean useTT = CollectionUtils.isNotEmpty(ttIds);
    if (useGroups) {
        parameters.put("groupIds", groupIds);
    }
    if (useTT) {
        parameters.put("ttIds", ttIds);
    }
    if (beginParameter != null) {
        parameters.put("beginDate", beginParameter.getValue());
    }
    if (endParameter != null) {
        parameters.put("endDate", endParameter.getValue());
    }
    parameters.put("processed", Payment.Status.PROCESSED.getValue());

    // Create the SQL query
    sql.append(" select member_id, sum(count) as count, sum(amount) as amount");
    sql.append(" from (");
    appendMembersTransactionsSummaryReportSqlPart(sql, useGroups, useTT, beginParameter, endParameter, credits,
            true);
    sql.append(" union");
    appendMembersTransactionsSummaryReportSqlPart(sql, useGroups, useTT, beginParameter, endParameter, credits,
            false);
    sql.append(" ) ts");
    sql.append(" group by member_id");
    sql.append(" order by ").append(order == MemberResultDisplay.NAME ? "member_name, member_id" : "username");

    final SQLQuery query = getSession().createSQLQuery(sql.toString());
    query.addScalar("member_id", StandardBasicTypes.LONG);
    query.addScalar("count", StandardBasicTypes.INTEGER);
    query.addScalar("amount", StandardBasicTypes.BIG_DECIMAL);
    getHibernateQueryHandler().setQueryParameters(query, parameters);

    final Transformer<Object[], MemberTransactionSummaryVO> transformer = new Transformer<Object[], MemberTransactionSummaryVO>() {
        public MemberTransactionSummaryVO transform(final Object[] input) {
            final MemberTransactionSummaryVO vo = new MemberTransactionSummaryVO();
            vo.setMemberId((Long) input[0]);
            vo.setCount((Integer) input[1]);
            vo.setAmount((BigDecimal) input[2]);
            return vo;
        }
    };

    return new ScrollableResultsIterator<MemberTransactionSummaryVO>(query, transformer);
}

From source file:nl.strohalm.cyclos.dao.members.ReferenceDAOImpl.java

License:Open Source License

public List<PaymentAwaitingFeedbackDTO> searchPaymentsAwaitingFeedback(
        final PaymentsAwaitingFeedbackQuery query) {

    final ResultType resultType = query.getResultType();
    final PageParameters pageParameters = query.getPageParameters();
    final boolean countOnly = resultType == ResultType.PAGE && pageParameters != null
            && pageParameters.getMaxResults() == 0;

    // There are 2 tables which contains payments that can have feedback: transfers and scheduled payments
    // As we need an union, we need a native SQL

    final Member member = query.getMember();
    Boolean expired = query.getExpired();

    final StringBuilder sql = new StringBuilder();
    sql.append(" select ");
    if (countOnly) {
        sql.append(" count(*) as row_count");
    } else {//  ww  w . j  a v  a  2  s .c om
        sql.append(" * ");
    }
    sql.append(" from ( ");
    {
        sql.append(
                " select t.id, t.type_id as transferTypeId, false as scheduled, t.date, t.amount, tm.id as memberId, tm.name as memberName, ta.owner_name as memberUsername");
        sql.append(
                " from transfers t inner join transfer_types tt on t.type_id = tt.id inner join accounts ta on t.to_account_id = ta.id inner join members tm on ta.member_id = tm.id");
        if (member != null) {
            sql.append(" inner join accounts a on t.from_account_id = a.id");
        }
        sql.append(" left join refs tf on tf.transfer_id = t.id");
        sql.append(" where tt.requires_feedback = true");
        sql.append(" and t.date >= tt.feedback_enabled_since");
        sql.append(" and t.parent_id is null");
        sql.append(" and t.chargeback_of_id is null");
        sql.append(" and t.scheduled_payment_id is null");
        sql.append(" and t.process_date is not null");
        if (expired != null) {
            sql.append(" and t.feedback_deadline " + (expired ? "<" : ">=") + " now()");
        }
        sql.append(" and tf.id is null");
        if (member != null) {
            sql.append(" and a.member_id = :memberId");
        }

        sql.append(" union ");

        sql.append(" select sp.id, sp.type_id, true, sp.date, sp.amount, tm.id, tm.name, ta.owner_name");
        sql.append(
                " from scheduled_payments sp inner join transfer_types tt on sp.type_id = tt.id inner join accounts ta on sp.to_account_id = ta.id inner join members tm on ta.member_id = tm.id");
        if (member != null) {
            sql.append(" inner join accounts a on sp.from_account_id = a.id");
        }
        sql.append(" left join refs tf on tf.scheduled_payment_id = sp.id");
        sql.append(" where tt.requires_feedback = true");
        if (expired != null) {
            sql.append(" and sp.feedback_deadline " + (expired ? "<" : ">=") + " now()");
        }
        sql.append(" and sp.date >= tt.feedback_enabled_since");
        sql.append(" and tf.id is null");
        if (member != null) {
            sql.append(" and a.member_id = :memberId");
        }
    }
    sql.append(") as awaiting ");
    if (!countOnly) {
        sql.append("order by date");
    }

    SQLQuery sqlQuery = getSession().createSQLQuery(sql.toString());
    if (member != null) {
        sqlQuery.setLong("memberId", member.getId());
    }
    if (countOnly) {
        // Handle the special case for count only
        sqlQuery.addScalar("row_count", StandardBasicTypes.INTEGER);
        int count = ((Number) sqlQuery.uniqueResult()).intValue();
        return new PageImpl<PaymentAwaitingFeedbackDTO>(pageParameters, count,
                Collections.<PaymentAwaitingFeedbackDTO>emptyList());
    } else {
        // Execute the search
        sqlQuery.addScalar("id", StandardBasicTypes.LONG);
        sqlQuery.addScalar("transferTypeId", StandardBasicTypes.LONG);
        sqlQuery.addScalar("scheduled", StandardBasicTypes.BOOLEAN);
        sqlQuery.addScalar("date", StandardBasicTypes.CALENDAR);
        sqlQuery.addScalar("amount", StandardBasicTypes.BIG_DECIMAL);
        sqlQuery.addScalar("memberId", StandardBasicTypes.LONG);
        sqlQuery.addScalar("memberName", StandardBasicTypes.STRING);
        sqlQuery.addScalar("memberUsername", StandardBasicTypes.STRING);
        getHibernateQueryHandler().applyPageParameters(pageParameters, sqlQuery);

        // We'll always use an iterator, even if it is for later adding it to a list
        Iterator<PaymentAwaitingFeedbackDTO> iterator = new ScrollableResultsIterator<PaymentAwaitingFeedbackDTO>(
                sqlQuery, new Transformer<Object[], PaymentAwaitingFeedbackDTO>() {
                    public PaymentAwaitingFeedbackDTO transform(final Object[] input) {
                        PaymentAwaitingFeedbackDTO dto = new PaymentAwaitingFeedbackDTO();
                        dto.setId((Long) input[0]);
                        dto.setTransferTypeId((Long) input[1]);
                        dto.setScheduled(Boolean.TRUE.equals(input[2]));
                        dto.setDate((Calendar) input[3]);
                        dto.setAmount((BigDecimal) input[4]);
                        dto.setMemberId((Long) input[5]);
                        dto.setMemberName((String) input[6]);
                        dto.setMemberUsername((String) input[7]);

                        TransferType transferType = (TransferType) getSession().load(TransferType.class,
                                dto.getTransferTypeId());
                        dto.setCurrency(getFetchDao().fetch(transferType.getCurrency()));

                        return dto;
                    }
                });
        if (resultType == ResultType.ITERATOR) {
            return new IteratorListImpl<PaymentAwaitingFeedbackDTO>(iterator);
        } else {
            List<PaymentAwaitingFeedbackDTO> list = new ArrayList<PaymentAwaitingFeedbackDTO>();
            CollectionUtils.addAll(list, iterator);
            DataIteratorHelper.close(iterator);

            if (resultType == ResultType.PAGE) {
                // For page, we need another search for the total count
                query.setPageForCount();
                int totalCount = PageHelper.getTotalCount(searchPaymentsAwaitingFeedback(query));

                return new PageImpl<PaymentAwaitingFeedbackDTO>(pageParameters, totalCount, list);
            } else {
                return list;
            }
        }
    }
}

From source file:org.bedework.calcore.H2Dialect.java

License:Apache License

/**
 *
 *//* w w w  . ja va  2s . c  o m*/
public H2Dialect() {
    super();

    registerColumnType(Types.BIT, "boolean");
    registerColumnType(Types.NUMERIC, "decimal($p,$s)");

    registerFunction("quarter", new StandardSQLFunction("quarter", StandardBasicTypes.INTEGER));
}

From source file:org.eclipse.emf.cdo.server.internal.hibernate.tuplizer.CDOTypeUserType.java

License:Open Source License

public Object nullSafeGet(ResultSet rs, String[] names, SessionImplementor sessionImplementor, Object owner)
        throws SQLException {
    Integer value = StandardBasicTypes.INTEGER.nullSafeGet(rs, names[0], sessionImplementor);
    if (rs.wasNull()) {
        return null;
    }//from  w  w  w. j a v  a2 s  . c  om

    if (value == null) {
        return null;
    }

    return CDOModelUtil.getType((byte) (int) value);
}

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

License:Open Source License

@Override
public Integer getStudiedResourceCount(String contentUid, String userUid, String status) {
    String sql = "SELECT count(distinct(sub_content_uid)) as count from session_activity_item sai inner join session_activity sa on sa.session_activity_uid = sai.session_activity_uid join content c on sai.content_uid = c.gooru_oid WHERE sai.content_uid ='"
            + contentUid + "' AND sa.user_uid = '" + userUid + "' AND sa.status ='" + status + "' AND  "
            + generateOrgAuthSqlQueryWithData("sa.");
    Integer result = (Integer) getSession().createSQLQuery(sql).addScalar("count", StandardBasicTypes.INTEGER)
            .uniqueResult();/*  ww w . j a v a  2s. c om*/
    return result != null ? result : 0;
}

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

License:Open Source License

public Integer countSubscriptionsForUserContent(User user) {

    Query query = getSession().createSQLQuery(COUNT_SUBSCRIPTIONS)
            .addScalar("total", StandardBasicTypes.INTEGER).setParameter("userId", user.getPartyUid());
    addOrgAuthParameters(query);/*w w w  .j  ava 2 s .c  om*/
    List<Integer> subscriptionCounts = query.list();
    return (subscriptionCounts.size() > 0) ? subscriptionCounts.get(0) : 0;
}

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

License:Open Source License

public boolean hasUserSubscribedToUserContent(String userId, String gooruContentId) {

    Query query = getSession().createSQLQuery(GET_SUBSCRIPTION_FOR_A_USER)
            .addScalar("contentid", StandardBasicTypes.INTEGER).setParameter("userId", userId)
            .setParameter("gooruOid", gooruContentId);
    addOrgAuthParameters(query);//w  w w  .j a va2 s .  com
    List<Integer> contentids = query.list();
    if ((contentids != null) && (contentids.size() > 0)) {
        return true;
    } else {
        return false;
    }
}