Examples with Artist org.apache.cayenne.testdo.testmap.Artist used on opensource projects

Example 91 with Artist

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

the class SelectQueryIT method testSelectLikeCaseSensitive.

/**
 * SQL Server failure:
 * http://stackoverflow.com/questions/14962419/is-the-like-operator-case-sensitive-with-ms-sql-server
 */
@Test
public void testSelectLikeCaseSensitive() throws Exception {
    if (!accessStackAdapter.supportsCaseSensitiveLike()) {
        return;
    }
    createArtistsDataSet();
    SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
    Expression qual = ExpressionFactory.likeExp("artistName", "aRtIsT%");
    query.setQualifier(qual);
    List<?> objects = context.performQuery(query);
    assertEquals(0, objects.size());
}

Example 92 with Artist

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

the class SelectQueryIT method testSelectEmptyIn.

@Test
public void testSelectEmptyIn() throws Exception {
    createArtistsDataSet();
    SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
    Expression qual = ExpressionFactory.inExp("artistName");
    query.setQualifier(qual);
    List<?> objects = context.performQuery(query);
    assertEquals(0, objects.size());
}

Example 93 with Artist

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

the class SelectQueryIT method testRouteQueryWithPrefetchesNoReverse.

/**
 * Tests that all queries specified in prefetch are executed in a more
 * complex prefetch scenario with no reverse obj relationships.
 */
@Test
public void testRouteQueryWithPrefetchesNoReverse() {
    EntityResolver resolver = context.getEntityResolver();
    ObjEntity paintingEntity = resolver.getObjEntity(Painting.class);
    ObjEntity galleryEntity = resolver.getObjEntity(Gallery.class);
    ObjEntity artistExhibitEntity = resolver.getObjEntity(ArtistExhibit.class);
    ObjEntity exhibitEntity = resolver.getObjEntity(Exhibit.class);
    ObjRelationship paintingToArtistRel = paintingEntity.getRelationship("toArtist");
    paintingEntity.removeRelationship("toArtist");
    ObjRelationship galleryToPaintingRel = galleryEntity.getRelationship("paintingArray");
    galleryEntity.removeRelationship("paintingArray");
    ObjRelationship artistExhibitToArtistRel = artistExhibitEntity.getRelationship("toArtist");
    artistExhibitEntity.removeRelationship("toArtist");
    ObjRelationship exhibitToArtistExhibitRel = exhibitEntity.getRelationship("artistExhibitArray");
    exhibitEntity.removeRelationship("artistExhibitArray");
    Expression e = ExpressionFactory.matchExp("artistName", "artist1");
    SelectQuery<Artist> q = new SelectQuery<>(Artist.class, e);
    q.addPrefetch("paintingArray");
    q.addPrefetch("paintingArray.toGallery");
    q.addPrefetch("artistExhibitArray.toExhibit");
    try {
        MockQueryRouter router = new MockQueryRouter();
        q.route(router, resolver, null);
        assertEquals(4, router.getQueryCount());
    } finally {
        paintingEntity.addRelationship(paintingToArtistRel);
        galleryEntity.addRelationship(galleryToPaintingRel);
        artistExhibitEntity.addRelationship(artistExhibitToArtistRel);
        exhibitEntity.addRelationship(exhibitToArtistExhibitRel);
    }
}

Example 94 with Artist

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

the class SelectQueryIT method testSelectBooleanTrue.

@Test
public void testSelectBooleanTrue() throws Exception {
    createArtistsDataSet();
    SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
    Expression qual = ExpressionFactory.expTrue();
    qual = qual.andExp(ExpressionFactory.matchExp("artistName", "artist1"));
    query.setQualifier(qual);
    List<?> objects = context.performQuery(query);
    assertEquals(1, objects.size());
}

Example 95 with Artist

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

the class SelectQueryIT method testSelectBooleanFalseOr.

@Test
public void testSelectBooleanFalseOr() throws Exception {
    createArtistsDataSet();
    SelectQuery<Artist> query = new SelectQuery<>(Artist.class);
    Expression qual = ExpressionFactory.expFalse();
    qual = qual.orExp(ExpressionFactory.matchExp("artistName", "artist1"));
    query.setQualifier(qual);
    List<?> objects = context.performQuery(query);
    assertEquals(1, objects.size());
}