Examples of EJBQLQuery

org.apache.cayenne.query.EJBQLQuery
An EJBQL query representation in Cayenne. @since 3.0

Examples of org.apache.cayenne.query.EJBQLQuery

    public void testLikeEscape() throws Exception {
        createLikeDataSet();


        String ejbql = "SELECT p FROM Painting p WHERE p.paintingTitle LIKE 'X_DDDD' ESCAPE 'X'";


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


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

        createLikeDataSet();


        // test for CAY-1426
        String ejbql = "SELECT p FROM Painting p WHERE p.paintingTitle LIKE ?1 ESCAPE 'X'";


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


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

    public void testIn() throws Exception {
        createInDataSet();


        String ejbql = "SELECT p FROM Painting p WHERE p.paintingTitle IN ('A', 'B')";


        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

    public void testNotIn() throws Exception {
        createInDataSet();


        String ejbql = "SELECT p FROM Painting p WHERE p.paintingTitle NOT IN ('A', 'B')";


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


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery


        String ejbql = "SELECT p FROM Painting p WHERE p.paintingTitle IN ("
                + "SELECT p1.paintingTitle FROM Painting p1 WHERE p1.paintingTitle = 'C'"
                + ")";


        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

    public void testCollectionEmpty() throws Exception {
        createCollectionDataSet();


        String ejbql = "SELECT a FROM Artist a WHERE a.paintingArray IS EMPTY";


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


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

    public void testCollectionNotEmpty() throws Exception {
        createCollectionDataSet();


        String ejbql = "SELECT a FROM Artist a WHERE a.paintingArray IS NOT EMPTY";


        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

    public void testCollectionNotEmptyExplicitDistinct() throws Exception {
        createCollectionDataSet();


        String ejbql = "SELECT DISTINCT a FROM Artist a WHERE a.paintingArray IS NOT EMPTY";


        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

    public void testCollectionMemberOfParameter() throws Exception {
        createCollectionDataSet();


        String ejbql = "SELECT a FROM Artist a WHERE :x MEMBER OF a.paintingArray";


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


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

    public void testGreaterOrEquals() throws Exception {
        createGreaterThanDataSet();


        String ejbql = "SELECT p FROM Painting p WHERE p.estimatedPrice >= :estimatedPrice";


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

View Full Code Here

0 1 2 3 4 5

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.