Package org.apache.cayenne.query

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

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 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')"));
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
    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,
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
                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
47
48
49
50
51
52
53
54
55
56
57
                "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
51
52
53
54
55
56
57
58
59
60
61
                        "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
73
74
75
76
77
78
79
80
81
82
83
        assertEquals(3, a.getPaintingArray().size());
    }

    public void testToManyJointOverlappingQualifierWithInnerJoin() {
        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
76
77
78
79
80
81
82
83
84
85
86
    public void testToManyJointOverlappingQualifierWithInnerJoin() {
        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
79
80
81
82
83
84
85
86
87
88
89
                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
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.