Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.EJBQLQuery

137
138
139
140
141
142
143
144
145
146
147
                + " SELECT DISTINCT p1.paintingTitle FROM Painting p1"
                + " WHERE p1.paintingTitle = p.paintingTitle"
                + " AND p.estimatedPrice <> p1.estimatedPrice"
                + ")";

        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());

        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
                + " WHERE p.estimatedPrice > ALL ("
                + " SELECT p1.estimatedPrice FROM Painting p1"
                + " WHERE p1.paintingTitle = 'P2'"
                + ")";

        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(2, objects.size());

        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
                + " WHERE p.estimatedPrice > ANY ("
                + " SELECT p1.estimatedPrice FROM Painting p1"
                + " WHERE p1.paintingTitle = 'P1'"
                + ")";

        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(3, objects.size());

        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
                + " WHERE p.estimatedPrice > SOME ("
                + " SELECT p1.estimatedPrice FROM Painting p1"
                + " WHERE p1.paintingTitle = 'P1'"
                + ")";

        EJBQLQuery query = new EJBQLQuery(ejbql);
        List<?> objects = context.performQuery(query);
        assertEquals(3, objects.size());

        Set<Object> ids = new HashSet<Object>();
        Iterator<?> it = objects.iterator();
View Full Code Here
121
122
123
124
125
126
127
128
129
130
        a1.setArtistName("XX");
        context.commitChanges();
        assertEquals(0, a1.getPostLoaded());
        assertNull(listener.getPublicCalledbackEntity());

        EJBQLQuery q = new EJBQLQuery("select a, a.artistName from Artist a");
        context.performQuery(q);
        assertEquals(1, a1.getPostLoaded());
        assertSame(a1, listener.getPublicCalledbackEntity());
    }
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
        createFivePaintings();

        String ejbql = "SELECT p.estimatedPrice, count(p) FROM Painting p"
                + " GROUP BY p.estimatedPrice"
                + " ORDER BY p.estimatedPrice";
        EJBQLQuery query = new EJBQLQuery(ejbql);

        List<?> data = context.performQuery(query);
        assertEquals(2, data.size());
        assertTrue(data.get(0) instanceof Object[]);
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
        createFivePaintings();

        String ejbql = "SELECT p.estimatedPrice, p.paintingTitle, count(p) FROM Painting p"
                + " GROUP BY p.estimatedPrice, p.paintingTitle"
                + " ORDER BY p.estimatedPrice, p.paintingTitle";
        EJBQLQuery query = new EJBQLQuery(ejbql);

        List<?> data = context.performQuery(query);
        assertEquals(3, data.size());
        assertTrue(data.get(0) instanceof Object[]);
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
        createFourArtistsAndTwoPaintings();

        String ejbql = "SELECT COUNT(p), a, a.artistName "
                + "FROM Painting p INNER JOIN p.toArtist a GROUP BY a, a.artistName "
                + "ORDER BY a.artistName";
        EJBQLQuery query = new EJBQLQuery(ejbql);

        List<?> data = context.performQuery(query);
        assertEquals(2, data.size());

        assertTrue(data.get(0) instanceof Object[]);
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
    public void testGroupByIdVariable() throws Exception {
        createFivePaintings();

        String ejbql = "SELECT count(p), p FROM Painting p GROUP BY p";
        EJBQLQuery query = new EJBQLQuery(ejbql);

        List<?> data = context.performQuery(query);
        assertEquals(5, data.size());

        // TODO: andrus, 8/3/2007 the rest of the unit test fails as currently Cayenne
View Full Code Here
201
202
203
204
205
206
207
208
209
210
211
        createFivePaintings();

        String ejbql = "SELECT p.estimatedPrice, count(p) FROM Painting p"
                + " GROUP BY p.estimatedPrice"
                + " HAVING p.estimatedPrice > 1";
        EJBQLQuery query = new EJBQLQuery(ejbql);

        List<?> data = context.performQuery(query);
        assertEquals(1, data.size());
        assertTrue(data.get(0) instanceof Object[]);
View Full Code Here
TOP

Related Classes of org.apache.cayenne.query.EJBQLQuery

  • com.adaptrex.core.persistence.cayenne.CayenneStoreData
  • org.apache.cayenne.access.DataContextEJBQLArrayResultTest
  • org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest
  • org.apache.cayenne.access.DataContextEJBQLConditionsTest
  • org.apache.cayenne.access.DataContextEJBQLDeleteTest
  • org.apache.cayenne.access.DataContextEJBQLFetchJoinTest
  • org.apache.cayenne.access.DataContextEJBQLFlattenedRelationshipsTest
  • org.apache.cayenne.access.DataContextEJBQLFunctionalExpressions
  • org.apache.cayenne.access.DataContextEJBQLFunctionalExpressionsTemp
  • org.apache.cayenne.access.DataContextEJBQLGroupByHavingTest
    • 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.