Example usage for org.hibernate.type StringType INSTANCE

Introduction

In this page you can find the example usage for org.hibernate.type StringType INSTANCE.

Prototype

StringType INSTANCE

To view the source code for org.hibernate.type StringType INSTANCE.

Click Source Link

Usage

From source file:org.opennms.web.filter.IPLikeFilter.java

License:Open Source License

/** {@inheritDoc} */
@Override/*from w  w  w  .jav a  2 s .  c o m*/
public Criterion getCriterion() {
    return Restrictions.sqlRestriction("iplike( {alias}." + getPropertyName() + ", ?)", getValue(),
            StringType.INSTANCE);
}

From source file:org.opennms.web.notification.filter.UserFilter.java

License:Open Source License

/** {@inheritDoc} */
@Override/*from   w w  w . ja v a 2  s.com*/
public Criterion getCriterion() {

    return Restrictions.sqlRestriction(
            " {alias}.notifyId in (SELECT DISTINCT usersnotified.notifyid FROM usersnotified WHERE usersnotified.userid=?)",
            getValue(), StringType.INSTANCE);
}

From source file:org.opennms.web.outage.filter.AssetFilter.java

License:Open Source License

/** {@inheritDoc} */
@Override/*from   ww w.j  a  v a 2s.  c om*/
public Criterion getCriterion() {
    return Restrictions.sqlRestriction(
            " {alias}.ifserviceid IN (SELECT DISTINCT ifservices.id FROM ifservices, ipinterface, assets WHERE ifservices.ipinterfaceid = ipinterface.id AND ipinterface.nodeid = assets.nodeid AND assets."
                    + assetField + "=?)",
            getValue(), StringType.INSTANCE);
}

From source file:org.opennms.web.outage.filter.ForeignSourceFilter.java

License:Open Source License

/** {@inheritDoc} */
@Override// w w  w  .ja v  a  2s  . c om
public Criterion getCriterion() {
    return Restrictions.sqlRestriction(
            " {alias}.nodeid in (SELECT DISTINCT NODE.nodeID FROM NODE WHERE NODE.foreignSource=?)", getValue(),
            StringType.INSTANCE);
}

From source file:org.opennms.web.outage.filter.NegativeForeignSourceFilter.java

License:Open Source License

/** {@inheritDoc} */
@Override//from ww  w  .ja v  a 2 s.  c o m
public Criterion getCriterion() {
    return Restrictions.sqlRestriction(
            " {alias}.nodeid not in (SELECT DISTINCT NODE.nodeID FROM NODE WHERE NODE.foreignSource=?)",
            getValue(), StringType.INSTANCE);
}

From source file:org.primeframework.persistence.hibernate.MoneyCurrencyType.java

License:Open Source License

@Override
public Object nullSafeGet(ResultSet rs, String[] names, SessionImplementor session, Object owner)
        throws HibernateException, SQLException {
    Object amount = BigDecimalType.INSTANCE.nullSafeGet(rs, names[0], session, owner);
    Object currency = StringType.INSTANCE.nullSafeGet(rs, names[1], session, owner);
    if (amount == null || currency == null) {
        return null;
    }//from  w  ww .  j a  v a  2 s  .  com

    return Money.of(CurrencyUnit.getInstance((String) currency), (BigDecimal) amount);
}

From source file:org.primeframework.persistence.hibernate.MoneyCurrencyType.java

License:Open Source License

@Override
public void nullSafeSet(PreparedStatement st, Object value, int index, SessionImplementor session)
        throws HibernateException, SQLException {
    if (value == null) {
        BigDecimalType.INSTANCE.nullSafeSet(st, value, index, session);
        StringType.INSTANCE.nullSafeSet(st, null, index + 1, session);
    } else {/*from   w w  w .j a  v  a2s  .c o m*/
        Money money = (Money) value;
        BigDecimalType.INSTANCE.nullSafeSet(st, money.getAmount(), index, session);
        StringType.INSTANCE.nullSafeSet(st, money.getCurrencyUnit().getCurrencyCode(), index + 1, session);
    }
}

From source file:org.squashtest.tm.domain.jpql.SessionFactoryEnhancer.java

License:Open Source License

public static void registerExtensions(Configuration hibConfig, FnSupport... fnSupports) {

    // aggregate function wrappers
    hibConfig.addSqlFunction(FN_NAME_SUM, new StandardSQLFunction("sum"));
    hibConfig.addSqlFunction(FN_NAME_MIN, new StandardSQLFunction("min"));
    hibConfig.addSqlFunction(FN_NAME_MAX, new StandardSQLFunction("max"));
    hibConfig.addSqlFunction(FN_NAME_AVG, new StandardSQLFunction("avg", DoubleType.INSTANCE));
    hibConfig.addSqlFunction(FN_NAME_CNT, new SCountDistinctFunction());

    // boolean case when

    // database-specific functions
    for (FnSupport support : fnSupports) {
        switch (support) {
        case GROUP_CONCAT:
            hibConfig.addSqlFunction(FN_NAME_GROUP_CONCAT,
                    new GroupConcatFunction(FN_NAME_GROUP_CONCAT, StringType.INSTANCE));
            break;
        case STR_AGG:
            hibConfig.addSqlFunction(FN_NAME_GROUP_CONCAT,
                    new StringAggFunction(FN_NAME_GROUP_CONCAT, StringType.INSTANCE));
            break;
        case EXTRACT_WEEK:
            hibConfig.addSqlFunction(FN_NAME_WEEK, new ExtractWeek(FN_NAME_WEEK, IntegerType.INSTANCE));
        }/*  w  ww.j a  v a 2 s  .  co m*/
    }

}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateAutomatedSuiteDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override//ww w.j av  a2 s  .com
public List<AutomatedSuite> findAllByIds(Collection<String> ids) {
    if (ids.isEmpty()) {
        return Collections.emptyList();
    } else {
        Query query = currentSession().getNamedQuery("automatedSuite.findAllById");
        query.setParameterList("suiteIds", ids, StringType.INSTANCE);
        return query.list();
    }
}

From source file:org.squashtest.tm.service.internal.repository.hibernate.HibernateCampaignDao.java

License:Open Source License

private Query assignParameterValuesToTestPlanQuery(String queryString, long campaignId,
        ColumnFiltering filtering) {//from   w  ww.  ja  v  a 2  s  .  c o  m

    Query query = currentSession().createQuery(queryString);

    query.setParameter(ParameterNames.CAMPAIGN_ID, campaignId, LongType.INSTANCE);

    if (filtering.hasFilter(PROJECT_DATA)) {
        query.setParameter(PROJECT_FILTER, "%" + filtering.getFilter(PROJECT_DATA) + "%", StringType.INSTANCE);
    }
    if (filtering.hasFilter(REFERENCE_DATA)) {
        query.setParameter(REFERENCE_FILTER, "%" + filtering.getFilter(REFERENCE_DATA) + "%",
                StringType.INSTANCE);
    }
    if (filtering.hasFilter(TESTCASE_DATA)) {
        query.setParameter(TESTCASE_FILTER, "%" + filtering.getFilter(TESTCASE_DATA) + "%",
                StringType.INSTANCE);
    }
    if (filtering.hasFilter(DATASET_DATA)) {
        query.setParameter(DATASET_FILTER, "%" + filtering.getFilter(DATASET_DATA) + "%", StringType.INSTANCE);
    }
    if (filtering.hasFilter(USER_DATA) && !"0".equals(filtering.getFilter(USER_DATA))) {
        query.setParameter(USER_FILTER, Long.parseLong(filtering.getFilter(USER_DATA)), LongType.INSTANCE);
    }
    if (filtering.hasFilter(WEIGHT_DATA)) {
        query.setParameter(WEIGHT_FILTER, filtering.getFilter(WEIGHT_DATA), StringType.INSTANCE);
    }

    return query;
}