1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16 package org.apache.ibatis.submitted.localtime;
17
18 import static org.junit.jupiter.api.Assertions.*;
19
20 import java.io.Reader;
21 import java.time.LocalTime;
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 LocalTimeTest {
32
33 private static SqlSessionFactory sqlSessionFactory;
34
35 @BeforeAll
36 static void setUp() throws Exception {
37 try (Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/localtime/mybatis-config.xml")) {
38 sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
39 }
40 BaseDataTest.runScript(sqlSessionFactory.getConfiguration().getEnvironment().getDataSource(),
41 "org/apache/ibatis/submitted/localtime/CreateDB.sql");
42 }
43
44 @Test
45 void shouldSelectLocalTimeWithNanoseconds() {
46 try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
47 Mapper mapper = sqlSession.getMapper(Mapper.class);
48 Record record = mapper.selectById(1);
49 assertEquals(LocalTime.of(11, 22, 33, 123456789), record.getT());
50 }
51 }
52
53 @Test
54 void shouldInsertLocalTimeWithNanoseconds() {
55 LocalTime t = LocalTime.of(11, 22, 33, 123456789);
56 try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
57 Mapper mapper = sqlSession.getMapper(Mapper.class);
58 Record record = new Record();
59 record.setId(2);
60 record.setT(t);
61 int result = mapper.insertLocalTime(record);
62 assertEquals(1, result);
63 sqlSession.commit();
64 }
65 try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
66 Mapper mapper = sqlSession.getMapper(Mapper.class);
67 Record record = mapper.selectById(2);
68 assertEquals(t, record.getT());
69 }
70 }
71
72 }