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.


        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT d FROM BigDecimalEntity d WHERE SQRT(d.bigDecimalField) > 3.1");
        List objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(o2));
    }


    public void testMOD() {

View Full Code Here


        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT d FROM BigIntegerEntity d WHERE MOD(d.bigIntegerField, 4) = 2");
        List objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(o2));
    }


    public void testSIZE() {

View Full Code Here


        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT d FROM Artist d WHERE SIZE(d.paintingArray) = 2");
        List objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(a2));


        EJBQLQuery query2 = new EJBQLQuery(
                "SELECT d FROM Artist d WHERE SIZE(d.paintingArray) = 0");

View Full Code Here

        assertEquals(1, objects.size());
        assertTrue(objects.contains(a2));


        EJBQLQuery query2 = new EJBQLQuery(
                "SELECT d FROM Artist d WHERE SIZE(d.paintingArray) = 0");
        List objects2 = context.performQuery(query2);
        assertEquals(1, objects2.size());
        assertTrue(objects2.contains(a1));
    }


    public void testCONCAT() {

View Full Code Here

        a2.setArtistName("a2");
        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE CONCAT(a.artistName, a.artistName) = 'a1a1'");
        List objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(a1));
    }


    public void testSUBSTRING() {

View Full Code Here

        a2.setArtistName("abcdefg");
        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE SUBSTRING(a.artistName, 2, 3) = 'bcd'");
        List objects = context.performQuery(query);
        assertEquals(1, objects.size());
        assertTrue(objects.contains(a2));
    }


    public void testLOWER() {

View Full Code Here

        a3.setArtistName("Xabcdefg");
        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE LOWER(a.artistName) = 'abcdefg'");
        List objects = context.performQuery(query);
        assertEquals(2, objects.size());
        assertTrue(objects.contains(a1));
        assertTrue(objects.contains(a2));
    }

View Full Code Here

        a3.setArtistName("Xabcdefg");
        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE UPPER(a.artistName) = UPPER('abcdefg')");
        List objects = context.performQuery(query);
        assertEquals(2, objects.size());
        assertTrue(objects.contains(a1));
        assertTrue(objects.contains(a2));
    }

View Full Code Here

        a3.setArtistName("1234567890-=");
        context.commitChanges();


        EJBQLQuery query = new EJBQLQuery(
                "SELECT a FROM Artist a WHERE LENGTH(a.artistName) > 7");
        List objects = context.performQuery(query);
        assertEquals(2, objects.size());
        assertTrue(objects.contains(a3));
        assertTrue(objects.contains(a2));
    }

View Full Code Here

        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));
    }


    public void testTRIM() {

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.