Examples of andQualifier()

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

52
53
54
55
56
57
58
59
60
61
62
        Artist picasso = Cayenne.objectForPK(context, Artist.class, 1);
        Artist dali = Cayenne.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

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

262
263
264
265
266
267
268
269
270
271
272
     */
    public void testMultiObjRelFetch() throws Exception {
        createArtistsAndPaintingsDataSet();

        SelectQuery q = new SelectQuery(Painting.class);
        q.andQualifier(ExpressionFactory.matchExp("toArtist.artistName", "artist2"));
        q.orQualifier(ExpressionFactory.matchExp("toArtist.artistName", "artist4"));
        List<Painting> results = context.performQuery(q);

        assertEquals(2, results.size());
    }
View Full Code Here

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

277
278
279
280
281
282
283
284
285
286
287
     */
    public void testMultiDbRelFetch() throws Exception {
        createArtistsAndPaintingsDataSet();

        SelectQuery q = new SelectQuery("Painting");
        q.andQualifier(ExpressionFactory.matchDbExp("toArtist.ARTIST_NAME", "artist2"));
        q.orQualifier(ExpressionFactory.matchDbExp("toArtist.ARTIST_NAME", "artist4"));
        List<?> results = context.performQuery(q);

        assertEquals(2, results.size());
    }
View Full Code Here

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

50
51
52
53
54
55
56
57
58
59
60
                        "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

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

72
73
74
75
76
77
78
79
80
81
82
        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

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

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, SortOrder.DESCENDING);
        query1.addOrdering(Artist.DATE_OF_BIRTH_PROPERTY, SortOrder.DESCENDING);
View Full Code Here

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

37
38
39
40
41
42
43
44
45
46
47
    @SuppressWarnings("unchecked")
    public List<String> getPostCodeLocations(String location) {
        SelectQuery query = new SelectQuery(PostCode.class);

        query.andQualifier(ExpressionFactory.likeIgnoreCaseExp(PostCode.LOCALITY_PROPERTY, location + "%"));

        query.addOrdering(PostCode.LOCALITY_PROPERTY, true);

        query.setFetchLimit(10);
View Full Code Here

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

80
81
82
83
84
85
86
87
88
89
90
    @SuppressWarnings("unchecked")
    public List<Customer> getCustomers(String name, Date startDate) {
        SelectQuery query = new SelectQuery(Customer.class);

        if (StringUtils.isNotBlank(name)) {
            query.andQualifier(ExpressionFactory.likeIgnoreCaseExp(Customer.NAME_PROPERTY, "%" + name + "%"));
        }
        if (startDate != null) {
            query.andQualifier(ExpressionFactory.greaterOrEqualExp(Customer.DATE_JOINED_PROPERTY, startDate));
        }
View Full Code Here

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

83
84
85
86
87
88
89
90
91
92
93
        if (StringUtils.isNotBlank(name)) {
            query.andQualifier(ExpressionFactory.likeIgnoreCaseExp(Customer.NAME_PROPERTY, "%" + name + "%"));
        }
        if (startDate != null) {
            query.andQualifier(ExpressionFactory.greaterOrEqualExp(Customer.DATE_JOINED_PROPERTY, startDate));
        }

        query.addOrdering(Customer.NAME_PROPERTY, true);
        query.addOrdering(Customer.DATE_JOINED_PROPERTY, true);
View Full Code Here

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

96
97
98
99
100
101
102
103
104
105
106
    @SuppressWarnings("unchecked")
    public List<Customer> getCustomerNamesLike(String name) {
        SelectQuery query = new SelectQuery(Customer.class);

        query.andQualifier(ExpressionFactory.likeIgnoreCaseExp(Customer.NAME_PROPERTY, "%" + name + "%"));

        query.addOrdering(Customer.NAME_PROPERTY, true);

        query.setFetchLimit(10);
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.