Artist a = result.get(0);
assertEquals(3, a.getPaintingArray().size());
}
public void testToManyJointOverlappingQualifierWithInnerJoin() {
QueryChain data = new QueryChain();
data.addQuery(new SQLTemplate(
Artist.class,
"INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (1, 'A1')"));
data.addQuery(new SQLTemplate(
Artist.class,
"INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (2, 'A2')"));
data
.addQuery(new SQLTemplate(
Artist.class,
"INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE) VALUES (1, 1, 'ABC')"));
data
.addQuery(new SQLTemplate(
Artist.class,
"INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE) VALUES (2, 1, 'ABD')"));
data
.addQuery(new SQLTemplate(
Artist.class,
"INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE) VALUES (3, 1, 'ACC')"));
createDataContext().performGenericQuery(data);