Package org.apache.cayenne.query

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

39
40
41
42
43
44
45
46
47
48
49
    }

    public void testDatabaseUnionCapabilities() {

        QueryChain inserts = new QueryChain();
        inserts
                .addQuery(new SQLTemplate(
                        SubEntity1.class,
                        "INSERT INTO INHERITANCE_SUB_ENTITY1 "
                                + "(ID, SUBENTITY_STRING_DB_ATTR, SUPER_INT_DB_ATTR, SUPER_STRING_DB_ATTR) "
                                + "VALUES (1, 'V11', 1, 'V21')"));
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
                        SubEntity1.class,
                        "INSERT INTO INHERITANCE_SUB_ENTITY1 "
                                + "(ID, SUBENTITY_STRING_DB_ATTR, SUPER_INT_DB_ATTR, SUPER_STRING_DB_ATTR) "
                                + "VALUES (1, 'V11', 1, 'V21')"));

        inserts
                .addQuery(new SQLTemplate(
                        SubEntity1.class,
                        "INSERT INTO INHERITANCE_SUB_ENTITY2 "
                                + "(ID, OVERRIDDEN_STRING_DB_ATTR, SUPER_INT_DB_ATTR, SUBENTITY_INT_DB_ATTR) "
                                + "VALUES (1, 'VX11', 101, 201)"));
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
    }

    public void testSelectQueryOnConcreteLeafEntity() {

        QueryChain inserts = new QueryChain();
        inserts
                .addQuery(new SQLTemplate(
                        SubEntity1.class,
                        "INSERT INTO INHERITANCE_SUB_ENTITY1 "
                                + "(ID, SUBENTITY_STRING_DB_ATTR, SUPER_INT_DB_ATTR, SUPER_STRING_DB_ATTR) "
                                + "VALUES (1, 'V11', 1, 'V21')"));
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
                .addQuery(new SQLTemplate(
                        SubEntity1.class,
                        "INSERT INTO INHERITANCE_SUB_ENTITY1 "
                                + "(ID, SUBENTITY_STRING_DB_ATTR, SUPER_INT_DB_ATTR, SUPER_STRING_DB_ATTR) "
                                + "VALUES (1, 'V11', 1, 'V21')"));
        inserts
                .addQuery(new SQLTemplate(
                        SubEntity1.class,
                        "INSERT INTO INHERITANCE_SUB_ENTITY1 "
                                + "(ID, SUBENTITY_STRING_DB_ATTR, SUPER_INT_DB_ATTR, SUPER_STRING_DB_ATTR) "
                                + "VALUES (2, 'V12', 2, 'V22')"));
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
    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,
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
        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
85
86
87
88
89
90
91
92
93
94
95
    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,
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
        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
88
89
90
91
92
93
94
95
96
97
98
  }

  static void mappingQueriesChapter(ObjectContext context) {

    QueryChain chain = new QueryChain();
    chain.addQuery(new NamedQuery("DeleteAll", Collections.singletonMap(
        "table", "PAINTING")));
    chain.addQuery(new NamedQuery("DeleteAll", Collections.singletonMap(
        "table", "ARTIST")));
    chain.addQuery(new NamedQuery("DeleteAll", Collections.singletonMap(
        "table", "GALLERY")));
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
  static void mappingQueriesChapter(ObjectContext context) {

    QueryChain chain = new QueryChain();
    chain.addQuery(new NamedQuery("DeleteAll", Collections.singletonMap(
        "table", "PAINTING")));
    chain.addQuery(new NamedQuery("DeleteAll", Collections.singletonMap(
        "table", "ARTIST")));
    chain.addQuery(new NamedQuery("DeleteAll", Collections.singletonMap(
        "table", "GALLERY")));

    context.performGenericQuery(chain);
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.