use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.
the class SelectQueryIT method testSelectBooleanFalse.
@Test
public void testSelectBooleanFalse() throws Exception {
createArtistsDataSet();
SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
Expression qual = ExpressionFactory.expFalse();
qual = qual.andExp(ExpressionFactory.matchExp("artistName", "artist1"));
query.setQualifier(qual);
List<?> objects = context.performQuery(query);
assertEquals(0, objects.size());
}
use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.
the class SelectQueryIT method testSelectParameterizedEmptyNotIn.
@Test
public void testSelectParameterizedEmptyNotIn() throws Exception {
createArtistsDataSet();
SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
Expression qual = ExpressionFactory.exp("artistName not in $list");
query.setQualifier(qual);
query = query.queryWithParameters(Collections.singletonMap("list", new Object[] {}));
List<?> objects = context.performQuery(query);
assertEquals(20, objects.size());
}
use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.
the class SelectQueryIT method testSelectLikeSingle_WildcardMatch.
@Test
public void testSelectLikeSingle_WildcardMatch() throws Exception {
createArtistsDataSet();
SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
Expression qual = ExpressionFactory.likeExp("artistName", "artist11%");
query.setQualifier(qual);
List<?> objects = context.performQuery(query);
assertEquals(1, objects.size());
}
use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.
the class SelectQueryIT method testSelectOne.
@Test
public void testSelectOne() throws Exception {
createArtistsDataSet();
SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
Expression qual = ExpressionFactory.matchExp("artistName", "artist1");
query.setQualifier(qual);
Artist artist = (Artist) query.selectOne(context);
assertEquals("artist1", artist.getArtistName());
}
use of org.apache.cayenne.testdo.testmap.Artist in project cayenne by apache.
the class SelectQueryIT method testIterator.
@Test
public void testIterator() throws Exception {
createArtistsDataSet();
SelectQuery<Artist> q1 = new SelectQuery<>(Artist.class);
try (ResultIterator<Artist> it = q1.iterator(context)) {
int count = 0;
for (@SuppressWarnings("unused") Artist a : it) {
count++;
}
assertEquals(20, count);
}
}
Aggregations