Package liquibase.sql

Examples of liquibase.sql.UnparsedSql

103
104
105
106
107
108
109
    // add column type
    alterTable += TypeConverterFactory.getInstance().findTypeConverter(database)
            .getDataType(statement.getNewDataType(), false);

    return new Sql[] { new UnparsedSql(alterTable) };
  }
View Full Code Here
116
117
118
119
120
121
122
                      statement.getOldColumnName())
              + " TO "
              + database.escapeColumnName(statement.getSchemaName(), statement.getTableName(),
                      statement.getNewColumnName());
    }
    return new Sql[] { new UnparsedSql(sql) };
  }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
    @Override
    public Sql[] generateSql(SqlStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) {
        List<Sql> sql = new ArrayList<Sql>();
        for (String returnSql  : this.returnSql) {
            sql.add(new UnparsedSql(returnSql));
        }

        sql.addAll(Arrays.asList(sqlGeneratorChain.generateSql(statement, database)));

        return sql.toArray(new Sql[sql.size()]);
View Full Code Here
95
96
97
98
99
100
101
102
        sb.append(" CONSTRAINT ");
        sb.append(database.escapeConstraintName(statement.getConstraintName()));
      }

      return new Sql[]{
          new UnparsedSql(sb.toString(), getAffectedForeignKey(statement))
      };
    }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
        }
      }

        if (statement.isClustered() != null && statement.isClustered()) {
            return new Sql[]{
                    new UnparsedSql(buffer.toString(), getAffectedIndex(statement)),
                    new UnparsedSql("CLUSTER " + database.escapeTableName(statement.getTableCatalogName(), statement.getTableSchemaName(), statement.getTableName()) + " USING " + database.escapeObjectName(statement.getIndexName(), Index.class))
            };
        } else {
            return new Sql[]{new UnparsedSql(buffer.toString(), getAffectedIndex(statement))};
        }
    }
View Full Code Here
48
49
50
51
52
53
54
55
            sb.append("  WHERE       i1.CONSTRAINT_TYPE = 'PRIMARY KEY' ");
            sb.append(") PT ON PT.TABLE_NAME = PK.TABLE_NAME ");
            sb.append("WHERE      lower(FK.TABLE_NAME)='").append(statement.getBaseTableName().toLowerCase()).append("'");

        return new Sql[] {
                new UnparsedSql(sb.toString())
        };
    }
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()) + " REPLACE " + 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
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()) + " ADD CONSTRAINT " + ((MSSQLDatabase) database).generateDefaultConstraintName(statement.getTableName(), statement.getColumnName()) + " DEFAULT " + DataTypeFactory.getInstance().fromObject(defaultValue, database).objectToSql(defaultValue, database) + " FOR " + statement.getColumnName(),
                        getAffectedColumn(statement))
        };
    }
View Full Code Here
93
94
95
96
97
98
99
100
        } else {
            sql = "ALTER TABLE " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()) + " DROP PRIMARY KEY";
        }

        return new Sql[] {
                new UnparsedSql(sql, getAffectedPrimaryKey(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()) + " ALTER " + database.escapeColumnName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName(), statement.getColumnName()) + " SET DEFAULT " + DataTypeFactory.getInstance().fromObject(defaultValue, database).objectToSql(defaultValue, database),
                       getAffectedColumn(statement))
        };
    }
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.