View Javadoc
1   /*
2    *    Copyright 2009-2021 the original author or authors.
3    *
4    *    Licensed under the Apache License, Version 2.0 (the "License");
5    *    you may not use this file except in compliance with the License.
6    *    You may obtain a copy of the License at
7    *
8    *       http://www.apache.org/licenses/LICENSE-2.0
9    *
10   *    Unless required by applicable law or agreed to in writing, software
11   *    distributed under the License is distributed on an "AS IS" BASIS,
12   *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13   *    See the License for the specific language governing permissions and
14   *    limitations under the License.
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  }