Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.EJBQLQuery

401
402
403
404
405
406
407
408
409
410
    public void testLessOrEquals() throws Exception {
        createGreaterThanDataSet();

        String ejbql = "SELECT p FROM Painting p WHERE p.estimatedPrice <= :estimatedPrice";

        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("estimatedPrice", new BigDecimal(4000));
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());
    }
View Full Code Here
412
413
414
415
416
417
418
419
420
421
422
423
    public void testCollectionNotMemberOfParameter() throws Exception {
        createCollectionDataSet();

        String ejbql = "SELECT a FROM Artist a WHERE :x NOT MEMBER a.paintingArray";

        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("x", Cayenne.objectForPK(context, Painting.class, 33010));
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());

        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
View Full Code Here
434
435
436
437
438
439
440
441
442
443
444
        createCollectionDataSet();

        String ejbql = "SELECT p FROM Painting p, Artist a "
                + "WHERE p MEMBER OF a.paintingArray AND a.artistName = 'B'";

        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());

        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
            String ejbql,
            final Map<Integer, Object> queryParameters) {
        EJBQLParser parser = EJBQLParserFactory.getParser();
        EJBQLCompiledExpression select = parser.compile(ejbql, getDomain()
                .getEntityResolver());
        EJBQLQuery query = new EJBQLQuery(ejbql) {

            @Override
            public Map<Integer, Object>  getPositionalParameters(){
                return queryParameters;
            }
View Full Code Here
288
289
290
291
292
293
294
295
296
297
298
299
    public void testEqualsNullParameter() {
        String ejbql = "select p from Painting p WHERE p.toArtist=:x";
        EJBQLParser parser = EJBQLParserFactory.getParser();
        EJBQLCompiledExpression select = parser.compile(ejbql, getDomain()
                .getEntityResolver());
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("x", null);

        EJBQLTranslationContext tr = new EJBQLTranslationContext(getDomain()
                .getEntityResolver(), query, select, new JdbcEJBQLTranslatorFactory());
        select.getExpression().visit(new EJBQLSelectTranslator(tr));
        String sql = tr.getQuery().getDefaultTemplate();
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
    public void testOrderByDefault() throws Exception {

        createThreePaintings();

        String ejbql1 = "SELECT p FROM Painting p ORDER BY p.paintingTitle";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results1 = context.performQuery(query1);
        assertEquals(3, results1.size());

        assertEquals(33001, Cayenne.intPKForObject((Persistent) results1.get(0)));
        assertEquals(33002, Cayenne.intPKForObject((Persistent) results1.get(1)));
        assertEquals(33003, Cayenne.intPKForObject((Persistent) results1.get(2)));

        String ejbql2 = "SELECT p FROM Painting p ORDER BY p.estimatedPrice";
        EJBQLQuery query2 = new EJBQLQuery(ejbql2);

        List<?> results2 = context.performQuery(query2);
        assertEquals(3, results2.size());

        assertEquals(33003, Cayenne.intPKForObject((Persistent) results2.get(0)));
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
    public void testOrderByAsc() throws Exception {

        createThreePaintings();

        String ejbql1 = "SELECT p FROM Painting p ORDER BY p.paintingTitle ASC";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results1 = context.performQuery(query1);
        assertEquals(3, results1.size());

        assertEquals(33001, Cayenne.intPKForObject((Persistent) results1.get(0)));
        assertEquals(33002, Cayenne.intPKForObject((Persistent) results1.get(1)));
        assertEquals(33003, Cayenne.intPKForObject((Persistent) results1.get(2)));

        String ejbql2 = "SELECT p FROM Painting p ORDER BY p.estimatedPrice ASC";
        EJBQLQuery query2 = new EJBQLQuery(ejbql2);

        List<?> results2 = context.performQuery(query2);
        assertEquals(3, results2.size());

        assertEquals(33003, Cayenne.intPKForObject((Persistent) results2.get(0)));
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
    public void testOrderByDesc() throws Exception {
        createThreePaintings();

        String ejbql1 = "SELECT p FROM Painting p ORDER BY p.paintingTitle DESC";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results1 = context.performQuery(query1);
        assertEquals(3, results1.size());

        assertEquals(33003, Cayenne.intPKForObject((Persistent) results1.get(0)));
        assertEquals(33002, Cayenne.intPKForObject((Persistent) results1.get(1)));
        assertEquals(33001, Cayenne.intPKForObject((Persistent) results1.get(2)));

        String ejbql2 = "SELECT p FROM Painting p ORDER BY p.estimatedPrice DESC";
        EJBQLQuery query2 = new EJBQLQuery(ejbql2);

        List<?> results2 = context.performQuery(query2);
        assertEquals(3, results2.size());

        assertEquals(33001, Cayenne.intPKForObject((Persistent) results2.get(0)));
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
    public void testOrderByQualified() throws Exception {
        createThreePaintings();

        String ejbql1 = "SELECT p FROM Painting p WHERE p.estimatedPrice > 1000 ORDER BY p.paintingTitle ASC";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results1 = context.performQuery(query1);
        assertEquals(2, results1.size());

        assertEquals(33001, Cayenne.intPKForObject((Persistent) results1.get(0)));
        assertEquals(33002, Cayenne.intPKForObject((Persistent) results1.get(1)));

        String ejbql2 = "SELECT p FROM Painting p WHERE p.estimatedPrice > 1000 ORDER BY p.estimatedPrice ASC";
        EJBQLQuery query2 = new EJBQLQuery(ejbql2);

        List<?> results2 = context.performQuery(query2);
        assertEquals(2, results2.size());

        assertEquals(33002, Cayenne.intPKForObject((Persistent) results2.get(0)));
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
    public void testOrderByMultiple() throws Exception {
        createFourPaintings();

        String ejbql1 = "SELECT p FROM Painting p ORDER BY p.paintingTitle DESC, p.estimatedPrice DESC";
        EJBQLQuery query1 = new EJBQLQuery(ejbql1);

        List<?> results1 = context.performQuery(query1);
        assertEquals(4, results1.size());

        assertEquals(33003, Cayenne.intPKForObject((Persistent) results1.get(0)));
View Full Code Here
TOP

Related Classes of org.apache.cayenne.query.EJBQLQuery

  • com.adaptrex.core.persistence.cayenne.CayenneStoreData
  • org.apache.cayenne.access.DataContextEJBQLArrayResultTest
  • org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest
  • org.apache.cayenne.access.DataContextEJBQLConditionsTest
  • org.apache.cayenne.access.DataContextEJBQLDeleteTest
  • org.apache.cayenne.access.DataContextEJBQLFetchJoinTest
  • org.apache.cayenne.access.DataContextEJBQLFlattenedRelationshipsTest
  • org.apache.cayenne.access.DataContextEJBQLFunctionalExpressions
  • org.apache.cayenne.access.DataContextEJBQLFunctionalExpressionsTemp
  • org.apache.cayenne.access.DataContextEJBQLGroupByHavingTest
    • 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.