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.

                + " 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", null));


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


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

View Full Code Here

                + " WHERE #bindObjectNotEqual($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);
        // null comparison is unpredictable across DB's ... some would return true on null
        // <> value, some - false
        assertTrue(objects.size() == 1 || objects.size() == 2);


        Painting p = (Painting) objects.get(0);

View Full Code Here

                + " WHERE #bindObjectEqual($a [ 't0.F_KEY1', 't0.F_KEY2' ] [ 'KEY1', 'KEY2' ] ) ORDER BY PKEY";
        SQLTemplate query = new SQLTemplate(CompoundFkTestEntity.class, template);
        query.setColumnNamesCapitalization(CapsStrategy.UPPER);
        query.setParameters(Collections.singletonMap("a", a));


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


        CompoundFkTestEntity p = (CompoundFkTestEntity) objects.get(0);
        assertEquals(33001, DataObjectUtils.intPKForObject(p));
    }

View Full Code Here

                + " WHERE #bindObjectNotEqual($a [ 't0.F_KEY1', 't0.F_KEY2' ] [ 'KEY1', 'KEY2' ] ) ORDER BY PKEY";
        SQLTemplate query = new SQLTemplate(CompoundFkTestEntity.class, template);
        query.setColumnNamesCapitalization(CapsStrategy.UPPER);
        query.setParameters(Collections.singletonMap("a", a));


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


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

View Full Code Here

                + " WHERE #bindObjectNotEqual($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", null));


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


        Painting p1 = (Painting) objects.get(0);
        assertEquals(33001, DataObjectUtils.intPKForObject(p1));

View Full Code Here

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


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


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

View Full Code Here


        String ejbql = "select P from Painting P WHERE p.toArtist = :param";
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("param", a);


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


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

View Full Code Here

        ObjectContext context = createDataContext();


        String ejbql = "select P from Painting P WHERE p.toArtist = 33002";
        EJBQLQuery query = new EJBQLQuery(ejbql);


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


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

View Full Code Here


        String ejbql = "select e from CompoundFkTestEntity e WHERE e.toCompoundPk = :param";
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("param", a);


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


        CompoundFkTestEntity o1 = (CompoundFkTestEntity) ps.get(0);
        assertEquals(33002, DataObjectUtils.intPKForObject(o1));
    }

View Full Code Here


        String ejbql = "select e from CompoundFkTestEntity e WHERE :param = e.toCompoundPk";
        EJBQLQuery query = new EJBQLQuery(ejbql);
        query.setParameter("param", a);


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


        CompoundFkTestEntity o1 = (CompoundFkTestEntity) ps.get(0);
        assertEquals(33002, DataObjectUtils.intPKForObject(o1));
    }

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.