/*
    *    Copyright 2009-2021 the original author or authors.
    *
    *    Licensed under the Apache License, Version 2.0 (the "License");
    *    you may not use this file except in compliance with the License.
    *    You may obtain a copy of the License at
    *
    *       http://www.apache.org/licenses/LICENSE-2.0
    *
   *    Unless required by applicable law or agreed to in writing, software
   *    distributed under the License is distributed on an "AS IS" BASIS,
   *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   *    See the License for the specific language governing permissions and
   *    limitations under the License.
   */
  package org.apache.ibatis.binding;
  
  import static com.googlecode.catchexception.apis.BDDCatchException.*;
  import static org.assertj.core.api.BDDAssertions.then;
  import static org.junit.jupiter.api.Assertions.*;
  
  import java.io.IOException;
  import java.lang.reflect.Method;
  import java.util.ArrayList;
  import java.util.Collection;
  import java.util.Collections;
  import java.util.HashMap;
  import java.util.Iterator;
  import java.util.List;
  import java.util.Map;
  
  import javassist.util.proxy.Proxy;
  
  import javax.sql.DataSource;
  
  import net.sf.cglib.proxy.Factory;
  
  import org.apache.ibatis.BaseDataTest;
  import org.apache.ibatis.binding.MapperProxy.MapperMethodInvoker;
  import org.apache.ibatis.cursor.Cursor;
  import org.apache.ibatis.domain.blog.Author;
  import org.apache.ibatis.domain.blog.Blog;
  import org.apache.ibatis.domain.blog.DraftPost;
  import org.apache.ibatis.domain.blog.Post;
  import org.apache.ibatis.domain.blog.Section;
  import org.apache.ibatis.exceptions.PersistenceException;
  import org.apache.ibatis.executor.result.DefaultResultHandler;
  import org.apache.ibatis.mapping.Environment;
  import org.apache.ibatis.session.Configuration;
  import org.apache.ibatis.session.RowBounds;
  import org.apache.ibatis.session.SqlSession;
  import org.apache.ibatis.session.SqlSessionFactory;
  import org.apache.ibatis.session.SqlSessionFactoryBuilder;
  import org.apache.ibatis.transaction.TransactionFactory;
  import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;
  import org.junit.jupiter.api.Assertions;
  import org.junit.jupiter.api.BeforeAll;
  import org.junit.jupiter.api.Disabled;
  import org.junit.jupiter.api.Test;
  
  class BindingTest {
    private static SqlSessionFactory sqlSessionFactory;
  
    @BeforeAll
    static void setup() throws Exception {
      DataSource dataSource = BaseDataTest.createBlogDataSource();
      BaseDataTest.runScript(dataSource, BaseDataTest.BLOG_DDL);
      BaseDataTest.runScript(dataSource, BaseDataTest.BLOG_DATA);
      TransactionFactory transactionFactory = new JdbcTransactionFactory();
      Environment environment = new Environment("Production", transactionFactory, dataSource);
      Configuration configuration = new Configuration(environment);
      configuration.setLazyLoadingEnabled(true);
      configuration.setUseActualParamName(false); // to test legacy style reference (#{0} #{1})
      configuration.getTypeAliasRegistry().registerAlias(Blog.class);
      configuration.getTypeAliasRegistry().registerAlias(Post.class);
      configuration.getTypeAliasRegistry().registerAlias(Author.class);
      configuration.addMapper(BoundBlogMapper.class);
      configuration.addMapper(BoundAuthorMapper.class);
      sqlSessionFactory = new SqlSessionFactoryBuilder().build(configuration);
    }
  
    @Test
    void shouldSelectBlogWithPostsUsingSubSelect() {
      try (SqlSession session = sqlSessionFactory.openSession()) {
        BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
        Blog b = mapper.selectBlogWithPostsUsingSubSelect(1);
        assertEquals(1, b.getId());
        assertNotNull(b.getAuthor());
        assertEquals(101, b.getAuthor().getId());
        assertEquals("jim", b.getAuthor().getUsername());
        assertEquals("********", b.getAuthor().getPassword());
        assertEquals(2, b.getPosts().size());
      }
    }
  
    @Test
    void shouldFindPostsInList() {
      try (SqlSession session = sqlSessionFactory.openSession()) {
        BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       List<Post> posts = mapper.findPostsInList(new ArrayList<Integer>() {{
         add(1);
         add(3);
         add(5);
       }});
       assertEquals(3, posts.size());
       session.rollback();
     }
   }
 
   @Test
   void shouldFindPostsInArray() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Integer[] params = new Integer[]{1, 3, 5};
       List<Post> posts = mapper.findPostsInArray(params);
       assertEquals(3, posts.size());
       session.rollback();
     }
   }
 
   @Test
   void shouldFindThreeSpecificPosts() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       List<Post> posts = mapper.findThreeSpecificPosts(1, new RowBounds(1, 1), 3, 5);
       assertEquals(1, posts.size());
       assertEquals(3, posts.get(0).getId());
       session.rollback();
     }
   }
 
   @Test
   void shouldInsertAuthorWithSelectKey() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
       int rows = mapper.insertAuthor(author);
       assertEquals(1, rows);
       session.rollback();
     }
   }
 
   @Test
   void verifyErrorMessageFromSelectKey() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       try {
         BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
         Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
         when(() -> mapper.insertAuthorInvalidSelectKey(author));
         then(caughtException()).isInstanceOf(PersistenceException.class).hasMessageContaining(
             "### The error may exist in org/apache/ibatis/binding/BoundAuthorMapper.xml" + System.lineSeparator() +
                 "### The error may involve org.apache.ibatis.binding.BoundAuthorMapper.insertAuthorInvalidSelectKey!selectKey" + System.lineSeparator() +
                 "### The error occurred while executing a query");
       } finally {
         session.rollback();
       }
     }
   }
 
   @Test
   void verifyErrorMessageFromInsertAfterSelectKey() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       try {
         BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
         Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
         when(() -> mapper.insertAuthorInvalidInsert(author));
         then(caughtException()).isInstanceOf(PersistenceException.class).hasMessageContaining(
             "### The error may exist in org/apache/ibatis/binding/BoundAuthorMapper.xml" + System.lineSeparator() +
                 "### The error may involve org.apache.ibatis.binding.BoundAuthorMapper.insertAuthorInvalidInsert" + System.lineSeparator() +
                 "### The error occurred while executing an update");
       } finally {
         session.rollback();
       }
     }
   }
 
   @Test
   void shouldInsertAuthorWithSelectKeyAndDynamicParams() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
       int rows = mapper.insertAuthorDynamic(author);
       assertEquals(1, rows);
       assertNotEquals(-1, author.getId()); // id must be autogenerated
       Author author2 = mapper.selectAuthor(author.getId());
       assertNotNull(author2);
       assertEquals(author.getEmail(), author2.getEmail());
       session.rollback();
     }
   }
 
   @Test
   void shouldSelectRandom() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Integer x = mapper.selectRandom();
       assertNotNull(x);
     }
   }
 
   @Test
   void shouldExecuteBoundSelectListOfBlogsStatement() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Blog> blogs = mapper.selectBlogs();
       assertEquals(2, blogs.size());
     }
   }
 
   @Test
   void shouldExecuteBoundSelectMapOfBlogsById() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Map<Integer,Blog> blogs = mapper.selectBlogsAsMapById();
       assertEquals(2, blogs.size());
       for(Map.Entry<Integer,Blog> blogEntry : blogs.entrySet()) {
         assertEquals(blogEntry.getKey(), (Integer) blogEntry.getValue().getId());
       }
     }
   }
 
   @Test
   void shouldExecuteMultipleBoundSelectOfBlogsByIdInWithProvidedResultHandlerBetweenSessions() {
     final DefaultResultHandler handler = new DefaultResultHandler();
     try (SqlSession session = sqlSessionFactory.openSession()) {
       session.select("selectBlogsAsMapById", handler);
     }
 
     final DefaultResultHandler moreHandler = new DefaultResultHandler();
     try (SqlSession session = sqlSessionFactory.openSession()) {
       session.select("selectBlogsAsMapById", moreHandler);
     }
     assertEquals(2, handler.getResultList().size());
     assertEquals(2, moreHandler.getResultList().size());
   }
 
   @Test
   void shouldExecuteMultipleBoundSelectOfBlogsByIdInWithProvidedResultHandlerInSameSession() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       final DefaultResultHandler handler = new DefaultResultHandler();
       session.select("selectBlogsAsMapById", handler);
 
       final DefaultResultHandler moreHandler = new DefaultResultHandler();
       session.select("selectBlogsAsMapById", moreHandler);
 
       assertEquals(2, handler.getResultList().size());
       assertEquals(2, moreHandler.getResultList().size());
     }
   }
 
   @Test
   void shouldExecuteMultipleBoundSelectMapOfBlogsByIdInSameSessionWithoutClearingLocalCache() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Map<Integer,Blog> blogs = mapper.selectBlogsAsMapById();
       Map<Integer,Blog> moreBlogs = mapper.selectBlogsAsMapById();
       assertEquals(2, blogs.size());
       assertEquals(2, moreBlogs.size());
       for(Map.Entry<Integer,Blog> blogEntry : blogs.entrySet()) {
         assertEquals(blogEntry.getKey(), (Integer) blogEntry.getValue().getId());
       }
       for(Map.Entry<Integer,Blog> blogEntry : moreBlogs.entrySet()) {
         assertEquals(blogEntry.getKey(), (Integer) blogEntry.getValue().getId());
       }
     }
   }
 
   @Test
   void shouldExecuteMultipleBoundSelectMapOfBlogsByIdBetweenTwoSessionsWithGlobalCacheEnabled() {
     Map<Integer,Blog> blogs;
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       blogs = mapper.selectBlogsAsMapById();
     }
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Map<Integer,Blog> moreBlogs = mapper.selectBlogsAsMapById();
       assertEquals(2, blogs.size());
       assertEquals(2, moreBlogs.size());
       for(Map.Entry<Integer,Blog> blogEntry : blogs.entrySet()) {
         assertEquals(blogEntry.getKey(), (Integer) blogEntry.getValue().getId());
       }
       for(Map.Entry<Integer,Blog> blogEntry : moreBlogs.entrySet()) {
         assertEquals(blogEntry.getKey(), (Integer) blogEntry.getValue().getId());
       }
     }
   }
 
   @Test
   void shouldSelectListOfBlogsUsingXMLConfig() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Blog> blogs = mapper.selectBlogsFromXML();
       assertEquals(2, blogs.size());
     }
   }
 
   @Test
   void shouldExecuteBoundSelectListOfBlogsStatementUsingProvider() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Blog> blogs = mapper.selectBlogsUsingProvider();
       assertEquals(2, blogs.size());
     }
   }
 
   @Test
   void shouldExecuteBoundSelectListOfBlogsAsMaps() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Map<String,Object>> blogs = mapper.selectBlogsAsMaps();
       assertEquals(2, blogs.size());
     }
   }
 
   @Test
   void shouldSelectListOfPostsLike() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Post> posts = mapper.selectPostsLike(new RowBounds(1,1),"%a%");
       assertEquals(1, posts.size());
     }
   }
 
   @Test
   void shouldSelectListOfPostsLikeTwoParameters() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Post> posts = mapper.selectPostsLikeSubjectAndBody(new RowBounds(1,1),"%a%","%a%");
       assertEquals(1, posts.size());
     }
   }
 
   @Test
   void shouldExecuteBoundSelectOneBlogStatement() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlog(1);
       assertEquals(1, blog.getId());
       assertEquals("Jim Business", blog.getTitle());
     }
   }
 
   @Test
   void shouldExecuteBoundSelectOneBlogStatementWithConstructor() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlogUsingConstructor(1);
       assertEquals(1, blog.getId());
       assertEquals("Jim Business", blog.getTitle());
       assertNotNull(blog.getAuthor(), "author should not be null");
       List<Post> posts = blog.getPosts();
       assertTrue(posts != null && !posts.isEmpty(), "posts should not be empty");
     }
   }
 
   @Test
   void shouldExecuteBoundSelectBlogUsingConstructorWithResultMap() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlogUsingConstructorWithResultMap(1);
       assertEquals(1, blog.getId());
       assertEquals("Jim Business", blog.getTitle());
       assertNotNull(blog.getAuthor(), "author should not be null");
       List<Post> posts = blog.getPosts();
       assertTrue(posts != null && !posts.isEmpty(), "posts should not be empty");
     }
   }
 
   @Test
   void shouldExecuteBoundSelectBlogUsingConstructorWithResultMapAndProperties() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlogUsingConstructorWithResultMapAndProperties(1);
       assertEquals(1, blog.getId());
       assertEquals("Jim Business", blog.getTitle());
       assertNotNull(blog.getAuthor(), "author should not be null");
       Author author = blog.getAuthor();
       assertEquals(101, author.getId());
       assertEquals("jim@ibatis.apache.org", author.getEmail());
       assertEquals("jim", author.getUsername());
       assertEquals(Section.NEWS, author.getFavouriteSection());
       List<Post> posts = blog.getPosts();
       assertNotNull(posts, "posts should not be empty");
       assertEquals(2, posts.size());
     }
   }
 
   @Disabled
   @Test // issue #480 and #101
   void shouldExecuteBoundSelectBlogUsingConstructorWithResultMapCollection() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlogUsingConstructorWithResultMapCollection(1);
       assertEquals(1, blog.getId());
       assertEquals("Jim Business", blog.getTitle());
       assertNotNull(blog.getAuthor(), "author should not be null");
       List<Post> posts = blog.getPosts();
       assertTrue(posts != null && !posts.isEmpty(), "posts should not be empty");
     }
   }
 
   @Test
   void shouldExecuteBoundSelectOneBlogStatementWithConstructorUsingXMLConfig() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlogByIdUsingConstructor(1);
       assertEquals(1, blog.getId());
       assertEquals("Jim Business", blog.getTitle());
       assertNotNull(blog.getAuthor(), "author should not be null");
       List<Post> posts = blog.getPosts();
       assertTrue(posts != null && !posts.isEmpty(), "posts should not be empty");
     }
   }
 
   @Test
   void shouldSelectOneBlogAsMap() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Map<String,Object> blog = mapper.selectBlogAsMap(new HashMap<String, Object>() {
         {
           put("id", 1);
         }
       });
       assertEquals(1, blog.get("ID"));
       assertEquals("Jim Business", blog.get("TITLE"));
     }
   }
 
   @Test
   void shouldSelectOneAuthor() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = mapper.selectAuthor(101);
       assertEquals(101, author.getId());
       assertEquals("jim", author.getUsername());
       assertEquals("********", author.getPassword());
       assertEquals("jim@ibatis.apache.org", author.getEmail());
       assertEquals("", author.getBio());
     }
   }
 
   @Test
   void shouldSelectOneAuthorFromCache() {
     Author author1 = selectOneAuthor();
     Author author2 = selectOneAuthor();
     assertSame(author1, author2, "Same (cached) instance should be returned unless rollback is called.");
   }
 
   private Author selectOneAuthor() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       return mapper.selectAuthor(101);
     }
   }
 
   @Test
   void shouldSelectOneAuthorByConstructor() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = mapper.selectAuthorConstructor(101);
       assertEquals(101, author.getId());
       assertEquals("jim", author.getUsername());
       assertEquals("********", author.getPassword());
       assertEquals("jim@ibatis.apache.org", author.getEmail());
       assertEquals("", author.getBio());
     }
   }
 
   @Test
   void shouldSelectDraftTypedPosts() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Post> posts = mapper.selectPosts();
       assertEquals(5, posts.size());
       assertTrue(posts.get(0) instanceof DraftPost);
       assertFalse(posts.get(1) instanceof DraftPost);
       assertTrue(posts.get(2) instanceof DraftPost);
       assertFalse(posts.get(3) instanceof DraftPost);
       assertFalse(posts.get(4) instanceof DraftPost);
     }
   }
 
   @Test
   void shouldSelectDraftTypedPostsWithResultMap() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Post> posts = mapper.selectPostsWithResultMap();
       assertEquals(5, posts.size());
       assertTrue(posts.get(0) instanceof DraftPost);
       assertFalse(posts.get(1) instanceof DraftPost);
       assertTrue(posts.get(2) instanceof DraftPost);
       assertFalse(posts.get(3) instanceof DraftPost);
       assertFalse(posts.get(4) instanceof DraftPost);
     }
   }
 
   @Test
   void shouldReturnANotNullToString() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       assertNotNull(mapper.toString());
     }
   }
 
   @Test
   void shouldReturnANotNullHashCode() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       assertNotNull(mapper.hashCode());
     }
   }
 
   @Test
   void shouldCompareTwoMappers() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       BoundBlogMapper mapper2 = session.getMapper(BoundBlogMapper.class);
       assertNotEquals(mapper, mapper2);
     }
   }
 
   @Test
   void shouldFailWhenSelectingOneBlogWithNonExistentParam() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       assertThrows(Exception.class, () -> mapper.selectBlogByNonExistentParam(1));
     }
   }
 
   @Test
   void shouldFailWhenSelectingOneBlogWithNullParam() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       assertThrows(Exception.class, () -> mapper.selectBlogByNullParam(null));
     }
   }
 
   @Test // Decided that maps are dynamic so no existent params do not fail
   void shouldFailWhenSelectingOneBlogWithNonExistentNestedParam() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       mapper.selectBlogByNonExistentNestedParam(1, Collections.<String, Object>emptyMap());
     }
   }
 
   @Test
   void shouldSelectBlogWithDefault30ParamNames() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlogByDefault30ParamNames(1, "Jim Business");
       assertNotNull(blog);
     }
   }
 
   @Test
   void shouldSelectBlogWithDefault31ParamNames() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlogByDefault31ParamNames(1, "Jim Business");
       assertNotNull(blog);
     }
   }
 
   @Test
   void shouldSelectBlogWithAParamNamedValue() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Blog blog = mapper.selectBlogWithAParamNamedValue("id", 1, "Jim Business");
       assertNotNull(blog);
     }
   }
 
   @Test
   void shouldCacheMapperMethod() throws Exception {
     try (SqlSession session = sqlSessionFactory.openSession()) {
 
       // Create another mapper instance with a method cache we can test against:
       final MapperProxyFactory<BoundBlogMapper> mapperProxyFactory = new MapperProxyFactory<BoundBlogMapper>(BoundBlogMapper.class);
       assertEquals(BoundBlogMapper.class, mapperProxyFactory.getMapperInterface());
       final BoundBlogMapper mapper = mapperProxyFactory.newInstance(session);
       assertNotSame(mapper, mapperProxyFactory.newInstance(session));
       assertTrue(mapperProxyFactory.getMethodCache().isEmpty());
 
       // Mapper methods we will call later:
       final Method selectBlog = BoundBlogMapper.class.getMethod("selectBlog", Integer.TYPE);
       final Method selectBlogByIdUsingConstructor = BoundBlogMapper.class.getMethod("selectBlogByIdUsingConstructor", Integer.TYPE);
 
       // Call mapper method and verify it is cached:
       mapper.selectBlog(1);
       assertEquals(1, mapperProxyFactory.getMethodCache().size());
       assertTrue(mapperProxyFactory.getMethodCache().containsKey(selectBlog));
       final MapperMethodInvoker cachedSelectBlog = mapperProxyFactory.getMethodCache().get(selectBlog);
 
       // Call mapper method again and verify the cache is unchanged:
       session.clearCache();
       mapper.selectBlog(1);
       assertEquals(1, mapperProxyFactory.getMethodCache().size());
       assertSame(cachedSelectBlog, mapperProxyFactory.getMethodCache().get(selectBlog));
 
       // Call another mapper method and verify that it shows up in the cache as well:
       session.clearCache();
       mapper.selectBlogByIdUsingConstructor(1);
       assertEquals(2, mapperProxyFactory.getMethodCache().size());
       assertSame(cachedSelectBlog, mapperProxyFactory.getMethodCache().get(selectBlog));
       assertTrue(mapperProxyFactory.getMethodCache().containsKey(selectBlogByIdUsingConstructor));
     }
   }
 
   @Test
   void shouldGetBlogsWithAuthorsAndPosts() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Blog> blogs = mapper.selectBlogsWithAutorAndPosts();
       assertEquals(2, blogs.size());
       assertTrue(blogs.get(0) instanceof Proxy);
       assertEquals(101, blogs.get(0).getAuthor().getId());
       assertEquals(1, blogs.get(0).getPosts().size());
       assertEquals(1, blogs.get(0).getPosts().get(0).getId());
       assertTrue(blogs.get(1) instanceof Proxy);
       assertEquals(102, blogs.get(1).getAuthor().getId());
       assertEquals(1, blogs.get(1).getPosts().size());
       assertEquals(2, blogs.get(1).getPosts().get(0).getId());
     }
   }
 
   @Test
   void shouldGetBlogsWithAuthorsAndPostsEagerly() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       List<Blog> blogs = mapper.selectBlogsWithAutorAndPostsEagerly();
       assertEquals(2, blogs.size());
       assertFalse(blogs.get(0) instanceof Factory);
       assertEquals(101, blogs.get(0).getAuthor().getId());
       assertEquals(1, blogs.get(0).getPosts().size());
       assertEquals(1, blogs.get(0).getPosts().get(0).getId());
       assertFalse(blogs.get(1) instanceof Factory);
       assertEquals(102, blogs.get(1).getAuthor().getId());
       assertEquals(1, blogs.get(1).getPosts().size());
       assertEquals(2, blogs.get(1).getPosts().get(0).getId());
     }
   }
 
   @Test
   void executeWithResultHandlerAndRowBounds() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       final DefaultResultHandler handler = new DefaultResultHandler();
       mapper.collectRangeBlogs(handler, new RowBounds(1, 1));
 
       assertEquals(1, handler.getResultList().size());
       Blog blog = (Blog) handler.getResultList().get(0);
       assertEquals(2, blog.getId());
     }
   }
 
   @Test
   void executeWithMapKeyAndRowBounds() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       Map<Integer, Blog> blogs = mapper.selectRangeBlogsAsMapById(new RowBounds(1, 1));
 
       assertEquals(1, blogs.size());
       Blog blog = blogs.get(2);
       assertEquals(2, blog.getId());
     }
   }
 
   @Test
   void executeWithCursorAndRowBounds() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
       try (Cursor<Blog> blogs = mapper.openRangeBlogs(new RowBounds(1, 1)) ) {
         Iterator<Blog> blogIterator = blogs.iterator();
         Blog blog = blogIterator.next();
         assertEquals(2, blog.getId());
         assertFalse(blogIterator.hasNext());
       }
     } catch (IOException e) {
       Assertions.fail(e.getMessage());
     }
   }
 
   @Test
   void registeredMappers() {
     Collection<Class<?>> mapperClasses = sqlSessionFactory.getConfiguration().getMapperRegistry().getMappers();
     assertEquals(2, mapperClasses.size());
     assertTrue(mapperClasses.contains(BoundBlogMapper.class));
     assertTrue(mapperClasses.contains(BoundAuthorMapper.class));
   }
 
   @Test
   void shouldMapPropertiesUsingRepeatableAnnotation() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
       mapper.insertAuthor(author);
       Author author2 = mapper.selectAuthorMapToPropertiesUsingRepeatable(author.getId());
       assertNotNull(author2);
       assertEquals(author.getId(), author2.getId());
       assertEquals(author.getUsername(), author2.getUsername());
       assertEquals(author.getPassword(), author2.getPassword());
       assertEquals(author.getBio(), author2.getBio());
       assertEquals(author.getEmail(), author2.getEmail());
       session.rollback();
     }
   }
 
   @Test
   void shouldMapConstructorUsingRepeatableAnnotation() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
       mapper.insertAuthor(author);
       Author author2 = mapper.selectAuthorMapToConstructorUsingRepeatable(author.getId());
       assertNotNull(author2);
       assertEquals(author.getId(), author2.getId());
       assertEquals(author.getUsername(), author2.getUsername());
       assertEquals(author.getPassword(), author2.getPassword());
       assertEquals(author.getBio(), author2.getBio());
       assertEquals(author.getEmail(), author2.getEmail());
       assertEquals(author.getFavouriteSection(), author2.getFavouriteSection());
       session.rollback();
     }
   }
 
   @Test
   void shouldMapUsingSingleRepeatableAnnotation() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
       mapper.insertAuthor(author);
       Author author2 = mapper.selectAuthorUsingSingleRepeatable(author.getId());
       assertNotNull(author2);
       assertEquals(author.getId(), author2.getId());
       assertEquals(author.getUsername(), author2.getUsername());
       assertNull(author2.getPassword());
       assertNull(author2.getBio());
       assertNull(author2.getEmail());
       assertNull(author2.getFavouriteSection());
       session.rollback();
     }
   }
 
   @Test
   void shouldMapWhenSpecifyBothArgAndConstructorArgs() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
       mapper.insertAuthor(author);
       Author author2 = mapper.selectAuthorUsingBothArgAndConstructorArgs(author.getId());
       assertNotNull(author2);
       assertEquals(author.getId(), author2.getId());
       assertEquals(author.getUsername(), author2.getUsername());
       assertEquals(author.getPassword(), author2.getPassword());
       assertEquals(author.getBio(), author2.getBio());
       assertEquals(author.getEmail(), author2.getEmail());
       assertEquals(author.getFavouriteSection(), author2.getFavouriteSection());
       session.rollback();
     }
   }
 
   @Test
   void shouldMapWhenSpecifyBothResultAndResults() {
     try (SqlSession session = sqlSessionFactory.openSession()) {
       BoundAuthorMapper mapper = session.getMapper(BoundAuthorMapper.class);
       Author author = new Author(-1, "cbegin", "******", "cbegin@nowhere.com", "N/A", Section.NEWS);
       mapper.insertAuthor(author);
       Author author2 = mapper.selectAuthorUsingBothResultAndResults(author.getId());
       assertNotNull(author2);
       assertEquals(author.getId(), author2.getId());
       assertEquals(author.getUsername(), author2.getUsername());
       assertNull(author2.getPassword());
       assertNull(author2.getBio());
       assertNull(author2.getEmail());
       assertNull(author2.getFavouriteSection());
       session.rollback();
     }
   }
 
 }