Search in sources :

Example 11 with Girl2

use of jodd.db.oom.tst.Girl2 in project jodd by oblac.

the class EntityCacheTest method testMapRows2Types_entityAware_List.

@Test
public void testMapRows2Types_entityAware_List() {
    DbOomQuery q = new DbOomQuery(sql(TSQL));
    List<Girl2> result2 = q.withHints("g", "g.boys").entityAwareMode(true).list(1, Girl2.class, Boy.class);
    assertEquals(1, result2.size());
    Girl2 girl1 = result2.get(0);
    assertNotNull(girl1.getBoys());
    assertEquals(2, girl1.getBoys().size());
}
Also used : Girl2(jodd.db.oom.tst.Girl2) Test(org.junit.Test)

Example 12 with Girl2

use of jodd.db.oom.tst.Girl2 in project jodd by oblac.

the class EntityCacheTest method testMapRows2Types_useCache_noHints.

@Test
public void testMapRows2Types_useCache_noHints() {
    DbOomQuery q = new DbOomQuery(sql(TSQL));
    List<Object[]> result = q.cacheEntities(true).list(Girl2.class, Boy.class);
    assertEquals(3, result.size());
    Girl2 girl1 = (Girl2) result.get(0)[0];
    Girl2 girl2 = (Girl2) result.get(1)[0];
    Girl2 girl3 = (Girl2) result.get(2)[0];
    assertTrue(girl1.equals(girl2));
    assertTrue(girl1 == girl2);
    assertFalse(girl3 == girl1);
    Boy boy1 = (Boy) result.get(0)[1];
    Boy boy2 = (Boy) result.get(1)[1];
    Boy boy3 = (Boy) result.get(2)[1];
    assertTrue(boy1.id != boy2.id);
    assertFalse(boy1 == boy2);
    assertFalse(boy2 == boy3);
    assertNull(girl1.getBoys());
    assertNull(girl3.getBoys());
}
Also used : Boy(jodd.db.oom.tst.Boy) Girl2(jodd.db.oom.tst.Girl2) Test(org.junit.Test)

Example 13 with Girl2

use of jodd.db.oom.tst.Girl2 in project jodd by oblac.

the class EntityCacheTest method testMapRows2Types_useCache_noHints_LEFT.

@Test
public void testMapRows2Types_useCache_noHints_LEFT() {
    DbOomQuery q = new DbOomQuery(sql(TSQL_LEFT));
    List<Object[]> result = q.cacheEntities(true).list(Girl2.class, Boy.class);
    assertEquals(4, result.size());
    Girl2 girl0 = (Girl2) result.get(0)[0];
    Girl2 girl1 = (Girl2) result.get(1)[0];
    Girl2 girl2 = (Girl2) result.get(2)[0];
    Girl2 girl3 = (Girl2) result.get(3)[0];
    assertEquals("Emma", girl0.name);
    assertTrue(girl1.equals(girl2));
    assertTrue(girl1 == girl2);
    assertFalse(girl3 == girl1);
    Boy boy0 = (Boy) result.get(0)[1];
    Boy boy1 = (Boy) result.get(1)[1];
    Boy boy2 = (Boy) result.get(2)[1];
    Boy boy3 = (Boy) result.get(3)[1];
    assertNull(boy0);
    assertTrue(boy1.id != boy2.id);
    assertFalse(boy1 == boy2);
    assertFalse(boy2 == boy3);
    assertNull(girl1.getBoys());
    assertNull(girl3.getBoys());
}
Also used : Boy(jodd.db.oom.tst.Boy) Girl2(jodd.db.oom.tst.Girl2) Test(org.junit.Test)

Example 14 with Girl2

use of jodd.db.oom.tst.Girl2 in project jodd by oblac.

the class EntityCacheTest method testMapRows2Types_entityAware_Find_LEFT.

@Test
public void testMapRows2Types_entityAware_Find_LEFT() {
    DbOomQuery q = new DbOomQuery(sql(TSQL_LEFT));
    Girl2 girl0 = q.withHints("g", "g.boys").entityAwareMode(true).find(Girl2.class, Boy.class);
    assertNull(girl0.getBoys());
}
Also used : Girl2(jodd.db.oom.tst.Girl2) Test(org.junit.Test)

Example 15 with Girl2

use of jodd.db.oom.tst.Girl2 in project jodd by oblac.

the class EntityCacheTest method testMapRows2Types_entityAware_Find.

@Test
public void testMapRows2Types_entityAware_Find() {
    DbOomQuery q = new DbOomQuery(sql(TSQL));
    Girl2 girl1 = q.withHints("g", "g.boys").entityAwareMode(true).find(Girl2.class, Boy.class);
    assertNotNull(girl1.getBoys());
    assertEquals(2, girl1.getBoys().size());
}
Also used : Girl2(jodd.db.oom.tst.Girl2) Test(org.junit.Test)

Aggregations

Girl2 (jodd.db.oom.tst.Girl2)18 Test (org.junit.Test)17 Boy (jodd.db.oom.tst.Boy)3 DbThreadSession (jodd.db.DbThreadSession)2 ResultSet (java.sql.ResultSet)1 SQLException (java.sql.SQLException)1 DbQuery (jodd.db.DbQuery)1 DbSession (jodd.db.DbSession)1 Girl (jodd.db.oom.tst.Girl)1 IdName (jodd.db.oom.tst.IdName)1 Before (org.junit.Before)1