Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.QueryChain.addQuery()

83
84
85
86
87
88
89
90
91
92
93
                "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(
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
                        "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
109
110
111
112
113
114
115
116
117
118
119
        assertEquals(3, a.getPaintingArray().size());
    }

    public void testToManyJointOverlappingQualifierWithOuterJoin() {
        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')"));
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
    public void testToManyJointOverlappingQualifierWithOuterJoin() {
        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,
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
                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(
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
                "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(
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
                        "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
37
38
39
40
41
42
43
44
45
46
47
        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(
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
        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
58
59
60
61
62
63
64
65
66
67
68
        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(
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.