Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.EJBQLQuery

218
219
220
221
222
223
224
225
226
227
228
        createFivePaintings();

        String ejbql = "SELECT p.estimatedPrice, count(p) FROM Painting p"
                + " GROUP BY p.estimatedPrice"
                + " HAVING count(p) > 2";
        EJBQLQuery query = new EJBQLQuery(ejbql);

        List<?> data = context.performQuery(query);
        assertEquals(1, data.size());
        assertTrue(data.get(0) instanceof Object[]);
View Full Code Here
235
236
237
238
239
240
241
242
243
244
245
        createFivePaintings();

        String ejbql = "SELECT p.estimatedPrice, count(p) FROM Painting p"
                + " GROUP BY p.estimatedPrice"
                + " HAVING count(p) > 2 AND p.estimatedPrice < 10";
        EJBQLQuery query = new EJBQLQuery(ejbql);

        List<?> data = context.performQuery(query);
        assertEquals(1, data.size());
        assertTrue(data.get(0) instanceof Object[]);
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
    }

    public void testGroupByJoinedRelatedEntities() throws Exception {
        createFourArtistsAndTwoPaintings();

        EJBQLQuery query = new EJBQLQuery(
                "SELECT COUNT(p), p.toArtist FROM Painting p GROUP BY p.toArtist ");
        List<Object[]> data = context.performQuery(query);
        assertNotNull(data);
        assertEquals(2, data.size());
View Full Code Here
272
273
274
275
276
277
278
279
280
281
282
        assertTrue("error artistName:" + artistName, expectedArtists.contains(artistName));
    }

    public void testGroupByJoinedEntities() throws Exception {
        createArtistsPaintingGalleries();
        EJBQLQuery query = new EJBQLQuery(
                "SELECT COUNT(p), p.toArtist, p.toGallery FROM Painting p "
                        + "GROUP BY p.toGallery, p.toArtist ");
        List<Object[]> data = context.performQuery(query);
        assertNotNull(data);
        assertEquals(2, data.size());
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
    }

    public void testGroupByJoinedEntityInCount() throws Exception {
        createArtistsPaintingGalleries();

        EJBQLQuery query = new EJBQLQuery(
                "SELECT COUNT(p.toArtist), p.paintingTitle FROM Painting p "
                        + "GROUP BY p.paintingTitle "
                        + "HAVING p.paintingTitle LIKE 'P1%'");
        List<Object[]> data = context.performQuery(query);
        assertNotNull(data);
View Full Code Here
318
319
320
321
322
323
324
325
326
327
328
329
330
    public void testGroupByChainedJoins() throws Exception {
        createFivePaintings();

        String ejbql = "SELECT p.painting.toArtist.paintingArray FROM PaintingInfo p"
                + " GROUP BY p.painting.toArtist.paintingArray";
        EJBQLQuery query = new EJBQLQuery(ejbql);
        context.performQuery(query);

        ejbql = "SELECT p.painting.toArtist FROM PaintingInfo p"
                + " GROUP BY p.painting.toArtist";
        query = new EJBQLQuery(ejbql);
        context.performQuery(query);
    }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
        String ejbql = "SELECT DISTINCT a "
                + "FROM Artist a, Painting b "
                + "WHERE a.artistName = b.paintingTitle";

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

        Set<String> names = new HashSet<String>(2);
        Iterator<?> it = artists.iterator();
View Full Code Here
132
133
134
135
136
137
138
139
140
        String ejbql = "SELECT a "
                + "FROM Artist a INNER JOIN a.paintingArray p "
                + "WHERE a.artistName = 'AA1'";

        List<?> artists = context.performQuery(new EJBQLQuery(ejbql));
        assertEquals(1, artists.size());
        assertEquals(33001, Cayenne.intPKForObject((Artist) artists.get(0)));
    }
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
        String ejbql = "SELECT a "
                + "FROM Artist a LEFT JOIN a.paintingArray p "
                + "WHERE a.artistName = 'AA1'";

        List<?> artists = context.performQuery(new EJBQLQuery(ejbql));
        assertEquals(2, artists.size());
        Set<Object> ids = new HashSet<Object>(2);
        Iterator<?> it = artists.iterator();
        while (it.hasNext()) {
            Artist a = (Artist) it.next();
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
        String ejbql = "SELECT a "
                + "FROM Artist a JOIN a.paintingArray p JOIN p.toGallery g "
                + "WHERE g.galleryName = 'gallery2'";

        EJBQLQuery query = new EJBQLQuery(ejbql);

        List<?> artists = context.performQuery(query);
        assertEquals(1, artists.size());
        assertEquals(33002, Cayenne.intPKForObject((Artist) artists.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.