Package org.apache.cayenne.exp

Examples of org.apache.cayenne.exp.Expression

276
277
278
279
280
281
282
283
284
285
    /** Test how "like ignore case" works when using lowercase parameter. */
    public void testSelectLikeIgnoreCaseObjects2() throws Exception {
        createArtistsDataSet();
        SelectQuery query = new SelectQuery(Artist.class);
        Expression qual = ExpressionFactory.likeIgnoreCaseExp("artistName", "artist%");
        query.setQualifier(qual);
        List objects = context.performQuery(query);
        assertEquals(20, objects.size());
    }
View Full Code Here
287
288
289
290
291
292
293
294
295
296
297
    /** Test how "like ignore case" works when using uppercase parameter. */
    public void testSelectLikeIgnoreCaseClob() throws Exception {
        if (accessStackAdapter.supportsLobs()) {
            createClobDataSet();
            SelectQuery query = new SelectQuery(ClobTestEntity.class);
            Expression qual = ExpressionFactory.likeIgnoreCaseExp("clobCol", "clob%");
            query.setQualifier(qual);
            List objects = context.performQuery(query);
            assertEquals(2, objects.size());
        }
    }
View Full Code Here
298
299
300
301
302
303
304
305
306
307
308
   
    public void testSelectEqualsClob() throws Exception {
        if (accessStackAdapter.supportsLobs()) {
            createClobDataSet();
            SelectQuery query = new SelectQuery(ClobTestEntity.class);
            Expression qual = ExpressionFactory.matchExp("clobCol", "clob1");
            query.setQualifier(qual);
            List objects = context.performQuery(query);
            assertEquals(1, objects.size());
        }
    }
View Full Code Here
309
310
311
312
313
314
315
316
317
318
319
   
    public void testSelectNotEqualsClob() throws Exception {
        if (accessStackAdapter.supportsLobs()) {
            createClobDataSet();
            SelectQuery query = new SelectQuery(ClobTestEntity.class);
            Expression qual = ExpressionFactory.noMatchExp("clobCol", "clob1");
            query.setQualifier(qual);
            List objects = context.performQuery(query);
            assertEquals(1, objects.size());
        }
    }
View Full Code Here
319
320
321
322
323
324
325
326
327
328
    }
   
    public void testSelectIn() throws Exception {
        createArtistsDataSet();
        SelectQuery query = new SelectQuery(Artist.class);
        Expression qual = Expression.fromString("artistName in ('artist1', 'artist2')");
        query.setQualifier(qual);
        List objects = context.performQuery(query);
        assertEquals(2, objects.size());
    }
View Full Code Here
328
329
330
331
332
333
334
335
336
337
338
    }

    public void testSelectParameterizedIn() throws Exception {
        createArtistsDataSet();
        SelectQuery query = new SelectQuery(Artist.class);
        Expression qual = Expression.fromString("artistName in $list");
        query.setQualifier(qual);
        query = query.queryWithParameters(Collections.singletonMap("list", new Object[] {
                "artist1", "artist2"
        }));
        List objects = context.performQuery(query);
View Full Code Here
340
341
342
343
344
345
346
347
348
349
350
    }

    public void testSelectParameterizedEmptyIn() throws Exception {
        createArtistsDataSet();
        SelectQuery query = new SelectQuery(Artist.class);
        Expression qual = Expression.fromString("artistName in $list");
        query.setQualifier(qual);
        query = query.queryWithParameters(Collections.singletonMap(
                "list",
                new Object[] {}));
        List objects = context.performQuery(query);
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
    }

    public void testSelectParameterizedEmptyNotIn() throws Exception {
        createArtistsDataSet();
        SelectQuery query = new SelectQuery(Artist.class);
        Expression qual = Expression.fromString("artistName not in $list");
        query.setQualifier(qual);
        query = query.queryWithParameters(Collections.singletonMap(
                "list",
                new Object[] {}));
        List objects = context.performQuery(query);
View Full Code Here
364
365
366
367
368
369
370
371
372
373
    }

    public void testSelectEmptyIn() throws Exception {
        createArtistsDataSet();
        SelectQuery query = new SelectQuery(Artist.class);
        Expression qual = ExpressionFactory.inExp("artistName");
        query.setQualifier(qual);
        List objects = context.performQuery(query);
        assertEquals(0, objects.size());
    }
View Full Code Here
373
374
375
376
377
378
379
380
381
382
    }

    public void testSelectEmptyNotIn() throws Exception {
        createArtistsDataSet();
        SelectQuery query = new SelectQuery(Artist.class);
        Expression qual = ExpressionFactory.notInExp("artistName");
        query.setQualifier(qual);
        List objects = context.performQuery(query);
        assertEquals(20, objects.size());
    }
View Full Code Here
TOP

Related Classes of org.apache.cayenne.exp.Expression

  • cayenne.tutorial.client.Main
  • cayenne.tutorial.Main
  • com.adaptrex.core.persistence.cayenne.CayennePersistenceManager
  • com.adaptrex.core.persistence.cayenne.CayenneStoreData
  • er.cayenne.example.components.Main
  • net.bnubot.db.Account
  • net.bnubot.db.BNLogin
  • net.bnubot.db.Command
  • net.sf.pummel.library.LibraryManager
  • org.apache.cayenne.access.DataContextCharTypeTest
    • 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.