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());
}
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);
}
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());
}
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));
}
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());
}
Aggregations