Examples of org.apache.cayenne.ObjectContext.performQuery()

org.apache.cayenne.ObjectContext.performQuery()
Executes a selecting query, returning a list of persistent objects or data rows.


        SelectQuery q = new SelectQuery(Painting.class);
        q.addOrdering(Painting.PAINTING_TITLE_PROPERTY, SortOrder.ASCENDING);
        q.addPrefetch(Painting.TO_ARTIST_PROPERTY);


        final List<?> results = child.performQuery(q);


        // blockQueries();


        queryInterceptor.runWithQueriesBlocked(new UnitTestClosure() {

View Full Code Here


        SelectQuery q = new SelectQuery(Artist.class);
        q.addOrdering(Artist.ARTIST_NAME_PROPERTY, SortOrder.ASCENDING);
        q.addPrefetch(Artist.PAINTING_ARRAY_PROPERTY);


        final List<?> results = child.performQuery(q);


        queryInterceptor.runWithQueriesBlocked(new UnitTestClosure() {


            public void execute() {
                Artist o1 = (Artist) results.get(0);

View Full Code Here

        final ObjectContext childContext = context.createChildContext();


        // make sure we fetch in predictable order
        SelectQuery query = new SelectQuery(Artist.class);
        query.addOrdering(Artist.ARTIST_NAME_PROPERTY, SortOrder.ASCENDING);
        List<?> objects = childContext.performQuery(query);


        assertEquals(4, objects.size());


        final Artist childNew = childContext.newObject(Artist.class);
        childNew.setArtistName("NNN");

View Full Code Here

        ObjectContext childContext = context.createChildContext();


        // make sure we fetch in predictable order
        SelectQuery query = new SelectQuery(Artist.class);
        query.addOrdering(Artist.ARTIST_NAME_PROPERTY, SortOrder.ASCENDING);
        List<?> objects = childContext.performQuery(query);


        assertEquals(4, objects.size());


        // delete AND modify
        Artist childDeleted = (Artist) objects.get(2);

View Full Code Here

        ObjectContext childContext = context.createChildContext();


        // make sure we fetch in predictable order
        SelectQuery query = new SelectQuery(Artist.class);
        query.addOrdering(Artist.ARTIST_NAME_PROPERTY, SortOrder.ASCENDING);
        List<?> objects = childContext.performQuery(query);


        assertEquals(4, objects.size());


        Artist childNew = childContext.newObject(Artist.class);
        childNew.setArtistName("NNN");

View Full Code Here

        final ObjectContext childContext = context.createChildContext();


        // make sure we fetch in predictable order
        SelectQuery query = new SelectQuery(Painting.class);
        query.addOrdering(Painting.PAINTING_TITLE_PROPERTY, SortOrder.ASCENDING);
        List<?> objects = childContext.performQuery(query);


        assertEquals(6, objects.size());


        final Painting childModifiedSimple = (Painting) objects.get(0);
        childModifiedSimple.setPaintingTitle("C_PT");

View Full Code Here

                + "WHERE #bindObjectEqual($a) ORDER BY PAINTING_ID";
        SQLTemplate query = new SQLTemplate(Painting.class, template);
        query.setColumnNamesCapitalization(CapsStrategy.UPPER);
        query.setParameters(Collections.singletonMap("a", a));


        List objects = context.performQuery(query);
        assertEquals(1, objects.size());


        Painting p = (Painting) objects.get(0);
        assertEquals(33002, DataObjectUtils.intPKForObject(p));
    }

View Full Code Here

                + "WHERE #bindObjectNotEqual($a) ORDER BY PAINTING_ID";
        SQLTemplate query = new SQLTemplate(Painting.class, template);
        query.setColumnNamesCapitalization(CapsStrategy.UPPER);
        query.setParameters(Collections.singletonMap("a", a));


        List objects = context.performQuery(query);


        // null comparison is unpredictable across DB's ... some would return true on null
        // <> value, some - false
        assertTrue(objects.size() == 1 || objects.size() == 2);

View Full Code Here

                + " WHERE #bindObjectEqual($a [ 't0.ARTIST_ID' ] [ 'ARTIST_ID' ] ) ORDER BY PAINTING_ID";
        SQLTemplate query = new SQLTemplate(Painting.class, template);
        query.setColumnNamesCapitalization(CapsStrategy.UPPER);
        query.setParameters(Collections.singletonMap("a", a));


        List objects = context.performQuery(query);
        assertEquals(1, objects.size());


        Painting p = (Painting) objects.get(0);
        assertEquals(33002, DataObjectUtils.intPKForObject(p));
    }

View Full Code Here

                + " WHERE #bindObjectEqual($a 't0.ARTIST_ID' 'ARTIST_ID' ) ORDER BY PAINTING_ID";
        SQLTemplate query = new SQLTemplate(Painting.class, template);
        query.setColumnNamesCapitalization(CapsStrategy.UPPER);
        query.setParameters(Collections.singletonMap("a", a));


        List objects = context.performQuery(query);
        assertEquals(1, objects.size());


        Painting p = (Painting) objects.get(0);
        assertEquals(33002, DataObjectUtils.intPKForObject(p));
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.