1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 package org.apache.ibatis.submitted.annotion_many_one_add_resultmapid;
17
18 import static org.junit.jupiter.api.Assertions.*;
19
20 import java.io.Reader;
21 import java.util.List;
22
23 import org.apache.ibatis.BaseDataTest;
24 import org.apache.ibatis.io.Resources;
25 import org.apache.ibatis.session.SqlSession;
26 import org.apache.ibatis.session.SqlSessionFactory;
27 import org.apache.ibatis.session.SqlSessionFactoryBuilder;
28 import org.junit.jupiter.api.BeforeAll;
29 import org.junit.jupiter.api.Test;
30
31 class OneManyResultMapTest {
32
33 private static SqlSessionFactory sqlSessionFactory;
34
35 @BeforeAll
36 static void setUp() throws Exception {
37
38 try (Reader reader = Resources
39 .getResourceAsReader("org/apache/ibatis/submitted/annotion_many_one_add_resultmapid/SqlMapConfig.xml")) {
40 sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
41 }
42
43
44 BaseDataTest.runScript(sqlSessionFactory.getConfiguration().getEnvironment().getDataSource(),
45 "org/apache/ibatis/submitted/annotion_many_one_add_resultmapid/CreateDB.sql");
46 }
47
48 @Test
49 void shouldUseResultMapWithMany() {
50 try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
51 UserDao mapper = sqlSession.getMapper(UserDao.class);
52 List<User> users = mapper.findAll();
53 assertNotNull(users);
54 assertEquals(4, users.size());
55 assertEquals(2, users.get(0).getRoles().size());
56 }
57 }
58
59 @Test
60 void shouldUseResultMapInXmlWithMany() {
61 try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
62 UserDao mapper = sqlSession.getMapper(UserDao.class);
63 List<User> users = mapper.findAll2();
64 assertNotNull(users);
65 assertEquals(4, users.size());
66 assertEquals(2, users.get(0).getRoles().size());
67 }
68 }
69
70 @Test
71 void shouldUseResultMapWithOne() {
72 try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
73 UserDao mapper = sqlSession.getMapper(UserDao.class);
74 List<User> users = mapper.findAll3();
75 assertNotNull(users);
76 assertEquals(2, users.size());
77 assertNotNull(users.get(0).getRole());
78 assertEquals("teacher", users.get(0).getRole().getRoleName());
79 }
80 }
81
82 @Test
83 void shouldResolveResultMapInTheSameNamespace() {
84 try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
85 UserDao mapper = sqlSession.getMapper(UserDao.class);
86 User headmaster = mapper.findHeadmaster();
87 assertNotNull(headmaster);
88 assertEquals(3, headmaster.getTeachers().size());
89 assertEquals("Doug Lea", headmaster.getTeachers().get(0).getUsername());
90 }
91 }
92
93 }