Examples with ScriptRunner org.apache.ibatis.jdbc.ScriptRunner used on opensource projects

Example 31 with ScriptRunner

use of org.apache.ibatis.jdbc.ScriptRunner in project mybatis-3 by mybatis.

the class CustomCollectionHandlingTest method initDb.

private static void initDb(Connection conn) throws IOException, SQLException {
    try {
        Reader scriptReader = Resources.getResourceAsReader("org/apache/ibatis/submitted/custom_collection_handling/CreateDB.sql");
        ScriptRunner runner = new ScriptRunner(conn);
        runner.setLogWriter(null);
        runner.setErrorLogWriter(new PrintWriter(System.err));
        runner.runScript(scriptReader);
        conn.commit();
        scriptReader.close();
    } finally {
        if (conn != null) {
            conn.close();
        }
    }
}

Example 32 with ScriptRunner

use of org.apache.ibatis.jdbc.ScriptRunner in project mybatis-3 by mybatis.

the class EncodingTest method setUp.

@BeforeClass
public static void setUp() throws Exception {
    Connection conn = null;
    // save charset
    Charset charset = Resources.getCharset();
    try {
        Class.forName("org.hsqldb.jdbcDriver");
        conn = DriverManager.getConnection("jdbc:hsqldb:mem:encoding", "sa", "");
        // make sure that the SQL file has been saved in UTF-8!
        Resources.setCharset(Charset.forName("utf-8"));
        Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/encoding/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/encoding/EncodingConfig.xml");
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        reader.close();
    } finally {
        // restore charset
        Resources.setCharset(charset);
        if (conn != null) {
            conn.close();
        }
    }
}

Example 33 with ScriptRunner

use of org.apache.ibatis.jdbc.ScriptRunner in project mybatis-3 by mybatis.

the class EnumTypeHandlerUsingAnnotationTest method initDatabase.

@BeforeClass
public static void initDatabase() throws Exception {
    Connection conn = null;
    try {
        Class.forName("org.hsqldb.jdbcDriver");
        conn = DriverManager.getConnection("jdbc:hsqldb:mem:enumtypehandler_on_annotation", "sa", "");
        Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/enumtypehandler_on_annotation/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/enumtypehandler_on_annotation/mybatis-config.xml");
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        sqlSessionFactory.getConfiguration().getMapperRegistry().addMapper(PersonMapper.class);
        reader.close();
    } finally {
        if (conn != null) {
            conn.close();
        }
    }
}

Example 34 with ScriptRunner

use of org.apache.ibatis.jdbc.ScriptRunner in project mybatis-3 by mybatis.

the class ExtendTest method setUp.

@BeforeClass
public static void setUp() throws Exception {
    Connection conn = null;
    try {
        Class.forName("org.hsqldb.jdbcDriver");
        conn = DriverManager.getConnection("jdbc:hsqldb:mem:extend", "sa", "");
        Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/extend/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/extend/ExtendConfig.xml");
        sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        reader.close();
    } finally {
        if (conn != null) {
            conn.close();
        }
    }
}

Example 35 with ScriptRunner

use of org.apache.ibatis.jdbc.ScriptRunner in project mybatis-3 by mybatis.

the class ExtendResultMapTest method setUp.

@BeforeClass
public static void setUp() throws Exception {
    // create a SqlSessionFactory
    Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/extendresultmap/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/extendresultmap/CreateDB.sql");
    ScriptRunner runner = new ScriptRunner(conn);
    runner.setLogWriter(null);
    runner.runScript(reader);
    reader.close();
    session.close();
}