Search in sources :

Example 16 with Post

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

the class BaseExecutorTest method shouldFetchOneOrphanedPostWithNoBlog.

@Test
void shouldFetchOneOrphanedPostWithNoBlog() throws Exception {
    Executor executor = createExecutor(new JdbcTransaction(ds, null, false));
    try {
        MappedStatement selectBlog = ExecutorTestHelper.prepareComplexSelectBlogMappedStatement(config);
        MappedStatement selectPost = ExecutorTestHelper.prepareSelectPostMappedStatement(config);
        config.addMappedStatement(selectBlog);
        config.addMappedStatement(selectPost);
        List<Post> posts = executor.query(selectPost, 5, RowBounds.DEFAULT, Executor.NO_RESULT_HANDLER);
        executor.flushStatements();
        executor.rollback(true);
        assertEquals(1, posts.size());
        Post post = posts.get(0);
        assertNull(post.getBlog());
    } finally {
        executor.rollback(true);
        executor.close(false);
    }
}
Also used : JdbcTransaction(org.apache.ibatis.transaction.jdbc.JdbcTransaction) Post(org.apache.ibatis.domain.blog.Post) MappedStatement(org.apache.ibatis.mapping.MappedStatement) BaseDataTest(org.apache.ibatis.BaseDataTest) Test(org.junit.jupiter.api.Test)

Example 17 with Post

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

the class BindingTest method shouldSelectListOfPostsLikeTwoParameters.

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

Example 18 with Post

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

the class BindingTest method shouldFindPostsInList.

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

Example 19 with Post

use of org.apache.ibatis.domain.blog.Post 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 20 with Post

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

the class BindingTest method shouldSelectListOfPostsLike.

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

Aggregations

Post (org.apache.ibatis.domain.blog.Post)21 BaseDataTest (org.apache.ibatis.BaseDataTest)18 Test (org.junit.jupiter.api.Test)17 DraftPost (org.apache.ibatis.domain.blog.DraftPost)15 SqlSession (org.apache.ibatis.session.SqlSession)13 Blog (org.apache.ibatis.domain.blog.Blog)9 Author (org.apache.ibatis.domain.blog.Author)6 MappedStatement (org.apache.ibatis.mapping.MappedStatement)6 Comment (org.apache.ibatis.domain.blog.Comment)5 Tag (org.apache.ibatis.domain.blog.Tag)5 RowBounds (org.apache.ibatis.session.RowBounds)4 ArrayList (java.util.ArrayList)3 Date (java.util.Date)3 StaticSqlSource (org.apache.ibatis.builder.StaticSqlSource)3 Section (org.apache.ibatis.domain.blog.Section)3 ParameterMap (org.apache.ibatis.mapping.ParameterMap)3 ResultFlag (org.apache.ibatis.mapping.ResultFlag)3 ResultMap (org.apache.ibatis.mapping.ResultMap)3 ResultMapping (org.apache.ibatis.mapping.ResultMapping)3 SqlSource (org.apache.ibatis.mapping.SqlSource)3