View Javadoc
1   /**
2    *    Copyright 2009-2019 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.ognlstatic;
17  
18  import java.io.Reader;
19  
20  import org.apache.ibatis.BaseDataTest;
21  import org.apache.ibatis.io.Resources;
22  import org.apache.ibatis.session.SqlSession;
23  import org.apache.ibatis.session.SqlSessionFactory;
24  import org.apache.ibatis.session.SqlSessionFactoryBuilder;
25  import org.junit.jupiter.api.Assertions;
26  import org.junit.jupiter.api.BeforeAll;
27  import org.junit.jupiter.api.Test;
28  
29  class OgnlStaticTest {
30  
31    private static SqlSessionFactory sqlSessionFactory;
32  
33    @BeforeAll
34    static void setUp() throws Exception {
35      // create a SqlSessionFactory
36      try (Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/ognlstatic/mybatis-config.xml")) {
37        sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
38      }
39  
40      // populate in-memory database
41      BaseDataTest.runScript(sqlSessionFactory.getConfiguration().getEnvironment().getDataSource(),
42              "org/apache/ibatis/submitted/ognlstatic/CreateDB.sql");
43    }
44  
45    /**
46     * This is the log output.
47     * DEBUG [main] - ooo Using Connection [org.hsqldb.jdbc.JDBCConnection@5ae1a5c7]
48     * DEBUG [main] - ==>  Preparing: SELECT * FROM users WHERE name IN (?) AND id = ?
49     * DEBUG [main] - ==> Parameters: 1(Integer), 1(Integer)
50     * There are two parameter mappings but DefaulParameterHandler maps them both to input paremeter (integer)
51     */
52    @Test // see issue #448
53    void shouldGetAUserStatic() {
54      try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
55        Mapper mapper = sqlSession.getMapper(Mapper.class);
56        User user = mapper.getUserStatic(1);
57        Assertions.assertNotNull(user);
58        Assertions.assertEquals("User1", user.getName());
59      }
60    }
61  
62    @Test // see issue #61 (gh)
63    void shouldGetAUserWithIfNode() {
64      try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
65        Mapper mapper = sqlSession.getMapper(Mapper.class);
66        User user = mapper.getUserIfNode("User1");
67        Assertions.assertEquals("User1", user.getName());
68      }
69    }
70  
71  }