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.


        String ejbql = "SELECT a FROM Artist a WHERE a.dateOfBirth = :x";


        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("x", dob);
        List<?> objects = context.performQuery(query);
        assertEquals(1, objects.size());


        assertSame(allArtists.get(0), objects.get(0));
    }

View Full Code Here

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


        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
        while (it.hasNext()) {

View Full Code Here


        ObjectContext context = createDataContext();


        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("estimatedPrice", new BigDecimal(4000));
        List<?> objects = context.performQuery(query);
        assertEquals(4, objects.size());
    }


    public void testLessOrEquals() throws Exception {
        createTestData("prepareGreaterThan");

View Full Code Here


        ObjectContext context = createDataContext();


        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("estimatedPrice", new BigDecimal(4000));
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());
    }


    public void testCollectionNotMemberOfParameter() throws Exception {
        createTestData("prepareCollection");

View Full Code Here

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


        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
        while (it.hasNext()) {

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, true);
        List objects = childContext.performQuery(query);


        assertEquals(4, objects.size());


        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, true);
        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, true);
        List objects = childContext.performQuery(query);


        assertEquals(4, objects.size());


        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(Painting.class);
        query.addOrdering(Painting.PAINTING_TITLE_PROPERTY, true);
        List objects = childContext.performQuery(query);


        assertEquals(6, objects.size());


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

View Full Code Here

        query.andQualifier(ExpressionFactory.matchAllExp(
                "|exhibitArray.artistExhibitArray.toArtist",
                picasso,
                dali));


        List<Gallery> galleries = context.performQuery(query);


        assertEquals(1, galleries.size());
        assertEquals("G1", galleries.get(0).getGalleryName());
    }

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.