package org.apache.ibatis.submitted.cglib_lazy_error;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.jdbc.ScriptRunner;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Assert;
import org.junit.BeforeClass;
import org.junit.Test;
import java.io.PrintWriter;
import java.io.Reader;
import java.sql.Connection;
import java.sql.DriverManager;
public class CglibNPETest {
private static SqlSessionFactory sqlSessionFactory;
@BeforeClass
public static void initDatabase() throws Exception {
Connection conn = null;
try {
Class.forName("org.hsqldb.jdbcDriver");
conn = DriverManager.getConnection("jdbc:hsqldb:mem:cglib_lazy_eager_no_error", "sa",
"");
Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/cglib_lazy_error/CreateDB.sql");
ScriptRunner runner = new ScriptRunner(conn);
runner.setLogWriter(null);
runner.setErrorLogWriter(null);
runner.runScript(reader);
conn.commit();
reader.close();
reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/cglib_lazy_error/ibatisConfig.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
reader.close();
} finally {
if (conn != null) {
conn.close();
}
}
}
@Test
public void testNoParent() {
SqlSession sqlSession = sqlSessionFactory.openSession();
PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
Person person = personMapper.selectById(1);
Assert.assertNotNull("Persons must not be null", person);
Person parent = person.getParent();
Assert.assertNull("Parent must be null", parent);
sqlSession.close();
}
@Test
public void testAncestorSelf() {
SqlSession sqlSession = sqlSessionFactory.openSession();
PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
Person person = personMapper.selectById(1);
Assert.assertNotNull("Persons must not be null", person);
Person ancestor = person.getAncestor();
Assert.assertEquals("Ancestor must be John Smith sr.", person, ancestor);
sqlSession.close();
}
@Test
public void testGrandParent() {
SqlSession sqlSession = sqlSessionFactory.openSession();
PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
Person expectedParent = personMapper.selectById(2);
Person expectedGrandParent = personMapper.selectById(1);
Person person = personMapper.selectById(3);
Assert.assertNotNull("Persons must not be null", person);
Assert.assertEquals("Parent must be John Smith", expectedParent, person.getParent());
Assert.assertEquals("Parent must be John Smith sr.", expectedGrandParent, person.getParent().getParent());
sqlSession.close();
}
@Test
public void testAncestor() {
SqlSession sqlSession = sqlSessionFactory.openSession();
PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
Person expectedAncestor = personMapper.selectById(1);
Person person = personMapper.selectById(3);
Assert.assertNotNull("Persons must not be null", person);
Assert.assertEquals("Ancestor must be John Smith sr.", expectedAncestor, person.getAncestor());
sqlSession.close();
}
@Test
public void testAncestorAfterQueryingParents() {
SqlSession sqlSession = sqlSessionFactory.openSession();
PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
Person expectedAncestor = personMapper.selectById(1);
Person person = personMapper.selectById(3);
// Load ancestor indirectly.
Assert.assertNotNull("Persons must not be null", person);
Assert.assertNotNull("Parent must not be null", person.getParent());
Assert.assertNotNull("Grandparent must not be null", person.getParent().getParent());
Assert.assertEquals("Ancestor must be John Smith sr.", expectedAncestor, person.getAncestor());
sqlSession.close();
}
@Test
public void testInsertBetweenTwoSelects() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
Person selected1 = personMapper.selectById(1);
Person selected2 = personMapper.selectById(2);
Person selected3 = personMapper.selectById(3);
selected1.setId(4L);
int rows = personMapper.insertPerson(selected1);
Assert.assertEquals(1, rows);
selected1 = personMapper.selectById(1);
selected2 = personMapper.selectById(2);
selected3 = personMapper.selectById(3);
Person selected4 = personMapper.selectById(4);
Assert.assertEquals(1, selected1.getId().longValue());
Assert.assertEquals(2, selected2.getId().longValue());
Assert.assertEquals(3, selected3.getId().longValue());
Assert.assertEquals(4, selected4.getId().longValue());
} finally {
sqlSession.close();
}
}
@Test
public void testSelectWithStringSQLInjection() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
PersonMapper personMapper = sqlSession.getMapper(PersonMapper.class);
Person selected1 = personMapper.selectByStringId("1");
Assert.assertEquals(1, selected1.getId().longValue());
} finally {
sqlSession.close();
}
}
}