Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.SelectQuery.andQualifier()

49
50
51
52
53
54
55
56
57
58
59
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (2, 'E2', 'EM')"));
        createDataContext().performGenericQuery(insert);
       
        // fetch on leaf, but match on a super attribute
        SelectQuery select = new SelectQuery(Manager.class);
        select.andQualifier(ExpressionFactory.matchExp(AbstractPerson.NAME_PROPERTY, "E2"));
   
        List<Manager> results = createDataContext().performQuery(select);
        assertEquals(1, results.size());
        assertEquals("E2", results.get(0).getName());
    }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
        createDataContext().performGenericQuery(insert);
       
        // fetch on leaf, but match on a super attribute
        SelectQuery select = new SelectQuery(Employee.class);
        select.addPrefetch(Employee.TO_DEPARTMENT_PROPERTY);
        select.andQualifier(ExpressionFactory.matchExp(AbstractPerson.NAME_PROPERTY, "E2"));
   
        List<Manager> results = createDataContext().performQuery(select);
        assertEquals(1, results.size());
        assertEquals("E2", results.get(0).getName());
    }
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
        context.commitChanges();

        SelectQuery query1 = new SelectQuery(Artist.class);

        // per CAY-1074, adding a to-many join to expression messes up the ordering
        query1.andQualifier(ExpressionFactory.noMatchExp(
                Artist.PAINTING_ARRAY_PROPERTY,
                null));
        query1.addOrdering(Artist.ARTIST_NAME_PROPERTY, Ordering.DESC);
        query1.addOrdering(Artist.DATE_OF_BIRTH_PROPERTY, Ordering.DESC);
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
        Artist picasso = DataObjectUtils.objectForPK(context, Artist.class, 1);
        Artist dali = DataObjectUtils.objectForPK(context, Artist.class, 2);

        SelectQuery query = new SelectQuery(Gallery.class);
        query.andQualifier(ExpressionFactory.matchAllExp(
                "|exhibitArray.artistExhibitArray.toArtist",
                picasso,
                dali));

        List<Gallery> galleries = context.performQuery(query);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
        context.performGenericQuery(new SQLTemplate(
                EnumEntity.class,
                "insert into ENUM_ENTITY (ID, ENUM_ATTRIBUTE) VALUES (2, 'one')"));

        SelectQuery q = new SelectQuery(EnumEntity.class);
        q.andQualifier(ExpressionFactory.matchExp(
                EnumEntity.ENUM_ATTRIBUTE_PROPERTY,
                Enum1.one));

        EnumEntity e = (EnumEntity) DataObjectUtils.objectForQuery(context, q);
        assertNotNull(e);
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
                Artist.class,
                "INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE)"
                        + " VALUES (2, 2, 'Y')"));

        SelectQuery query = new SelectQuery(Artist.class);
        query.andQualifier(ExpressionFactory.matchExp("p.paintingTitle", "X"));

        query.aliasPathSplits("paintingArray", "p");

        List<Artist> artists = context.performQuery(query);
        assertEquals(1, artists.size());
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
                Artist.class,
                "INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE)"
                        + " VALUES (3, 2, 'X')"));

        SelectQuery query = new SelectQuery(Artist.class);
        query.andQualifier(ExpressionFactory.matchExp("p1.paintingTitle", "X"));
        query.andQualifier(ExpressionFactory.matchExp("p2.paintingTitle", "Y"));

        query.aliasPathSplits("paintingArray", "p1", "p2");

        List<Artist> artists = context.performQuery(query);
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
                "INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE)"
                        + " VALUES (3, 2, 'X')"));

        SelectQuery query = new SelectQuery(Artist.class);
        query.andQualifier(ExpressionFactory.matchExp("p1.paintingTitle", "X"));
        query.andQualifier(ExpressionFactory.matchExp("p2.paintingTitle", "Y"));

        query.aliasPathSplits("paintingArray", "p1", "p2");

        List<Artist> artists = context.performQuery(query);
        assertEquals(1, artists.size());
View Full Code Here
315
316
317
318
319
320
321
322
323
324
325
     */
    public void testPrefetch5() throws Exception {
        createTestData("testPaintings");

        SelectQuery q = new SelectQuery("Painting");
        q.andQualifier(ExpressionFactory.matchDbExp("toArtist.ARTIST_NAME", "artist2"));
        q.addPrefetch("toArtist");

        List results = context.performQuery(q);

        assertEquals(1, results.size());
View Full Code Here
330
331
332
333
334
335
336
337
338
339
340
     */
    public void testPrefetch6() throws Exception {
        createTestData("testPaintings");

        SelectQuery q = new SelectQuery("Painting");
        q.andQualifier(ExpressionFactory.matchExp("toArtist.artistName", "artist2"));
        q.addPrefetch("toArtist");

        List results = context.performQuery(q);
        assertEquals(1, results.size());
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.