Examples of EJBQLQuery

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

Examples of org.apache.cayenne.query.EJBQLQuery


        Artist a2 = context.newObject(Artist.class);
        a2.setArtistName("_A_____");
        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE LOCATE('A', a.artistName) = 2");
        List<?> objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(a2));
    }

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

        context.performGenericQuery(inserts);


        Artist a1 = Cayenne.objectForPK(context, Artist.class, 1);
        Artist a2 = Cayenne.objectForPK(context, Artist.class, 2);


        EJBQLQuery query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE TRIM(a.artistName) = 'A'");
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());
        assertTrue(objects.contains(a1));
        assertTrue(objects.contains(a2));


        query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE TRIM(LEADING FROM a.artistName) = 'A'");
        objects = context.performQuery(query);
        // this is fuzzy cause some DB trim trailing data by default
        assertTrue(objects.size() == 1 || objects.size() == 2);
        assertTrue(objects.contains(a1));


        query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE TRIM(TRAILING FROM a.artistName) = 'A'");
        objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(a2));


        query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE TRIM(BOTH FROM a.artistName) = 'A'");
        objects = context.performQuery(query);
        assertEquals(2, objects.size());
        assertTrue(objects.contains(a1));
        assertTrue(objects.contains(a2));

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery


        Artist a2 = context.newObject(Artist.class);
        a2.setArtistName("AXXX");
        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE TRIM('X' FROM a.artistName) = 'A'");
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());
        assertTrue(objects.contains(a1));
        assertTrue(objects.contains(a2));


        query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE TRIM(LEADING 'X' FROM a.artistName) = 'A'");
        objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(a1));


        query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE TRIM(TRAILING 'X' FROM a.artistName) = 'A'");
        objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(a2));


        query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE TRIM(BOTH 'X' FROM a.artistName) = 'A'");
        objects = context.performQuery(query);
        assertEquals(2, objects.size());
        assertTrue(objects.contains(a1));
        assertTrue(objects.contains(a2));

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

        String ejbql = "SELECT DISTINCT m FROM Manager m JOIN m.managedDepartments d"
                + " WHERE m MEMBER d.employees";


        ObjectContext context = createDataContext();


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


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

        String ejbql = "SELECT DISTINCT m FROM Manager m JOIN m.managedDepartments d"
                + " WHERE m NOT MEMBER d.employees";


        ObjectContext context = createDataContext();


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


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

                + " FROM Address a JOIN a.toEmployee m JOIN m.toDepartment d"
                + " WHERE m NOT MEMBER d.employees";


        ObjectContext context = createDataContext();


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

View Full Code Here

Examples of org.apache.cayenne.query.EJBQLQuery

        allArtists.get(0).setDateOfBirth(dob);
        context.commitChanges();


        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

Examples of org.apache.cayenne.query.EJBQLQuery

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


        String ejbql = "SELECT p FROM Painting p WHERE p.paintingTitle LIKE 'A%C'";


        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 testNotLike() throws Exception {
        createLikeDataSet();


        String ejbql = "SELECT p FROM Painting p WHERE p.paintingTitle NOT LIKE 'A%C'";


        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(4, 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 testLike2() throws Exception {
        createLikeDataSet();


        String ejbql = "SELECT p FROM Painting p WHERE p.paintingTitle LIKE '_DDDD'";


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


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

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.