Examples of QueryChain

org.apache.cayenne.query.QueryChain
A Query decorator for a collection of other queries. Note that QueryChain will always return DataRows (that is if it returns data), as it has no way of knowing how to convert the results to objects. @since 1.2

Examples of org.apache.cayenne.query.QueryChain

        runInTransaction(new Transformer() {


            public Object transform(Object input) {
                new DataDomainLegacyQueryAction(
                        DataDomain.this,
                        new QueryChain(queries),
                        callback).execute();
                return null;
            }
        });
    }

View Full Code Here

Examples of org.apache.cayenne.query.QueryChain

        DataContext context = createDataContext();
        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

Examples of org.apache.cayenne.query.QueryChain

        super.setUp();
        deleteTestData();
    }
    
    public void testMatchingOnSuperAttributes() {
        QueryChain insert = new QueryChain();
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (1, 'E1', 'EE')"));
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (2, 'E2', 'EM')"));
        createDataContext().performGenericQuery(insert);

View Full Code Here

Examples of org.apache.cayenne.query.QueryChain

        assertEquals(1, results.size());
        assertEquals("E2", results.get(0).getName());
    }
    
    public void testMatchingOnSuperAttributesWithPrefetch() {
        QueryChain insert = new QueryChain();
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (1, 'E1', 'EE')"));
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (2, 'E2', 'EM')"));
        createDataContext().performGenericQuery(insert);

View Full Code Here

Examples of org.apache.cayenne.query.QueryChain

        assertEquals("E2", results.get(0).getName());
    }


    public void testPaginatedQueries() {


        QueryChain insert = new QueryChain();
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (1, 'E1', 'EE')"));
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (2, 'E2', 'EM')"));
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (3, 'E3', 'EE')"));
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (4, 'E4', 'EM')"));
        insert
                .addQuery(new SQLTemplate(
                        AbstractPerson.class,
                        "INSERT INTO PERSON (PERSON_ID, NAME, PERSON_TYPE) VALUES (5, 'E5', 'EE')"));
        createDataContext().performGenericQuery(insert);

View Full Code Here

Examples of org.apache.cayenne.query.QueryChain

    }


    public void testTRIM() {


        // insert via a SQL template to prevent adapter trimming and such...
        QueryChain inserts = new QueryChain();
        inserts.addQuery(new SQLTemplate(
                Artist.class,
                "INSERT INTO ARTIST (ARTIST_ID,ARTIST_NAME) VALUES(1, '  A')"));
        inserts.addQuery(new SQLTemplate(
                Artist.class,
                "INSERT INTO ARTIST (ARTIST_ID,ARTIST_NAME) VALUES(2, 'A  ')"));
        context.performGenericQuery(inserts);


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

View Full Code Here

Examples of org.apache.cayenne.query.QueryChain


    public void testUnrefreshingToOne() {


        ObjectContext context = createDataContext();


        QueryChain chain = new QueryChain();
        chain.addQuery(new SQLTemplate(
                Artist.class,
                "INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (1, 'a1')"));
        chain
                .addQuery(new SQLTemplate(
                        Painting.class,
                        "INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE) VALUES (1, 1, 'p1')"));


        context.performQuery(chain);

View Full Code Here

Examples of org.apache.cayenne.query.QueryChain


    public void testRefreshingToOne() {


        ObjectContext context = createDataContext();


        QueryChain chain = new QueryChain();
        chain.addQuery(new SQLTemplate(
                Artist.class,
                "INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (1, 'a1')"));
        chain
                .addQuery(new SQLTemplate(
                        Painting.class,
                        "INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE) VALUES (1, 1, 'p1')"));


        context.performQuery(chain);

View Full Code Here

Examples of org.apache.cayenne.query.QueryChain

        runInTransaction(new Transformer() {


            public Object transform(Object input) {
                new DataDomainLegacyQueryAction(
                        DataDomain.this,
                        new QueryChain(queries),
                        callback).execute();
                return null;
            }
        });
    }

View Full Code Here

Examples of org.apache.cayenne.query.QueryChain

        super.setUp();
        deleteTestData();
    }


    public void testToManyDisjointOverlappingQualifierWithInnerJoin() {
        QueryChain data = new QueryChain();
        data.addQuery(new SQLTemplate(
                Artist.class,
                "INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (1, 'A1')"));
        data.addQuery(new SQLTemplate(
                Artist.class,
                "INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (2, 'A2')"));
        data
                .addQuery(new SQLTemplate(
                        Artist.class,
                        "INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE) VALUES (1, 1, 'ABC')"));
        data
                .addQuery(new SQLTemplate(
                        Artist.class,
                        "INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE) VALUES (2, 1, 'ABD')"));
        data
                .addQuery(new SQLTemplate(
                        Artist.class,
                        "INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE) VALUES (3, 1, 'ACC')"));


        createDataContext().performGenericQuery(data);

View Full Code Here

0 1 2 3 4

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.