@BeforeClass
public static void setUp() throws Exception {
// create a SqlSessionFactory
Reader reader =
Resources.getResourceAsReader("org/apache/ibatis/submitted/foreach/mybatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
reader.close();
// populate in-memory database
SqlSession session = sqlSessionFactory.openSession();
Connection conn = session.getConnection();
reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/foreach/CreateDB.sql");
ScriptRunner runner = new ScriptRunner(conn);
runner.setLogWriter(null);
runner.runScript(reader);
reader.close();
session.close();
}
@Before
public void init() {
SqlSession session = MyBatisTestUtil.getSession();
Connection c = session.getConnection();
Statement s = null;
try {
s = c.createStatement();
s.execute("TRUNCATE TABLE entity");
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (s != null && !s.isClosed()) {
s.close();
}
if (c != null && c.isClosed()) {
c.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
if (session != null) {
session.close();
}
}
}
@BeforeClass
public static void setUp() throws Exception {
Reader reader =
Resources.getResourceAsReader(
"org/apache/ibatis/submitted/multipleresultsetswithassociation/mybatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
reader.close();
// populate in-memory database
// Could not get the table creation, procedure creation, and data population to work from the
// same script.
// Once it was in three scripts, all seemed well.
SqlSession session = sqlSessionFactory.openSession();
Connection conn = session.getConnection();
reader =
Resources.getResourceAsReader(
"org/apache/ibatis/submitted/multipleresultsetswithassociation/CreateDB1.sql");
runReaderScript(conn, session, reader);
reader.close();
reader =
Resources.getResourceAsReader(
"org/apache/ibatis/submitted/multipleresultsetswithassociation/CreateDB2.sql");
runReaderScript(conn, session, reader);
reader.close();
reader =
Resources.getResourceAsReader(
"org/apache/ibatis/submitted/multipleresultsetswithassociation/CreateDB3.sql");
runReaderScript(conn, session, reader);
reader.close();
session.close();
}
// main method for testing
public static void main(String... args) {
SqlSession session = CrdbSessionManager.INSTANCE.getCrdbSession();
try {
logger.info("The session is open? " + !session.getConnection().isClosed());
} catch (SQLException e) {
e.printStackTrace();
}
CrdbSessionManager.INSTANCE.closeSession();
}
@BeforeClass
public static void setup() throws Exception {
SqlSession session = IbatisConfig.getSession();
Connection conn = session.getConnection();
ScriptRunner runner = new ScriptRunner(conn);
runner.setLogWriter(null);
runner.setErrorLogWriter(null);
Reader reader =
Resources.getResourceAsReader(
"org/apache/ibatis/submitted/primitive_result_type/create.sql");
runner.runScript(reader);
}
public static SqlSession openSqlSession() throws SQLException, IOException {
try {
if (inputStream == null) {
inputStream = Resources.getResourceAsStream(resource);
}
if (sqlSessionFactory == null) {
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}
} catch (IOException e) {
throw e;
}
SqlSession session = sqlSessionFactory.openSession(ExecutorType.BATCH, false);
session.getConnection().setAutoCommit(false);
return session;
}
/** @throws java.lang.Exception */
@Before
public void setUpBefore() throws Exception {
mockedRequest = Mockito.mock(HttpServletRequest.class);
mockedResponse = Mockito.mock(HttpServletResponse.class);
URL testfile = NewModelHandlerTest.class.getResource("/data/newmodelhandler/test1_svg.xml");
File file = new File(testfile.toURI());
svg = FileUtils.readFileToString(file, "UTF-8");
testfile =
NewModelHandlerTest.class.getResource("/data/newmodelhandler/test1_content_json.txt");
file = new File(testfile.toURI());
data = FileUtils.readFileToString(file, "UTF-8");
// --
// DataDefaults.all();
Reader reader = Resources.getResourceAsReader("org/b3mn/poem/tests/myibitis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
reader.close();
SqlSession session = sqlSessionFactory.openSession();
Connection conn = session.getConnection();
reader = Resources.getResourceAsReader("org/b3mn/poem/tests/test_reset_mysql_db_schema.sql");
ScriptRunner runner = new ScriptRunner(conn);
runner.setErrorLogWriter(null);
runner.runScript(reader);
reader.close();
reader = Resources.getResourceAsReader("org/b3mn/poem/tests/test_data.sql");
runner = new ScriptRunner(conn);
runner.setErrorLogWriter(null);
runner.runScript(reader);
reader.close();
session.close();
title = "Job #1";
type = "http://b3mn.org/stencilset/reporting#";
summary = "";
newModelIdentity = null;
user = new User("public");
handler = new NewModelHandler();
assertNotNull(handler);
handler.init();
}
@Test(
groups = {"tidb"},
expectedExceptions = PersistenceException.class)
public void shouldFailBecauseThereIsAPropertyWithoutTypeHandler() throws Exception {
// create a SqlSessionFactory
Reader reader =
Resources.getResourceAsReader(
"org/apache/ibatis/submitted/unknownobject/mybatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
reader.close();
// populate in-memory database
SqlSession session = sqlSessionFactory.openSession();
Connection conn = session.getConnection();
reader =
Resources.getResourceAsReader("org/apache/ibatis/submitted/unknownobject/CreateDB.sql");
ScriptRunner runner = new ScriptRunner(conn);
runner.setLogWriter(null);
runner.runScript(reader);
reader.close();
session.close();
}
public Connection getConnection() {
return session.getConnection();
}
