Search in sources :

Example 21 with Blog

use of org.apache.ibatis.domain.blog.Blog in project mybatis-3 by mybatis.

the class BindingTest method shouldSelectBlogWithDefault30ParamNames.

@Test
void shouldSelectBlogWithDefault30ParamNames() {
    try (SqlSession session = sqlSessionFactory.openSession()) {
        BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
        Blog blog = mapper.selectBlogByDefault30ParamNames(1, "Jim Business");
        assertNotNull(blog);
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) Blog(org.apache.ibatis.domain.blog.Blog) BaseDataTest(org.apache.ibatis.BaseDataTest) Test(org.junit.jupiter.api.Test)

Example 22 with Blog

use of org.apache.ibatis.domain.blog.Blog in project mybatis-3 by mybatis.

the class BindingTest method shouldSelectBlogWithPostsUsingSubSelect.

@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());
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) Blog(org.apache.ibatis.domain.blog.Blog) BaseDataTest(org.apache.ibatis.BaseDataTest) Test(org.junit.jupiter.api.Test)

Example 23 with Blog

use of org.apache.ibatis.domain.blog.Blog in project mybatis-3 by mybatis.

the class BindingTest method shouldExecuteBoundSelectOneBlogStatementWithConstructorUsingXMLConfig.

@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");
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) DraftPost(org.apache.ibatis.domain.blog.DraftPost) Post(org.apache.ibatis.domain.blog.Post) Blog(org.apache.ibatis.domain.blog.Blog) BaseDataTest(org.apache.ibatis.BaseDataTest) Test(org.junit.jupiter.api.Test)

Example 24 with Blog

use of org.apache.ibatis.domain.blog.Blog in project mybatis-3 by mybatis.

the class BindingTest method executeWithResultHandlerAndRowBounds.

@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());
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) RowBounds(org.apache.ibatis.session.RowBounds) Blog(org.apache.ibatis.domain.blog.Blog) DefaultResultHandler(org.apache.ibatis.executor.result.DefaultResultHandler) BaseDataTest(org.apache.ibatis.BaseDataTest) Test(org.junit.jupiter.api.Test)

Example 25 with Blog

use of org.apache.ibatis.domain.blog.Blog in project mybatis-3 by mybatis.

the class BindingTest method shouldExecuteBoundSelectListOfBlogsStatementUsingProvider.

@Test
void shouldExecuteBoundSelectListOfBlogsStatementUsingProvider() {
    try (SqlSession session = sqlSessionFactory.openSession()) {
        BoundBlogMapper mapper = session.getMapper(BoundBlogMapper.class);
        List<Blog> blogs = mapper.selectBlogsUsingProvider();
        assertEquals(2, blogs.size());
    }
}
Also used : SqlSession(org.apache.ibatis.session.SqlSession) Blog(org.apache.ibatis.domain.blog.Blog) BaseDataTest(org.apache.ibatis.BaseDataTest) Test(org.junit.jupiter.api.Test)

Aggregations

Blog (org.apache.ibatis.domain.blog.Blog)30 BaseDataTest (org.apache.ibatis.BaseDataTest)26 Test (org.junit.jupiter.api.Test)26 SqlSession (org.apache.ibatis.session.SqlSession)21 Post (org.apache.ibatis.domain.blog.Post)9 DraftPost (org.apache.ibatis.domain.blog.DraftPost)7 Author (org.apache.ibatis.domain.blog.Author)5 MappedStatement (org.apache.ibatis.mapping.MappedStatement)5 ArrayList (java.util.ArrayList)4 HashMap (java.util.HashMap)4 Map (java.util.Map)4 StaticSqlSource (org.apache.ibatis.builder.StaticSqlSource)4 Comment (org.apache.ibatis.domain.blog.Comment)4 Tag (org.apache.ibatis.domain.blog.Tag)4 ParameterMap (org.apache.ibatis.mapping.ParameterMap)4 ResultFlag (org.apache.ibatis.mapping.ResultFlag)4 ResultMap (org.apache.ibatis.mapping.ResultMap)4 ResultMapping (org.apache.ibatis.mapping.ResultMapping)4 SqlSource (org.apache.ibatis.mapping.SqlSource)4 DynamicSqlSource (org.apache.ibatis.scripting.xmltags.DynamicSqlSource)4