Package liquibase.statement.core

Examples of liquibase.statement.core.RawSqlStatement

184
185
186
187
188
189
190
        return enabled;
    }

    @Override
    public void enableForeignKeyChecks() throws DatabaseException {
        ExecutorService.getInstance().getExecutor(this).execute(new RawSqlStatement("SET FOREIGN_KEY_CHECKS=1"));
    }
View Full Code Here
198
199
200
201
202
203
204
205
206
207
208
    protected String getConnectionCatalogName() throws DatabaseException {
        if (getConnection() == null || getConnection() instanceof OfflineConnection) {
            return null;
        }
        try {
            return ExecutorService.getInstance().getExecutor(this).queryForObject(new RawSqlStatement("select current schema from sysibm.sysdummy1"), String.class);
        } catch (Exception e) {
            LogFactory.getLogger().info("Error getting default schema", e);
        }
        return null;
    }
View Full Code Here
302
303
304
305
306
307
308
309
310
311
312
    public Set<String> getUserDefinedTypes() {
        if (userDefinedTypes == null) {
            userDefinedTypes = new HashSet<String>();
            if (getConnection() != null && !(getConnection() instanceof OfflineConnection)) {
                try {
                    userDefinedTypes.addAll(ExecutorService.getInstance().getExecutor(this).queryForList(new RawSqlStatement("SELECT TYPE_NAME FROM USER_TYPES"), String.class));
                } catch (DatabaseException e) {
                    //ignore error
                }
            }
        }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
    public void dateDefaultValue() throws Exception {
        if (getDatabase() == null) {
            return;
        }

        ExecutorService.getInstance().getExecutor(getDatabase()).execute(new RawSqlStatement("CREATE TABLE ad (\n" +
                "ad_id int(10) unsigned NOT NULL AUTO_INCREMENT,\n" +
                "advertiser_id int(10) unsigned NOT NULL,\n" +
                "ad_type_id int(10) unsigned NOT NULL,\n" +
                "name varchar(155) NOT NULL DEFAULT '',\n" +
                "label varchar(155)NOT NULL DEFAULT '',\n" +
View Full Code Here
45
46
47
48
49
50
51
52
53
    }

    @Override
    public SqlStatement[] generateStatements(Database database) {
        return new SqlStatement[]{
                new RawSqlStatement("update "+database.escapeObjectName(tableName, Table.class)
                        +" set "+database.escapeObjectName(columnName, Column.class)+" = "+newValue)
        };
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
    }

    @Override
    public SqlStatement[] generateRollbackStatements(Database database) throws RollbackImpossibleException {
        return new SqlStatement[]{
                new RawSqlStatement("update "+database.correctObjectName(tableName, Table.class)
                        +" set "+database.escapeObjectName(columnName, Column.class)+" = null")
        };
    }
View Full Code Here
46
47
48
49
50
51
52
53
54
    }

    @Override
    public void checkDiffResult(DiffResult diffResult, TagDatabaseChange change) throws Exception {
        Database database = diffResult.getComparisonSnapshot().getDatabase();
        int rows = ExecutorService.getInstance().getExecutor(database).queryForInt(new RawSqlStatement("select count(*) from " + database.getDatabaseChangeLogTableName() + " where tag='" + change.getTag() + "'"));
        assertTrue(rows > 0);

    }
View Full Code Here
32
33
34
35
36
37
38
39
    }

    @Override
    public void checkDiffResult(DiffResult diffResult, InsertDataChange change) throws Exception {
        Database database = diffResult.getComparisonSnapshot().getDatabase();
        int rows = ExecutorService.getInstance().getExecutor(database).queryForInt(new RawSqlStatement("select count(*) from " + database.escapeTableName(change.getCatalogName(), change.getSchemaName(), change.getTableName())));
        assertTrue(rows > 0);
    }
View Full Code Here
TOP

Related Classes of liquibase.statement.core.RawSqlStatement

  • liquibase.change.AbstractSQLChange
  • liquibase.change.core.AddLookupTableChange
  • liquibase.change.core.MergeColumnChange
  • liquibase.change.core.supplier.InsertDataChangeSupplier
  • liquibase.change.core.supplier.RawSQLChangeSupplier
  • liquibase.change.core.supplier.TagDatabaseChangeSupplier
  • liquibase.change.custom.ExampleCustomSqlChange
  • liquibase.command.ExecuteSqlCommand
  • liquibase.database.core.DerbyDatabase
  • liquibase.database.core.InformixDatabase
    • 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.