Package org.flywaydb.core.internal.dbsupport

Examples of org.flywaydb.core.internal.dbsupport.DbSupport

21
22
23
24
25
26
27
28
29
30
        Properties properties = new Properties();
        properties.load(RepeatableFlyway.class.getResourceAsStream("mysql.properties"));
        flyway.configure(properties);

        RepeatableFlyway.configure(flyway, properties);
        DbSupport dbSupport = DbSupportFactory.createDbSupport(flyway.getDataSource().getConnection(), false);
        dbSupport.getCurrentSchema().drop();
        dbSupport.getCurrentSchema().create();
        flyway.init();
    }
View Full Code Here
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
    {
        try
        {
            // Create a Flyway DbSupport object (based on our connection)
            // This is how Flyway determines the database *type* (e.g. Postgres vs Oracle)
            DbSupport dbSupport = DbSupportFactory.createDbSupport(connection, false);

            // Load our SQL string & execute via Flyway's SQL parser
            SqlScript script = new SqlScript(sqlToExecute, dbSupport);
            script.execute(dbSupport.getJdbcTemplate());
        }
        catch(FlywayException fe)
        {
            // If any FlywayException (Runtime) is thrown, change it to a SQLException
            throw new SQLException("Flyway executeSql() error occurred", fe);
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
                        properties.getProperty("before.user"), properties.getProperty("before.password"), "select * from dual");
                int filesExecuted = runner.execute();
                LOG.info(String.format("executed %d files%n", filesExecuted));
            }

            DbSupport dbSupport = DbSupportFactory.createDbSupport(connection, false);
            if (!dbSupport.getCurrentSchema().getTable(flyway.getTable()).exists()) {
                return;
            }

            String sql = "DELETE FROM " + flyway.getTable()
                + " WHERE " + dbSupport.quote("type") + "='CUSTOM'";
            connection.prepareCall(sql).execute();
        } catch (SQLException e) {
            LOG.error(e.getMessage(), e);
        } catch (IOException e) {
            LOG.error(e.getMessage(), e);
View Full Code Here
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
    }

    @Override
    public void beforeInfo(Connection connection) {
        try {
            DbSupport dbSupport = DbSupportFactory.createDbSupport(connection, false);
            if (dbSupport.getCurrentSchema().getTable(tmpFlywayTable).exists()) {
                dbSupport.getJdbcTemplate().executeStatement("DROP TABLE " + tmpFlywayTable);
            }
            String sql = "CREATE TABLE " + tmpFlywayTable + " AS SELECT * FROM " + flyway.getTable() +
                    " WHERE " + dbSupport.quote("type") + "='CUSTOM'";
            connection.prepareCall(sql).execute();

            sql = "DELETE FROM " + flyway.getTable()
                    + " WHERE " + dbSupport.quote("type") + "='CUSTOM'";
            connection.prepareCall(sql).execute();
        } catch (SQLException e) {
            LOG.error(e.getMessage(), e);
        }
    }
View Full Code Here
TOP

Related Classes of org.flywaydb.core.internal.dbsupport.DbSupport

  • ch.inftec.flyway.core.AbstractRepeatableFlywayTest
  • ch.inftec.flyway.core.RepeatableCallback
  • org.dspace.storage.rdbms.DatabaseUtils
    • Copyright © 2018 www.massapicom. 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.