Examples of org.apache.cayenne.query.SelectQuery

org.apache.cayenne.query.SelectQuery
A query that selects persistent objects of a certain type or "raw data" (aka DataRows). Supports expression qualifier, multiple orderings and a number of other parameters that serve as runtime hints to Cayenne on how to optimize the fetch and result processing.


    public void testSuccessSimpleLockingOnUpdatePrecededByForgetSnapshot()
            throws Exception {
        createTestData("testSimpleLocking");


        List allObjects = context.performQuery(new SelectQuery(
                SimpleLockingTestEntity.class));
        assertEquals(1, allObjects.size());


        SimpleLockingTestEntity object = (SimpleLockingTestEntity) allObjects.get(0);

View Full Code Here

    }


    public void testFailSimpleLocking() throws Exception {
        createTestData("testSimpleLocking");


        List allObjects = context.performQuery(new SelectQuery(
                SimpleLockingTestEntity.class));
        assertEquals(1, allObjects.size());


        SimpleLockingTestEntity object = (SimpleLockingTestEntity) allObjects.get(0);

View Full Code Here

    }


    public void testFailLockingOnNull() throws Exception {
        createTestData("testLockingOnNull");


        List allObjects = context.performQuery(new SelectQuery(
                SimpleLockingTestEntity.class));
        assertEquals(1, allObjects.size());


        SimpleLockingTestEntity object = (SimpleLockingTestEntity) allObjects.get(0);

View Full Code Here

        }
    }


    public void testSuccessLockingOnMixed() throws Exception {
        createTestData("testLockingOnMixed");
        SelectQuery query = new SelectQuery(SimpleLockingTestEntity.class);
        query.addOrdering(new Ordering("db:LOCKING_TEST_ID", SortOrder.ASCENDING));


        List allObjects = context.performQuery(query);
        assertEquals(3, allObjects.size());


        SimpleLockingTestEntity object1 = (SimpleLockingTestEntity) allObjects.get(0);

View Full Code Here


    public void testFailLockingOnToOne() throws Exception {
        createTestData("testLockingOnToOne");


        List allObjects = context
                .performQuery(new SelectQuery(RelLockingTestEntity.class));
        assertEquals(1, allObjects.size());


        RelLockingTestEntity object = (RelLockingTestEntity) allObjects.get(0);


        // change name and save... no optimistic lock failure expected

View Full Code Here

    }


    public void testFailRetrieveRow() throws Exception {
        createTestData("testSimpleLocking");


        List allObjects = context.performQuery(new SelectQuery(
                SimpleLockingTestEntity.class));
        assertEquals(1, allObjects.size());


        SimpleLockingTestEntity object = (SimpleLockingTestEntity) allObjects.get(0);
        object.setDescription("first update");

View Full Code Here

    }


    public void testFailRetrieveDeletedRow() throws Exception {
        createTestData("testSimpleLocking");


        List allObjects = context.performQuery(new SelectQuery(
                SimpleLockingTestEntity.class));
        assertEquals(1, allObjects.size());


        SimpleLockingTestEntity object = (SimpleLockingTestEntity) allObjects.get(0);

View Full Code Here


    public void testJointPrefetchDataRows() throws Exception {
        createTestData("testJointPrefetch1");


        // query with to-many joint prefetches
        SelectQuery q = new SelectQuery(Painting.class);
        q.addOrdering("db:PAINTING_ID", SortOrder.ASCENDING);
        q.setFetchingDataRows(true);
        q.addPrefetch(Painting.TO_ARTIST_PROPERTY).setSemantics(
                PrefetchTreeNode.JOINT_PREFETCH_SEMANTICS);


        DataContext context = createDataContext();


        List rows = context.performQuery(q);

View Full Code Here


    public void testJointPrefetchToOne() throws Exception {
        createTestData("testJointPrefetch1");


        // query with to-many joint prefetches
        SelectQuery q = new SelectQuery(Painting.class);
        q.addOrdering("db:PAINTING_ID", SortOrder.ASCENDING);
        q.addPrefetch(Painting.TO_ARTIST_PROPERTY).setSemantics(
                PrefetchTreeNode.JOINT_PREFETCH_SEMANTICS);


        DataContext context = createDataContext();


        List objects = context.performQuery(q);

View Full Code Here


        context.performNonSelectingQuery(artistSQL);
        context.performNonSelectingQuery(paintingSQL);


        // test
        SelectQuery q = new SelectQuery(Painting.class);
        q.addPrefetch(Painting.TO_ARTIST_PROPERTY).setSemantics(
                PrefetchTreeNode.JOINT_PREFETCH_SEMANTICS);


        ObjEntity artistE = getObjEntity("Artist");
        ObjAttribute dateOfBirth = (ObjAttribute) artistE.getAttribute("dateOfBirth");
        assertEquals("java.util.Date", dateOfBirth.getType());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.cayenne.query.SelectQuery

er.cayenne.example.components.Main

er.cayenne.example.persistent.auto._Artist

er.cayenne.example.persistent.auto._Gallery

er.cayenne.example.persistent.auto._Painting

net.bnubot.bot.gui.DatabaseEditor

net.bnubot.db.Account

net.bnubot.db.BNLogin

net.bnubot.db.Command

org.apache.cayenne.access.ClientServerChannelQueryTest

org.apache.cayenne.access.ClientServerChannelTest

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.