Package com.mysema.query

Examples of com.mysema.query.BooleanBuilder

59
60
61
62
63
64
65
66
67
68
69
    {
        {
            Path<Person> person = Expressions.path( Person.class, "n" );
            Path<String> personFirstName = Expressions.path( String.class, person, "firstName" );
            Path<Integer> personAge = Expressions.path( Integer.class, person, "age" );
            BooleanBuilder expr = new BooleanBuilder( predicate( Ops.EQ, personFirstName,
                    constant( "P" ) ) ).and( predicate( Ops.GT, personAge, constant( 25 ) ) );

            Assert.assertEquals( CYPHER + "START n=node(1,2,3) WHERE n.firstName=\"P\" and n.age>25 RETURN n",
                    start( nodesById( identifier( person ), 1, 2, 3 ) )
                            .where( toBooleanExpression( expr ) )
View Full Code Here
140
141
142
143
144
145
146
        }
    }

    @Test
    public void Empty_BooleanBuilder() {
        assertEquals("empty boolean builder", 2, query(product, new BooleanBuilder()).size());
    }
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
public class HibernateQueryTest {

    @Test
    public void Clone() {
        QCat cat = QCat.cat;
        BooleanBuilder emptyBooleanBuilder = new BooleanBuilder();
        HibernateQuery hq = new HibernateQuery().from(cat).where(cat.name.isNull().and(emptyBooleanBuilder));

        HibernateQuery hq2 = hq.clone();
        assertNotNull(hq2);
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
                cat.isNull().and(kitten.isNull().or(kitten.bodyWeight.gt(10))));
    }

    @Test
    public void BooleanBuilder1() {
        BooleanBuilder bb1 = new BooleanBuilder();
        bb1.and(cat.eq(cat));

        BooleanBuilder bb2 = new BooleanBuilder();
        bb2.or(cat.eq(cat));
        bb2.or(cat.eq(cat));

        assertToString("cat = cat and (cat = cat or cat = cat)", bb1.and(bb2));
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
        assertToString("cat = cat and (cat = cat or cat = cat)", bb1.and(bb2));
    }

    @Test
    public void BooleanBuilder2() {
        BooleanBuilder bb1 = new BooleanBuilder();
        bb1.and(cat.eq(cat));

        BooleanBuilder bb2 = new BooleanBuilder();
        bb2.or(cat.eq(cat));
        bb2.or(cat.eq(cat));

        assertToString("cat = cat and (cat = cat or cat = cat)", bb1.and(bb2.getValue()));
    }
View Full Code Here
88
89
90
91
92
93
94
        assertToString("cat = cat and (cat = cat or cat = cat)", bb1.and(bb2.getValue()));
    }

    @Test
    public void BooleanBuilder_With_Null_In_Where() {
        assertEquals("select cat\nfrom Cat cat", sub().from(cat).where(new BooleanBuilder()).toString());
    }
View Full Code Here
94
95
96
97
98
99
100
    }
   
    @Test
    public void BooleanBuilder_With_Null_In_Having() {
        assertEquals("select cat\nfrom Cat cat\ngroup by cat.name",
                sub().from(cat).groupBy(cat.name).having(new BooleanBuilder()).toString());
    }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
        return foreignColumns;
    }

    @SuppressWarnings("unchecked")
    public Predicate on(RelationalPath<E> entity) {
        BooleanBuilder builder = new BooleanBuilder();
        for (int i = 0; i < localColumns.size(); i++) {
            Expression<Object> local = (Expression<Object>)localColumns.get(i);
            Expression<?> foreign = new PathImpl(local.getType(), entity, foreignColumns.get(i));
            builder.and(ExpressionUtils.eq(local,foreign));
        }
        return builder.getValue();
    }
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
    }

    @SuppressWarnings("unchecked")
    private <T> BooleanBuilder getByExample(T entity) {
        PathBuilder<T> entityPath = new PathBuilder<T>((Class<T>)entity.getClass(), "entity");
        BooleanBuilder conditions = new BooleanBuilder();
        Map<String, Object> beanMap = new BeanMap(entity);
        for (Map.Entry<String,Object> entry : beanMap.entrySet()) {
            if (!entry.getKey().equals("class")) {
                if (entry.getValue() != null) {
                    conditions.and(entityPath.get(entry.getKey()).eq(entry.getValue()));
                }
            }
        }
        return conditions;
    }
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
    }

    @Test
    public void Boolean() {
        QSurvey s = new QSurvey("s");
        BooleanBuilder bb1 = new BooleanBuilder();
        bb1.and(s.name.eq(s.name));

        BooleanBuilder bb2 = new BooleanBuilder();
        bb2.or(s.name.eq(s.name));
        bb2.or(s.name.eq(s.name));

        String str = new SQLSerializer(Configuration.DEFAULT).handle(bb1.and(bb2)).toString();
        assertEquals("s.NAME = s.NAME and (s.NAME = s.NAME or s.NAME = s.NAME)", str);
    }
View Full Code Here
TOP

Related Classes of com.mysema.query.BooleanBuilder

  • com.commafeed.backend.dao.FeedDAO
  • com.commafeed.backend.dao.FeedEntryStatusDAO
  • com.mysema.query.jdo.BasicsTest
  • com.mysema.query.jpa.BooleanOperationsTest
  • com.mysema.query.jpa.HibernateQueryTest
  • com.mysema.query.sql.ForeignKey
  • com.mysema.query.sql.SQLSerializerTest
  • com.mysema.query.types.path.PathBuilderTest
  • org.neo4j.cypherdsl.querydsl.QueryDSLTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.