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 testSelectQueryEntityNameRoot() throws Exception {
        createTwoMtTable1sAnd2sDataSet();


        SelectQuery q = new SelectQuery("MtTable1");
        List<?> results = context.performQuery(q);


        assertEquals(2, results.size());


        assertTrue(results.get(0) instanceof ClientMtTable1);

View Full Code Here

    }


    public void testSelectQueryClientClassRoot() throws Exception {
        createTwoMtTable1sAnd2sDataSet();


        SelectQuery q = new SelectQuery(ClientMtTable1.class);
        List<?> results = context.performQuery(q);


        assertEquals(2, results.size());
        assertTrue(results.get(0) instanceof ClientMtTable1);
    }

View Full Code Here

    }


    public void testSelectQuerySimpleQualifier() throws Exception {
        createTwoMtTable1sAnd2sDataSet();


        SelectQuery q = new SelectQuery(ClientMtTable1.class, Expression
                .fromString("globalAttribute1 = 'g1'"));
        List<?> results = context.performQuery(q);


        assertEquals(1, results.size());

View Full Code Here

    }


    public void testSelectQueryToManyRelationshipQualifier() throws Exception {
        createTwoMtTable1sAnd2sDataSet();


        SelectQuery q = new SelectQuery(ClientMtTable1.class, Expression
                .fromString("table2Array.globalAttribute = 'g1'"));
        List<?> results = context.performQuery(q);


        assertEquals(1, results.size());
        assertTrue(results.get(0) instanceof ClientMtTable1);

View Full Code Here

    }


    public void testSelectQueryOrdering() throws Exception {
        createTwoMtTable1sAnd2sDataSet();


        SelectQuery q = new SelectQuery("MtTable1");
        q.addOrdering(ClientMtTable1.GLOBAL_ATTRIBUTE1_PROPERTY, SortOrder.ASCENDING);
        List<?> results = context.performQuery(q);


        assertEquals(2, results.size());


        ClientMtTable1 o1 = (ClientMtTable1) results.get(0);
        ClientMtTable1 o2 = (ClientMtTable1) results.get(1);
        assertTrue(o1.getGlobalAttribute1().compareTo(o2.getGlobalAttribute1()) < 0);


        // now run the same query with reverse ordering to check that the first ordering
        // result wasn't coincidental.


        q.clearOrderings();
        q.addOrdering(ClientMtTable1.GLOBAL_ATTRIBUTE1_PROPERTY, SortOrder.DESCENDING);
        List<?> results1 = context.performQuery(q);


        assertEquals(2, results1.size());


        ClientMtTable1 o3 = (ClientMtTable1) results1.get(0);

View Full Code Here

    }


    public void testSelectQueryPrefetchToOne() throws Exception {
        createTwoMtTable1sAnd2sDataSet();


        SelectQuery q = new SelectQuery(ClientMtTable2.class, Expression
                .fromString("globalAttribute = 'g1'"));
        q.addPrefetch(ClientMtTable2.TABLE1_PROPERTY);
        List<?> results = context.performQuery(q);


        assertEquals(1, results.size());


        ClientMtTable2 result = (ClientMtTable2) results.get(0);

View Full Code Here

    }


    public void testSelectQueryPrefetchToMany() throws Exception {
        createTwoMtTable1sAnd2sDataSet();


        SelectQuery q = new SelectQuery(ClientMtTable1.class, Expression
                .fromString("globalAttribute1 = 'g1'"));
        q.addPrefetch(ClientMtTable1.TABLE2ARRAY_PROPERTY);
        List<?> results = context.performQuery(q);


        assertEquals(1, results.size());


        ClientMtTable1 result = (ClientMtTable1) results.get(0);

View Full Code Here

                "INSERT INTO PERSON_NOTES (ID, NOTES, PERSON_ID) VALUES (3, 'AA', 3)"));
        context.performGenericQuery(new SQLTemplate(
                PersonNotes.class,
                "INSERT INTO PERSON_NOTES (ID, NOTES, PERSON_ID) VALUES (4, 'BB', 3)"));


        SelectQuery query = new SelectQuery(AbstractPerson.class);
        query.addPrefetch(AbstractPerson.NOTES_PROPERTY).setSemantics(
                PrefetchTreeNode.JOINT_PREFETCH_SEMANTICS);


        AbstractPerson person = (AbstractPerson) Cayenne.objectForQuery(
                createDataContext(),
                query);

View Full Code Here

                "INSERT INTO PERSON_NOTES (ID, NOTES, PERSON_ID) VALUES (3, 'AA', 3)"));
        context.performGenericQuery(new SQLTemplate(
                PersonNotes.class,
                "INSERT INTO PERSON_NOTES (ID, NOTES, PERSON_ID) VALUES (4, 'BB', 3)"));


        SelectQuery query = new SelectQuery(AbstractPerson.class);
        query.addPrefetch(AbstractPerson.NOTES_PROPERTY);


        AbstractPerson person = (AbstractPerson) Cayenne.objectForQuery(
                createDataContext(),
                query);

View Full Code Here


        context.performGenericQuery(new SQLTemplate(
                PersonNotes.class,
                "INSERT INTO PERSON_NOTES (ID, NOTES, PERSON_ID) VALUES (3, 'BB', 2)"));


        SelectQuery query = new SelectQuery(PersonNotes.class);
        query.addPrefetch(PersonNotes.PERSON_PROPERTY);
        query.addOrdering(PersonNotes.NOTES_PROPERTY, SortOrder.ASCENDING);


        List<PersonNotes> notes = createDataContext().performQuery(query);
        assertEquals(2, notes.size());
        PersonNotes note = notes.get(0);

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.