Examples of BooleanBuilder

com.mysema.query.BooleanBuilder
BooleanBuilder is a cascading builder for {@link Predicate} expressions. BooleanBuilder is a mutableExpression implementation.
Usage example:
```
 QEmployee employee = QEmployee.employee; BooleanBuilder builder = new BooleanBuilder(); for (String name : names) { builder.or(employee.name.equalsIgnoreCase(name));       } 
```
@author tiwe
org.sql.generation.api.grammar.builders.booleans.BooleanBuilder

Examples of com.mysema.query.BooleanBuilder


    if (keywords != null) {
      query.join(entry.content, content);


      for (FeedEntryKeyword keyword : keywords) {
        BooleanBuilder or = new BooleanBuilder();
        or.or(content.content.containsIgnoreCase(keyword.getKeyword()));
        or.or(content.title.containsIgnoreCase(keyword.getKeyword()));
        if (keyword.getMode() == Mode.EXCLUDE) {
          or.not();
        }
        query.where(or);
      }
    }
    query.leftJoin(entry.statuses, status).on(status.subscription.id.eq(sub.getId()));


    if (unreadOnly && tag == null) {
      BooleanBuilder or = new BooleanBuilder();
      or.or(status.read.isNull());
      or.or(status.read.isFalse());
      query.where(or);


      Date unreadThreshold = config.getApplicationSettings().getUnreadThreshold();
      if (unreadThreshold != null) {
        query.where(entry.updated.goe(unreadThreshold));
      }
    }


    if (tag != null) {
      BooleanBuilder and = new BooleanBuilder();
      and.and(entryTag.user.id.eq(user.getId()));
      and.and(entryTag.name.eq(tag));
      query.join(entry.tags, entryTag).on(and);
    }


    if (newerThan != null) {
      query.where(entry.inserted.goe(newerThan));

View Full Code Here

Examples of com.mysema.query.BooleanBuilder

  public FeedDAO(SessionFactory sessionFactory) {
    super(sessionFactory);
  }


  public List<Feed> findNextUpdatable(int count, Date lastLoginThreshold) {
    BooleanBuilder disabledDatePredicate = new BooleanBuilder();
    disabledDatePredicate.or(feed.disabledUntil.isNull());
    disabledDatePredicate.or(feed.disabledUntil.lt(new Date()));


    HibernateQuery query = newQuery().from(feed);
    if (lastLoginThreshold != null) {
      QFeedSubscription subs = QFeedSubscription.feedSubscription;
      QUser user = QUser.user;

View Full Code Here

Examples of org.sql.generation.api.grammar.builders.booleans.BooleanBuilder

                if( value instanceof Collection<?> )
                {
                    throw new IllegalArgumentException(
                        "ContainsPredicate may have only either primitive or value composite as value." );
                }
                BooleanBuilder condition = b.booleanBuilder();
                modifyFromClauseAndWhereClauseToGetValue(
                    QualifiedName.fromAccessor( predicate.collectionProperty().accessor() ), value, predicate,
                    false, lastTableIndex, new ModifiableInt( lastTableIndex ),
                    DBNames.QNAME_TABLE_VALUE_COLUMN_NAME,
                    DBNames.QNAME_TABLE_COLLECTION_PATH_TOP_LEVEL_NAME,
                    vendor, condition, afterWhere, builder.getFrom().getTableReferences()
                    .iterator().next(),
                    builder.getGroupBy(), builder.getHaving(), new ArrayList<QNameJoin>(),
                    variables, values, valueSQLTypes );
                builder.getWhere().and( condition.createExpression() );
            }
            } //
        );


        return this.finalizeContainsQuery( vendor, contains, entityTypeCondition, negationActive );

View Full Code Here

Examples of org.sql.generation.api.grammar.builders.booleans.BooleanBuilder

                    {
                        throw new IllegalArgumentException(
                            "ContainsAllPredicate may not have nested collections as value." );
                    }


                    BooleanBuilder conditionForItem = b.booleanBuilder(
                        b.regexp( c.colName( TABLE_NAME_PREFIX + lastTableIndex,
                                             DBNames.QNAME_TABLE_COLLECTION_PATH_COLUMN_NAME ),
                                  l.s( DBNames.QNAME_TABLE_COLLECTION_PATH_TOP_LEVEL_NAME + ".*{1,}" ) ) );
                    modifyFromClauseAndWhereClauseToGetValue(
                        QualifiedName.fromAccessor( predicate.collectionProperty().accessor() ),
                        value, predicate, false, lastTableIndex,
                        new ModifiableInt( lastTableIndex ),
                        DBNames.QNAME_TABLE_VALUE_COLUMN_NAME,
                        DBNames.QNAME_TABLE_COLLECTION_PATH_TOP_LEVEL_NAME, vendor,
                        conditionForItem, afterWhere,
                        builder.getFrom().getTableReferences().iterator().next(),
                        builder.getGroupBy(), builder.getHaving(),
                        joins, variables, values, valueSQLTypes );
                    builder.getWhere().or( conditionForItem.createExpression() );


                }


                builder.getHaving()
                    .and(

View Full Code Here

Examples of org.sql.generation.api.grammar.builders.booleans.BooleanBuilder

                + ", assoRef=" + assoRef + ", predicate=" + predicate + "]." );
        }


        builder.getFrom().addTableReferences( from );


        BooleanBuilder afterWhere = vendor.getBooleanFactory().booleanBuilder();
        whereClauseGenerator.processWhereClause( builder, afterWhere, joinStyle, startingIndex, lastTableIndex );


        BooleanBuilder where = builder.getWhere();
        if( negationActive )
        {
            where.not();
        }
        where.and( afterWhere.createExpression() );


        where.and( entityTypeCondition );


        builder.trimGroupBy();


        return builder.createExpression();
    }

View Full Code Here

Examples of org.sql.generation.api.grammar.builders.booleans.BooleanBuilder

            Boolean topLevel = collectionPath.equals( DBNames.QNAME_TABLE_COLLECTION_PATH_TOP_LEVEL_NAME );
            String collTable = TABLE_NAME_PREFIX + currentTableIndex;
            String collCol = DBNames.QNAME_TABLE_COLLECTION_PATH_COLUMN_NAME;
            ColumnReferenceByName collColExp = c.colName( collTable, collCol );


            BooleanBuilder collectionCondition = b.booleanBuilder();


            if( topLevel && negationActive )
            {
                afterWhere
                    .and( b
                        .booleanBuilder(
                            b.neq( collColExp,
                                   l.s( DBNames.QNAME_TABLE_COLLECTION_PATH_TOP_LEVEL_NAME ) ) )
                        .or( b.isNull( collColExp ) ).createExpression() );
            }


            Integer totalItemsProcessed = 0;
            for( Object item : (Collection<?>) value )
            {
                String path = collectionPath + DBNames.QNAME_TABLE_COLLECTION_PATH_SEPARATOR
                              + ( collectionIsSet ? "*{1,}" : collectionIndex );
                Boolean isCollection = ( item instanceof Collection<?> );
                BooleanBuilder newWhere = b.booleanBuilder();
                if( !isCollection )
                {
                    newWhere.reset( b.regexp( collColExp, l.s( path ) ) );
                }
                totalItemsProcessed
                = totalItemsProcessed
                  + modifyFromClauseAndWhereClauseToGetValue( qName, item, predicate,
                                                              negationActive,
                                                              currentTableIndex, maxTableIndex, columnName, path, vendor,
                                                              newWhere, afterWhere, fromClause,
                                                              groupBy, having, qNameJoins, variables, values, valueSQLTypes );


                ++collectionIndex;
                collectionCondition.or( newWhere.createExpression() );
            }
            result = totalItemsProcessed;


            if( topLevel )
            {

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.