Examples of ScriptRunner

Examples of org.apache.ibatis.jdbc.ScriptRunner

24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
      }
      List<Change> pending = getPendingChanges();
      printStream.println("WARNING: Running pending migrations out of order can create unexpected results.");
      for (Change change : pending) {
        printStream.println(horizontalLine("Applying: " + change.getFilename(), 80));
        ScriptRunner runner = getScriptRunner();
        try {
          runner.runScript(new MigrationReader(new FileReader(scriptFile(change.getFilename())), false, environmentProperties()));
        } finally {
          runner.closeConnection();
        }
        insertChangelog(change);
        printStream.println();
      }
    } catch (Exception e) {
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
      Collections.reverse(migrations);
      int steps = 0;
      for (Change change : migrations) {
        if (change.getId().equals(lastChange.getId())) {
          printStream.println(horizontalLine("Undoing: " + change.getFilename(), 80));
          ScriptRunner runner = getScriptRunner();
          try {
            runner.runScript(new MigrationReader(new FileReader(scriptFile(change.getFilename())), true, environmentProperties()));
          } finally {
            runner.closeConnection();
          }
          if (changelogExists()) {
            deleteChange(change);
          } else {
            printStream.println("Changelog doesn't exist. No further migrations will be undone (normal for the last migration).");
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

49
50
51
52
53
54
55
56
57
58
59
60
//            Reader reader = Resources.getResourceAsReader( "SqlMapConfig.xml");
//            sqlMapper = SqlMapClientBuilder.buildSqlMapClient( reader, properties);
//            reader.close();
            SqlSession session = sqlMapper.openSession();
            Connection connection = session.getConnection();
            ScriptRunner runner = new ScriptRunner( connection);
            runner.runScript( Resources.getResourceAsReader( "initialize-db.sql"));
            connection.close();
            session.close();
           
//            executeDDLFile(
//                    Thread.currentThread().getContextClassLoader().getResource( "ddl.txt"),
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

32
33
34
35
36
37
38
39
40
41
42
43
44
45
      // 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);
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
  }

  public static void runScript(DataSource ds, String resource) throws IOException, SQLException {
    Connection connection = ds.getConnection();
    try {
      ScriptRunner runner = new ScriptRunner(connection);
      runner.setAutoCommit(true);
      runner.setStopOnError(false);
      runner.setLogWriter(null);
      runner.setErrorLogWriter(null);
      runScript(runner, resource);
    } finally {
      connection.close();
    }
  }
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

42
43
44
45
46
47
48
49
50
51
52
53
54
55
            Class.forName("org.hsqldb.jdbcDriver");
            conn = DriverManager.getConnection("jdbc:hsqldb:mem:lazy_immutable", "sa", "");

            Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/lazy_immutable/CreateDB.sql");

            ScriptRunner runner = new ScriptRunner(conn);
            runner.setLogWriter(null);
            runner.setErrorLogWriter(new PrintWriter(System.err));
            runner.runScript(reader);
            conn.commit();
            reader.close();

            reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/lazy_immutable/ibatisConfig.xml");
            factory = new SqlSessionFactoryBuilder().build(reader);
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

49
50
51
52
53
54
55
56
57
58
59
60
61
    }
  }

  private static void runDBScript() throws SQLException, IOException {
    Connection conn = sqlSessionFactory.getConfiguration().getEnvironment().getDataSource().getConnection();
    ScriptRunner runner = new ScriptRunner(conn);
    runner.setLogWriter(null);
    runner.setErrorLogWriter(null);
    String resource = "org/apache/ibatis/submitted/complex_property/db/db.sql";
    Reader reader = Resources.getResourceAsReader(resource);
    runner.runScript(reader);
    conn.close();
  }
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

27
28
29
30
31
32
33
34
35
36
37
38
39
40
  @BeforeClass
  public static void setUp() throws Exception {
    Class.forName("org.hsqldb.jdbcDriver");
     Connection c = DriverManager.getConnection("jdbc:hsqldb:mem:annots", "sa", "");
     Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/substitution_in_annots/CreateDB.sql");
    ScriptRunner runner = new ScriptRunner(c);
    runner.setLogWriter(null);
    runner.setErrorLogWriter(null);
    runner.runScript(reader);
    c.commit();
    reader.close();

    Configuration configuration = new Configuration();
    Environment environment = new Environment("test", new JdbcTransactionFactory(), new UnpooledDataSource("org.hsqldb.jdbcDriver", "jdbc:hsqldb:mem:annots", null));
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
    SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);

    SqlSession session = factory.openSession();

    Connection conn = session.getConnection();
    ScriptRunner runner = new ScriptRunner(conn);
    runner.setLogWriter(null);
    runner.setErrorLogWriter(null);
    reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/initialized_collection_property/db/create.sql");
    runner.runScript(reader);
    session.close();

    AuthorDAO dao = new AuthorDAO(factory);
    List<Author> authors = dao.getAuthors();
    assertEquals(1, authors.size());
View Full Code Here

Examples of org.apache.ibatis.jdbc.ScriptRunner

30
31
32
33
34
35
36
37
38
39
40
41
42
43
      conn = DriverManager.getConnection("jdbc:hsqldb:mem:nested", "sa",
          "");

      Reader reader = Resources.getResourceAsReader("org/apache/ibatis/submitted/nested/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/nested/MapperConfig.xml");
      sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.