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.


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


        SelectQuery query = new SelectQuery(PersonNotes.class);
        query.addPrefetch(PersonNotes.PERSON_PROPERTY).setSemantics(
                PrefetchTreeNode.JOINT_PREFETCH_SEMANTICS);


        PersonNotes note = (PersonNotes) Cayenne.objectForQuery(
                createDataContext(),
                query);

View Full Code Here

        employee.setPersonType("E");


        context.commitChanges();


        context = createDataContextWithDedicatedCache();
        SelectQuery query = new SelectQuery(CustomerRepresentative.class);
        List reps = context.performQuery(query);


        assertEquals(1, reps.size());
        assertEquals(1, countObjectOfClass(reps, CustomerRepresentative.class));
    }

View Full Code Here

    /**
     * Tests that to-one relationship produces correct subclass.
     */
    public void testEmployeeAddress() throws Exception {
        createTestData("testEmployeeAddress");
        List addresses = context.performQuery(new SelectQuery(Address.class));


        assertEquals(1, addresses.size());
        Address address = (Address) addresses.get(0);
        assertSame(Employee.class, address.getToEmployee().getClass());
    }

View Full Code Here

    /**
     * Tests that to-one relationship produces correct subclass.
     */
    public void testManagerAddress() throws Exception {
        createTestData("testManagerAddress");
        List addresses = context.performQuery(new SelectQuery(Address.class));


        assertEquals(1, addresses.size());
        Address address = (Address) addresses.get(0);
        Employee e = address.getToEmployee();

View Full Code Here

        assertSame(Manager.class, e.getClass());
    }


    public void testCAY592() throws Exception {
        createTestData("testManagerAddress");
        List addresses = context.performQuery(new SelectQuery(Address.class));


        assertEquals(1, addresses.size());
        Address address = (Address) addresses.get(0);
        Employee e = address.getToEmployee();

View Full Code Here

    /**
     * Tests that to-one relationship produces correct subclass.
     */
    public void testRepCompany() throws Exception {
        createTestData("testRepCompany");
        List companies = context.performQuery(new SelectQuery(ClientCompany.class));


        assertEquals(1, companies.size());
        ClientCompany company = (ClientCompany) companies.get(0);
        List reps = company.getRepresentatives();
        assertEquals(1, reps.size());

View Full Code Here

    /**
     * Tests that to-many relationship produces correct subclasses.
     */
    public void testDepartmentEmployees() throws Exception {
        createTestData("testDepartmentEmployees");
        List departments = context.performQuery(new SelectQuery(Department.class));


        assertEquals(1, departments.size());
        Department dept = (Department) departments.get(0);
        List employees = dept.getEmployees();
        assertEquals(3, employees.size());

View Full Code Here


    public void testSelectInheritanceResolving() throws Exception {
        createTestData("testSelect");


        // select Abstract Ppl
        SelectQuery query = new SelectQuery(AbstractPerson.class);
        List abstractPpl = context.performQuery(query);
        assertEquals(6, abstractPpl.size());


        assertEquals(1, countObjectOfClass(abstractPpl, CustomerRepresentative.class));
        assertEquals(5, countObjectOfClass(abstractPpl, Employee.class));

View Full Code Here

        Artist a1 = context.newObject(Artist.class);
        a1.setArtistName("X");
        context.commitChanges();


        QueryChain chain = new QueryChain();
        chain.addQuery(new SelectQuery(Artist.class));
        chain.addQuery(new SelectQuery(Artist.class));


        QueryResponse r = context.performGenericQuery(chain);


        // data comes back as datarows
        assertEquals(2, r.size());

View Full Code Here

        // perform a fetch to ensure that this artist hasn't been persisted to the db


        DataContext freshContext = (DataContext) serverRuntime.getContext();
        assertNotSame(this.context, freshContext);


        SelectQuery query = new SelectQuery(Artist.class);
        query.setQualifier(ExpressionFactory.matchExp("artistName", artistName));
        List<?> queryResults = freshContext.performQuery(query);


        assertEquals(0, queryResults.size());
    }

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.