Example usage for org.hibernate.type BooleanType INSTANCE

List of usage examples for org.hibernate.type BooleanType INSTANCE

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.type.*
  5. BooleanType
  6. INSTANCE

Introduction

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

Prototype

BooleanType INSTANCE

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

Click Source Link

Usage

From source file:org.yamj.core.database.dao.ApiDao.java

License:Open Source License

private static SqlScalars generateSqlForBoxedSet(OptionsBoxedSet options) {
    SqlScalars sqlScalars = new SqlScalars();
    sqlScalars.addToSql(/*from   w  w w  .ja  va  2s . c o  m*/
            "SELECT s.id, s.name, count(s.member) as memberCount, min(s.watched_set) as watched FROM (");
    sqlScalars.addToSql("SELECT bs1.id, bs1.name, bo1.id as member,");
    sqlScalars.addToSql("min(vd1.watched_nfo or vd1.watched_file or vd1.watched_api) as watched_set");
    sqlScalars.addToSql("FROM boxed_set bs1");
    sqlScalars.addToSql("LEFT OUTER JOIN boxed_set_order bo1 ON bs1.id=bo1.boxedset_id");
    sqlScalars.addToSql("LEFT OUTER JOIN videodata vd1 ON bo1.videodata_id=vd1.id");
    if (options.getId() > 0L) {
        sqlScalars.addToSql("WHERE bs1.id=" + options.getId());
    }
    sqlScalars.addToSql(SQL_UNION);
    sqlScalars.addToSql("SELECT bs2.id, bs2.name, bo2.id as member,");
    sqlScalars.addToSql(
            "(SELECT min(vid.watched_nfo or vid.watched_file or vid.watched_api) from videodata vid,season sea where vid.season_id=sea.id and sea.series_id=ser.id) as watched_set");
    sqlScalars.addToSql("FROM boxed_set bs2");
    sqlScalars.addToSql("LEFT OUTER JOIN boxed_set_order bo2 ON bs2.id=bo2.boxedset_id");
    sqlScalars.addToSql("LEFT OUTER JOIN series ser ON bo2.series_id=ser.id");
    if (options.getId() > 0L) {
        sqlScalars.addToSql("WHERE bs2.id=" + options.getId());
    }
    sqlScalars.addToSql(") AS s");
    sqlScalars.addToSql("GROUP BY s.id, s.name");
    if (options.getId() <= 0L) {
        if (options.getWatched() != null) {
            if (options.getWatched()) {
                sqlScalars.addToSql(" HAVING min(s.watched_set)=1");
            } else {
                sqlScalars.addToSql(" HAVING min(s.watched_set)=0");
            }
        }
        sqlScalars.addToSql(options.getSortString());
    }

    sqlScalars.addScalar(ID, LongType.INSTANCE);
    sqlScalars.addScalar("name", StringType.INSTANCE);
    sqlScalars.addScalar("memberCount", IntegerType.INSTANCE);
    sqlScalars.addScalar(WATCHED, BooleanType.INSTANCE);

    return sqlScalars;
}

From source file:ru.caramel.juniperbot.core.common.persistence.support.PostgreSQLPlainToTSQueryFunction.java

License:Open Source License

@Override
public Type getReturnType(Type columnType, Mapping mapping) throws QueryException {
    return BooleanType.INSTANCE;
}