Package com.mysema.query.types.expr

Examples of com.mysema.query.types.expr.BooleanExpression

110
111
112
113
114
115
116
117
118
119
120
        assertEquals(Arrays.asList("Robert", "John", "Barbara", "Anton"), desc);
    }

    @Test
    public void Paging() {
        BooleanExpression filter = user.middleName.eq("X");
        OrderSpecifier<?> order = user.firstName.asc();

        // limit
        List<String> limit = getFirstNames(query().where(filter).orderBy(order)
                .limit(2).list());
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
        assertEquals(Arrays.asList("Barbara", "John"), limitAndOffset);
    }

    @Test
    public void ListResults() {
        BooleanExpression filter = user.middleName.eq("X");
        SearchResults<User> users = query().where(filter).orderBy(
                user.firstName.asc()).limit(2).listResults();
        List<String> asc = getFirstNames(users.getResults());
        assertEquals(Arrays.asList("Anton", "Barbara"), asc);
        assertEquals(4, users.getTotal());
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
        }
    }
   
    @Test
    public void ScalarQueries() {
        BooleanExpression filter = product.name.startsWith("A");
       
        // count
        assertEquals(10l, sql().from(product).where(filter).count());

        // countDistinct
View Full Code Here
153
154
155
156
157
158
159
160
161
162
163
    @Test
    public void QueryElement() throws Exception{
        Query query1 = serializer.toQuery(author.like("Michael"), metadata);
        Query query2 = serializer.toQuery(text.like("Text"), metadata);

        BooleanExpression query = BooleanExpression.anyOf(
            new QueryElement(query1),
            new QueryElement(query2)
        );
        testQuery(query, "author:michael text:text", 1);
    }
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
207
            throw new UnsupportedOperationException("No primary keys available");
        }
        if (pk1.getLocalColumns().size() != pk2.getLocalColumns().size()) {
            throw new UnsupportedOperationException("Size mismatch for primary key columns");
        }
        BooleanExpression rv = null;
        for (int i = 0; i < pk1.getLocalColumns().size(); i++) {
            BooleanExpression pred = BooleanOperation.create(op, pk1.getLocalColumns().get(i), pk2.getLocalColumns().get(i));
            rv = rv != null ? rv.and(pred) : pred;
        }
        return rv;
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
                        StringExpression str = (StringExpression)rv;
                        toVisit.add(str.toLowerCase());
                        toVisit.add(str.charAt(0));
                        toVisit.add(str.isEmpty());
                    } else if (rv instanceof BooleanExpression) {
                        BooleanExpression b = (BooleanExpression)rv;
                        toVisit.add(b.not());
                    }
                    toVisit.add((Expression<?>) rv);
                }
            }
        }
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
    @Test
    public void QueryElement() throws Exception{
        Query query1 = serializer.toQuery(author.like("Michael"), metadata);
        Query query2 = serializer.toQuery(text.like("Text"), metadata);

        BooleanExpression query = BooleanExpression.anyOf(
            new QueryElement(query1),
            new QueryElement(query2)
        );
        testQuery(query, "author:michael text:text", 1);
    }
View Full Code Here
222
223
224
225
226
227
228
229
230
231
    @Test
    @Ignore // isn't a valid JPQL query
    public void Subquery_UniqueResult() {
        QCat cat2 = new QCat("cat2");

        BooleanExpression exists = new JPASubQuery().from(cat2).where(cat2.eyecolor.isNotNull()).exists();
        assertNotNull(query().from(cat)
                .where(cat.breed.eq(0).not())
                .singleResult(new QCatSummary(cat.breed.count(), exists)));
    }
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
        assertNotNull(beanPath.instanceOf(BeanPathTest.class));
    }
   
    @Test
    public void InstanceOfAny() {
        BooleanExpression pred1 = beanPath.instanceOf(BeanPathTest.class).or(beanPath.instanceOf(SubClass.class));
        BooleanExpression pred2 = beanPath.instanceOfAny(BeanPathTest.class, SubClass.class);
        assertEquals(pred1, pred2);
        assertEquals("p.class = class com.mysema.query.types.path.BeanPathTest || " +
               "p.class = class com.mysema.query.types.path.BeanPathTest$SubClass", pred2.toString());
    }
View Full Code Here
13
14
15
16
17
18
19
20
21
22
23
   
    @Test
    public void test() {
        StringPath str1 = new StringPath("str1");
        StringPath str2 = new StringPath("str2");
        BooleanExpression pending = str1.eq("3").and(str2.eq("1"));
        BooleanExpression notNew = str1.ne("1").and(str2.in("2", "3"));      
        BooleanExpression whereClause = str1.eq("a").and(pending.or(notNew));
        String str = new SQLSerializer(Configuration.DEFAULT).handle(whereClause).toString();
        assertEquals("str1 = ? and (str1 = ? and str2 = ? or str1 != ? and str2 in (?, ?))", str);
    }
View Full Code Here
TOP

Related Classes of com.mysema.query.types.expr.BooleanExpression

  • $.BaseService
  • com.excilys.ebi.bank.dao.impl.OperationDaoImpl
  • com.mysema.query.domain.AnyUsageTest
  • com.mysema.query.domain.ExpressionTest
  • com.mysema.query.hibernate.search.SearchQueryTest
  • com.mysema.query.jdo.JDOSQLQueryTest
  • com.mysema.query.JPABase
  • com.mysema.query.LuceneSerializerTest
  • com.mysema.query.PrecedenceTest
  • com.mysema.query.sql.RelationalPathBase
    • 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.