Examples of UnparsedSql

Examples of liquibase.sql.UnparsedSql

59
60
61
62
63
64
65
66
            + DataTypeFactory.getInstance().fromDescription(statement.getColumnDataType() + "{autoIncrement:true}", database).toDatabaseDataType(database)
            + " "
            + database.getAutoIncrementClause(statement.getStartWith(), statement.getIncrementBy());

        return new Sql[]{
            new UnparsedSql(sql, getAffectedColumn(statement))
        };
    }
View Full Code Here

Examples of liquibase.sql.UnparsedSql

62
63
64
65
66
67
68
69
        if( database instanceof MySQLDatabase && statement.getRemarks() != null ) {
            sql += " COMMENT '" + statement.getRemarks() +"' ";
        }

        return new Sql[] {
                new UnparsedSql(sql, getAffectedOldColumn(statement), getAffectedNewColumn(statement))
        };
    }
View Full Code Here

Examples of liquibase.sql.UnparsedSql

41
42
43
44
45
46
47
48
        } else {
            sql = "ALTER TABLE " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getTableName()) + " DROP CONSTRAINT " + database.escapeConstraintName(statement.getConstraintName());
        }

        return new Sql[] {
                new UnparsedSql(sql, getAffectedUniqueConstraint(statement))
        };
    }
View Full Code Here

Examples of liquibase.sql.UnparsedSql

37
38
39
40
41
42
43
44
45
46
47
48
49
        List<Sql> sql = new ArrayList<Sql>();

        String procedureText = statement.getProcedureText();

        if (statement.getReplaceIfExists() != null && statement.getReplaceIfExists()) {
            sql.add(new UnparsedSql("if object_id('dbo."+statement.getProcedureName()+"', 'p') is null exec ('create procedure "+database.escapeObjectName(statement.getProcedureName(), StoredProcedure.class)+" as select 1 a')"));

            procedureText = procedureText.replaceFirst("(?i)create\\s+procedure", "ALTER PROCEDURE");
        }

        sql.add(new UnparsedSql(procedureText, statement.getEndDelimiter()));
        return sql.toArray(new Sql[sql.size()]);
    }
View Full Code Here

Examples of liquibase.sql.UnparsedSql

28
29
30
31
32
33
34
35
        String sql = string.toString().replaceFirst(",$", "")+")";

        if (database instanceof OracleDatabase) {
            sql = sql.replaceFirst("exec ", "BEGIN ").replaceFirst("\\)$", "); END;");
        }
        return new Sql[] { new UnparsedSql(sql)};

    }
View Full Code Here

Examples of liquibase.sql.UnparsedSql

22
23
24
25
26
27
28
    @Override
    public Sql[] generateSql(GetViewDefinitionStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) {
        CatalogAndSchema schema = new CatalogAndSchema(statement.getCatalogName(), statement.getSchemaName()).customize(database);

        String sql = "exec sp_helptext '" + schema.getSchemaName() + "."+ statement.getViewName() + "'";
            return new Sql[]{new UnparsedSql(sql) };
    }}
View Full Code Here

Examples of liquibase.sql.UnparsedSql

50
51
52
53
54
55
56
57
58
59
60
        } else {
            sql = "ALTER SEQUENCE " + database.escapeSequenceName(statement.getCatalogName(), statement.getSchemaName(), statement.getOldSequenceName()) + " RENAME TO " + database.escapeObjectName(statement.getNewSequenceName(), Sequence.class);
        }

        return new Sql[]{
                new UnparsedSql(sql,
                        getAffectedOldSequence(statement),
                        getAffectedNewSequence(statement)
                )
        };
    }
View Full Code Here

Examples of liquibase.sql.UnparsedSql

51
52
53
54
55
56
57
58
            }
            sql.append(" ").append(fixedWhereClause);
        }

        return new Sql[]{
                new UnparsedSql(sql.toString(), getAffectedTable(statement))
        };
    }
View Full Code Here

Examples of liquibase.sql.UnparsedSql

51
52
53
54
55
56
57
58
59
60
61
        } else {
            sql = "RENAME " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getOldTableName()) + " TO " + database.escapeTableName(statement.getCatalogName(), statement.getSchemaName(), statement.getNewTableName());
        }

        return new Sql[]{
                new UnparsedSql(sql,
                        getAffectedOldTable(statement),
                        getAffectedNewTable(statement)
                )
        };
    }
View Full Code Here

Examples of liquibase.sql.UnparsedSql

152
153
154
155
156
157
158
159
        if ( !insertOrUpdateStatement.getOnlyUpdate() ) {
          completeSql.append(getPostUpdateStatements(database));
        }

        return new Sql[]{
                new UnparsedSql(completeSql.toString(), "", getAffectedTable(insertOrUpdateStatement))
        };
    }
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.