Search in sources :

Example 86 with Artist

use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.

the class SelectById_RunIT method testIntPk_SelectFirst.

@Test
public void testIntPk_SelectFirst() throws Exception {
    createTwoArtists();
    Artist a3 = SelectById.query(Artist.class, 3).selectFirst(context);
    assertNotNull(a3);
    assertEquals("artist3", a3.getArtistName());
    Artist a2 = SelectById.query(Artist.class, 2).selectFirst(context);
    assertNotNull(a2);
    assertEquals("artist2", a2.getArtistName());
}
Also used : Artist(org.apache.cayenne.testdo.testmap.Artist) Test(org.junit.Test)

Example 87 with Artist

use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.

the class SelectQueryIT method testMatchObject.

@Test
public void testMatchObject() {
    Artist a1 = context.newObject(Artist.class);
    a1.setArtistName("a1");
    Artist a2 = context.newObject(Artist.class);
    a2.setArtistName("a2");
    Artist a3 = context.newObject(Artist.class);
    a3.setArtistName("a3");
    context.commitChanges();
    SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
    query.setQualifier(ExpressionFactory.matchExp(a2));
    Artist result = query.selectOne(context);
    assertSame(a2, result);
}
Also used : Artist(org.apache.cayenne.testdo.testmap.Artist) Test(org.junit.Test)

Example 88 with Artist

use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.

the class SelectQueryIT method testSelectNotLikeSingleWildcardMatch.

@Test
public void testSelectNotLikeSingleWildcardMatch() throws Exception {
    createArtistsDataSet();
    SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
    Expression qual = ExpressionFactory.notLikeExp("artistName", "artist11%");
    query.setQualifier(qual);
    List<?> objects = context.performQuery(query);
    assertEquals(19, objects.size());
}
Also used : Artist(org.apache.cayenne.testdo.testmap.Artist) Expression(org.apache.cayenne.exp.Expression) Test(org.junit.Test)

Example 89 with Artist

use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.

the class SelectQueryIT method testMatchByRelatedObject.

@Test
public void testMatchByRelatedObject() {
    Artist a1 = context.newObject(Artist.class);
    a1.setArtistName("a1");
    Artist a2 = context.newObject(Artist.class);
    a2.setArtistName("a2");
    Painting p1 = context.newObject(Painting.class);
    p1.setPaintingTitle("p1");
    p1.setToArtist(a1);
    Painting p2 = context.newObject(Painting.class);
    p2.setPaintingTitle("p2");
    p2.setToArtist(a2);
    context.commitChanges();
    SelectQuery<Painting> query = new SelectQuery<>(Painting.class);
    query.setQualifier(ExpressionFactory.matchExp("toArtist", a1));
    assertSame(p1, query.selectOne(context));
}
Also used : Artist(org.apache.cayenne.testdo.testmap.Artist) Painting(org.apache.cayenne.testdo.testmap.Painting) Test(org.junit.Test)

Example 90 with Artist

use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.

the class SelectQueryIT method testSelectFirst.

@Test
public void testSelectFirst() throws Exception {
    createArtistsDataSet();
    SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
    query.addOrdering(new Ordering(Artist.ARTIST_NAME.getName()));
    Artist artist = query.selectFirst(context);
    assertNotNull(artist);
    assertEquals("artist1", artist.getArtistName());
}
Also used : Artist(org.apache.cayenne.testdo.testmap.Artist) Test(org.junit.Test)

Aggregations

Artist (org.apache.cayenne.testdo.testmap.Artist)490 Test (org.junit.Test)481 Painting (org.apache.cayenne.testdo.testmap.Painting)145 SelectQuery (org.apache.cayenne.query.SelectQuery)126 Expression (org.apache.cayenne.exp.Expression)67 UnitTestClosure (org.apache.cayenne.unit.di.UnitTestClosure)47 EJBQLQuery (org.apache.cayenne.query.EJBQLQuery)39 List (java.util.List)36 ObjectContext (org.apache.cayenne.ObjectContext)30 SQLTemplate (org.apache.cayenne.query.SQLTemplate)26 ParallelTestContainer (org.apache.cayenne.test.parallel.ParallelTestContainer)26 DataRow (org.apache.cayenne.DataRow)21 ArrayList (java.util.ArrayList)20 ValueHolder (org.apache.cayenne.ValueHolder)18 ArtGroup (org.apache.cayenne.testdo.testmap.ArtGroup)16 LifecycleCallbackRegistry (org.apache.cayenne.reflect.LifecycleCallbackRegistry)15 ObjectId (org.apache.cayenne.ObjectId)14 ROPainting (org.apache.cayenne.testdo.testmap.ROPainting)13 Gallery (org.apache.cayenne.testdo.testmap.Gallery)12 ROArtist (org.apache.cayenne.testdo.testmap.ROArtist)12