Package liquibase.sql

Examples of liquibase.sql.UnparsedSql

28
29
30
31
32
33
34
35
36
37
38
    public Sql[] generateSql(
        AddAutoIncrementStatement statement,
        Database database,
        SqlGeneratorChain sqlGeneratorChain) {
        return new Sql[]{
            new UnparsedSql(
              "ALTER TABLE "
                + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName())
                + " ALTER COLUMN "
                + database.escapeColumnName(
                        statement.getCatalogName(),
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
        } else {
            sql = "ALTER TABLE " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()) + " ALTER COLUMN  " + database.escapeColumnName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName(), statement.getColumnName()) + (statement.isNullable() ? " DROP NOT NULL" : " SET NOT NULL");
        }

        List<Sql> returnList = new ArrayList<Sql>();
        returnList.add(new UnparsedSql(sql, getAffectedColumn(statement)));

        if (database instanceof DB2Database) {
            Sql[] a = SqlGeneratorFactory.getInstance().generateSql(new ReorganizeTableStatement(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()), database);
            if (a != null) {
                returnList.addAll(Arrays.asList(a));
View Full Code Here
32
33
34
35
36
37
38
39
             sql.append(" CONSTRAINT ");
             sql.append(database.escapeConstraintName(statement.getConstraintName()));
         }

        return new Sql[] {
                new UnparsedSql(sql.toString(), getAffectedPrimaryKey(statement))
        };
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
                sql += " USING INDEX TABLESPACE " + statement.getTablespace();
            }
        }

        return new Sql[] {
                new UnparsedSql(sql, getAffectedUniqueConstraint(statement))
        };

    }
View Full Code Here
24
25
26
27
28
29
30
31
32
    @Override
    public Sql[] generateSql(AddDefaultValueStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) {
        Object defaultValue = statement.getDefaultValue();
        return new Sql[]{
                new UnparsedSql("ALTER TABLE " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()) + " MODIFY " + database.escapeColumnName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName(), statement.getColumnName()) + " DEFAULT " + DataTypeFactory.getInstance().fromObject(defaultValue, database).objectToSql(defaultValue, database),
                        getAffectedColumn(statement))
        };
    }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
                alterTable +=  " DROP " + database.escapeColumnName(columns.get(i).getCatalogName(), columns.get(i).getSchemaName(), columns.get(i).getTableName(), columns.get(i).getColumnName());
                if (i < columns.size() - 1) {
                    alterTable += ",";
                }
            }
            result.add(new UnparsedSql(alterTable, getAffectedColumns(columns)));
        } else {
            for (DropColumnStatement column : columns) {
                result.add(generateSingleColumnSql(column, database)[0]);
            }
        }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
        return result.toArray(new Sql[result.size()]);
    }

    private Sql[] generateSingleColumnSql(DropColumnStatement statement, Database database) {
        if (database instanceof DB2Database) {
            return new Sql[] {new UnparsedSql("ALTER TABLE " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()) + " DROP COLUMN " + database.escapeColumnName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName(), statement.getColumnName()), getAffectedColumn(statement))};
        } else if (database instanceof SybaseDatabase || database instanceof SybaseASADatabase || database instanceof FirebirdDatabase || database instanceof InformixDatabase) {
            return new Sql[] {new UnparsedSql("ALTER TABLE " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()) + " DROP " + database.escapeColumnName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName(), statement.getColumnName()), getAffectedColumn(statement))};
        }
        return new Sql[] {new UnparsedSql("ALTER TABLE " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()) + " DROP COLUMN " + database.escapeColumnName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName(), statement.getColumnName()), getAffectedColumn(statement))};
    }
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
                alterTable += generateSingleColumnSQL(columns.get(i), database);
                if (i < columns.size() - 1) {
                    alterTable += ",";
                }
            }
            result.add(new UnparsedSql(alterTable, getAffectedColumns(columns)));
        } else {
            for (AddColumnStatement column : columns) {
                result.addAll(Arrays.asList(generateSingleColumn(column, database)));
            }
        }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
    protected Sql[] generateSingleColumn(AddColumnStatement statement, Database database) {
        String alterTable = generateSingleColumBaseSQL(statement, database);
        alterTable += generateSingleColumnSQL(statement, database);

        List<Sql> returnSql = new ArrayList<Sql>();
        returnSql.add(new UnparsedSql(alterTable, getAffectedColumn(statement)));

        addUniqueConstrantStatements(statement, database, returnSql);
        addForeignKeyStatements(statement, database, returnSql);

        return returnSql.toArray(new Sql[returnSql.size()]);
View Full Code Here
46
47
48
49
50
51
52
53
    sql.append(DataTypeFactory.getInstance().fromDescription(statement.getColumnDataType(), database));
    sql.append(" DEFAULT ");
    sql.append(DataTypeFactory.getInstance().fromObject(defaultValue, database)
        .objectToSql(defaultValue, database));
    sql.append(")");
    UnparsedSql unparsedSql = new UnparsedSql(sql.toString(), getAffectedColumn(statement));
    return new Sql[] { unparsedSql };
  }
View Full Code Here
TOP

Related Classes of liquibase.sql.UnparsedSql

  • liquibase.sqlgenerator.core.AddAutoIncrementGenerator
  • liquibase.sqlgenerator.core.AddAutoIncrementGeneratorDB2
  • liquibase.sqlgenerator.core.AddAutoIncrementGeneratorHsqlH2
  • liquibase.sqlgenerator.core.AddAutoIncrementGeneratorInformix
  • liquibase.sqlgenerator.core.AddAutoIncrementGeneratorMySQL
  • liquibase.sqlgenerator.core.AddColumnGenerator
  • liquibase.sqlgenerator.core.AddDefaultValueGenerator
  • liquibase.sqlgenerator.core.AddDefaultValueGeneratorDerby
  • liquibase.sqlgenerator.core.AddDefaultValueGeneratorInformix
  • liquibase.sqlgenerator.core.AddDefaultValueGeneratorMSSQL
    • 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.