Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.SelectQuery

73
74
75
76
77
78
79
80
81
82
83
        cal.set(2002, 1, 1);
        Date nowDate = cal.getTime();
        test.setDateColumn(nowDate);
        context.commitChanges();

        SelectQuery q = new SelectQuery(DateTestEntity.class);
        DateTestEntity testRead = (DateTestEntity) context.performQuery(q).get(0);
        assertNotNull(testRead.getDateColumn());
        assertEquals(nowDate, testRead.getDateColumn());
        assertEquals(Date.class, testRead.getDateColumn().getClass());
    }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
        cal.set(1970, 0, 1, 1, 20, 30);
        Date nowTime = cal.getTime();
        test.setTimeColumn(nowTime);
        context.commitChanges();

        SelectQuery q = new SelectQuery(DateTestEntity.class);
        DateTestEntity testRead = (DateTestEntity) context.performQuery(q).get(0);
        assertNotNull(testRead.getTimeColumn());
        assertEquals(Date.class, testRead.getTimeColumn().getClass());

        // OpenBase fails to store seconds for the time
View Full Code Here
118
119
120
121
122
123
124
125
126
127
        Date now = cal.getTime();
        test.setTimestampColumn(now);
        context.commitChanges();

        SelectQuery q = new SelectQuery(DateTestEntity.class);
        DateTestEntity testRead = (DateTestEntity) context.performQuery(q).get(0);
        assertNotNull(testRead.getTimestampColumn());
        assertEquals(now, testRead.getTimestampColumn());
    }
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
                ClientMtTable1.class));
    }

    public void testSynchronizeCommit() throws Exception {

        SelectQuery query = new SelectQuery(MtTable1.class);

        // no changes...
        clientServerChannel.onSync(
                serverContext,
                new MockGraphDiff(),
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
    }

    public void testPerformQueryObjectIDInjection() throws Exception {
        tMtTable1.insert(55, "g1", "s1");

        Query query = new SelectQuery("MtTable1");
        QueryResponse response = clientServerChannel.onQuery(null, query);

        assertNotNull(response);

        List<?> results = response.firstList();
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
                1, 2, 3
        };

        tMtTable3.insert(1, bytes, "abc", 4);

        Query query = new SelectQuery("MtTable3");
        QueryResponse response = clientServerChannel.onQuery(null, query);

        assertNotNull(response);

        List<?> results = response.firstList();
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
    public void testPerformQueryPropagationInheritance() throws Exception {

        tMtTable1.insert(65, "sub1", "xyz");

        SelectQuery query = new SelectQuery(ClientMtTable1.class);
        QueryResponse response = clientServerChannel.onQuery(null, query);

        assertNotNull(response);

        List<?> results = response.firstList();
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
226
227
    }

    public void testOnQueryPrefetchingToMany() throws Exception {
        createTwoMtTable1sAnd2sDataSet();

        SelectQuery query = new SelectQuery(ClientMtTable1.class);
        query.addOrdering(ClientMtTable1.GLOBAL_ATTRIBUTE1_PROPERTY, SortOrder.ASCENDING);
        query.addPrefetch(ClientMtTable1.TABLE2ARRAY_PROPERTY);

        final List<?> results = clientServerChannel.onQuery(null, query).firstList();

        queryInterceptor.runWithQueriesBlocked(new UnitTestClosure() {
View Full Code Here
240
241
242
243
244
245
246
247
248
249
250
251
252
    }

    public void testOnQueryPrefetchingToManyEmpty() throws Exception {
        createTwoMtTable1sAnd2sDataSet();

        SelectQuery q = new SelectQuery(ClientMtTable1.class);
        q.addOrdering(ClientMtTable1.GLOBAL_ATTRIBUTE1_PROPERTY, SortOrder.ASCENDING);
        q.addPrefetch(ClientMtTable1.TABLE2ARRAY_PROPERTY);

        final List<?> results = clientServerChannel.onQuery(null, q).firstList();

        queryInterceptor.runWithQueriesBlocked(new UnitTestClosure() {
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
        ObjectContext context = createDataContext();

        Artist picasso = Cayenne.objectForPK(context, Artist.class, 1);
        Artist dali = Cayenne.objectForPK(context, Artist.class, 2);

        SelectQuery query = new SelectQuery(Gallery.class);
        query.andQualifier(ExpressionFactory.matchAllExp(
                "|exhibitArray.artistExhibitArray.toArtist",
                picasso,
                dali));

        List<Gallery> galleries = context.performQuery(query);
View Full Code Here
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
    • Copyright © 2018 www.massapicom. 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.