private void checkResult1(List<Person> result) {
assertEquals(2, result.size());
Person p1 = result.get(0);
assertTrue(p1.getName().startsWith("爸爸"));
assertTrue(p1.getScores().size() == 6);
assertEquals(80, CollectionUtils.findFirst(p1.getScores(), "subject", "英语").getScore());
assertEquals(90, CollectionUtils.findFirst(p1.getScores(), "subject", "物理").getScore());
assertEquals(50, CollectionUtils.findFirst(p1.getScores(), "subject", "电脑").getScore());
assertEquals(70, CollectionUtils.findFirst(p1.getScores(), "subject", "算数").getScore());
assertEquals(60, CollectionUtils.findFirst(p1.getScores(), "subject", "语文").getScore());
assertEquals(100, CollectionUtils.findFirst(p1.getScores(), "subject", "化学").getScore());
assertTrue(p1.getSchoolId() == 2);
assertEquals("战国高校", p1.getSchoolName());
assertEquals(p1.getSchoolName(), p1.getSchool().getName());
assertEquals(p1.getSchoolId(), p1.getSchool().getId());
assertEquals(2, p1.getFriends().size());
assertEquals(p1.getFriendComment()[0], p1.getFriends().get(0).getComment());
assertTrue(p1.getFriends().get(0).getFriend().getName().startsWith("JinWang"));
assertTrue(p1.getFriends().get(1).getFriend().getName().startsWith("儿子"));
p1.getParentName();
}
/**
* 测试级联对象的插入操作
*
* @throws SQLException
*/
@Test
public void testRefInsert() throws SQLException {
System.out.println("=========== testRefInsert Begin ==========");
Person p = new Person();
p.setName("张三");
p.setGender("M");
p.setSchool(new School("浙江大学"));
p.setAge(22);
db.insertCascade(p);
System.out.println(p.getId());
Person query = new Person();
query.setId(p.getId());
query = db.load(query);
assertEquals("浙江大学", query.getSchoolName());
System.out.println("=========== testRefInsert End ==========");
}
