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_columnprefix;
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 OneManyColumnPrefixTest {
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_columnprefix/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_columnprefix/CreateDB.sql");
46 }
47
48 @Test
49 void shouldUseColumnPrefixWithMany() {
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 shouldUseColumnPrefixInXmlWithMany() {
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 shouldUseColumnPrefixWithOne() {
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().getName());
79 }
80 }
81
82 @Test
83 void shouldResolveNestedColumnPrefix() {
84 try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
85 UserDao mapper = sqlSession.getMapper(UserDao.class);
86 User user = mapper.findUserWithFriend(4);
87 assertEquals(4, user.getId());
88 assertEquals(2, user.getRoles().size());
89 assertEquals("student", user.getRoles().get(0).getName());
90 assertEquals("Learning-commissary", user.getRoles().get(1).getName());
91 assertEquals(1, user.getFriend().getId());
92 assertEquals(2, user.getFriend().getRoles().size());
93 assertEquals("teacher", user.getFriend().getRoles().get(0).getName());
94 assertEquals("Headmaster", user.getFriend().getRoles().get(1).getName());
95 }
96 }
97 }