Examples of liquibase.statement.SqlStatement

liquibase.statement.SqlStatement
The SqlStatement classes correspond to (roughly) a single SQL statement. SqlStatement instances are created by Change classes, and by Liquibase itself as the primary database-independent abstraction of statments to execute against a database.
A single SqlStatement may yield multiple SQL commands, and may yield a different number of SQL commands depending on the database. If a particular statement. The SqlStatement implementations do not actually generate SQL strings, that is left to the SqlGenerator implementations. Instead, the purpose of the SqlStatement implementation is to hold the metadata required to generate the correct SQL for a particular database at a later time. @see liquibase.change.Change @see liquibase.sqlgenerator.SqlGenerator @see liquibase.sqlgenerator.SqlGeneratorFactory

      if (!database.hasDatabaseChangeLogLockTable()) {
        return new DatabaseChangeLogLock[0];
      }


      List<DatabaseChangeLogLock> allLocks = new ArrayList<DatabaseChangeLogLock>();
      SqlStatement sqlStatement = new SelectFromDatabaseChangeLogLockStatement("ID", "LOCKED", "LOCKGRANTED",
          "LOCKEDBY");
      List<Map> rows = ExecutorService.getInstance().getExecutor(database).queryForList(sqlStatement);
      for (Map columnMap : rows) {
        Object lockedValue = columnMap.get("LOCKED");
        Boolean locked;

View Full Code Here

        
        ExecutorService.getInstance().setExecutor(database, mockExecutor);
        
        final List<SqlVisitor> sqlVisitors = new ArrayList<SqlVisitor>();
        
        final SqlStatement dropTableStatement = new DropTableStatement(null, null, "test_table", false);
        
        final AppendSqlVisitor appendSqlVisitor = new AppendSqlVisitor();
        appendSqlVisitor.setApplyToRollback(false);
        appendSqlVisitor.setValue(" SHOULD NOT BE APPENDED");

View Full Code Here

        
        ExecutorService.getInstance().setExecutor(database, mockExecutor);
        
        final List<SqlVisitor> sqlVisitors = new ArrayList<SqlVisitor>();
        
        final SqlStatement dropTableStatement = new DropTableStatement(null, null, "test_table", false);        
        
        final AppendSqlVisitor appendSqlVisitor = new AppendSqlVisitor();
        
        appendSqlVisitor.setApplyToRollback(true);
        appendSqlVisitor.setValue(" SHOULD BE APPENDED");

View Full Code Here

            if (!this.hasDatabaseChangeLogLockTable()) {
                return new DatabaseChangeLogLock[0];
            }


            List<DatabaseChangeLogLock> allLocks = new ArrayList<DatabaseChangeLogLock>();
            SqlStatement sqlStatement = new SelectFromDatabaseChangeLogLockStatement("ID", "LOCKED", "LOCKGRANTED", "LOCKEDBY");
            List<Map<String, ?>> rows = ExecutorService.getInstance().getExecutor(database).queryForList(sqlStatement);
            for (Map columnMap : rows) {
                Object lockedValue = columnMap.get("LOCKED");
                Boolean locked;
                if (lockedValue instanceof Number) {

View Full Code Here

    public Sql[] generateSql(MarkChangeSetRanStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) {
        String dateValue = database.getCurrentDateTimeFunction();


        ChangeSet changeSet = statement.getChangeSet();


        SqlStatement runStatement;
        try {
            if (statement.getExecType().equals(ChangeSet.ExecType.FAILED) || statement.getExecType().equals(ChangeSet.ExecType.SKIPPED)) {
                return new Sql[0]; //don't mark
            } else  if (statement.getExecType().ranBefore) {
                runStatement = new UpdateStatement(database.getLiquibaseCatalogName(), database.getLiquibaseSchemaName(), database.getDatabaseChangeLogTableName())

View Full Code Here

            }




        } else if (!changeLogCreateAttempted) {
            executor.comment("Create Database Change Log Table");
            SqlStatement createTableStatement = new CreateDatabaseChangeLogTableStatement();
            if (!canCreateChangeLogTable()) {
                throw new DatabaseException("Cannot create " + getDatabase().escapeTableName(getLiquibaseCatalogName(), getLiquibaseSchemaName(), getDatabaseChangeLogTableName()) + " table for your getDatabase().\n\n" +
                        "Please construct it manually using the following SQL as a base and re-run Liquibase:\n\n" +
                        createTableStatement);
            }

View Full Code Here


    @Override
    public Sql[] generateSql(UpdateChangeSetChecksumStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) {
        ChangeSet changeSet = statement.getChangeSet();


        SqlStatement runStatement = null;
        runStatement = new UpdateStatement(database.getLiquibaseCatalogName(), database.getLiquibaseSchemaName(), database.getDatabaseChangeLogTableName())
                .addNewColumnValue("MD5SUM", changeSet.generateCheckSum().toString())
                .setWhereClause("ID=? AND AUTHOR=? AND FILENAME=?")
                .addWhereParameters(changeSet.getId(), changeSet.getAuthor(), changeSet.getFilePath());

View Full Code Here

 */
public class CustomChange implements CustomSqlChange,CustomSqlRollback{


    @Override
    public SqlStatement[] generateStatements(Database database) throws CustomChangeException {
        SqlStatement st[]=new SqlStatement[1];
        InsertStatement is=new InsertStatement(null, null,"persons");
        is.addColumnValue("id",new Integer(1));
        is.addColumnValue("firstname", "joan");
        is.addColumnValue("lastname", "pujol");
        st[0]=is;

View Full Code Here

        return new ValidationErrors();
    }


    @Override
    public SqlStatement[] generateRollbackStatements(Database database) throws CustomChangeException, RollbackImpossibleException {
        SqlStatement st[]=new SqlStatement[1];
        DeleteStatement ds=new DeleteStatement(null, null,"persons");
        ds.setWhereClause("id=1");
        st[0]=ds;
        return st;
    }

View Full Code Here

TOP

Related Classes of liquibase.statement.SqlStatement

liquibase.changelog.StandardChangeLogHistoryService

liquibase.database.AbstractJdbcDatabaseTest

liquibase.lockservice.LockServiceEx

liquibase.lockservice.StandardLockService

liquibase.maven.integration.CustomChange

liquibase.sqlgenerator.core.MarkChangeSetRanGenerator

liquibase.sqlgenerator.core.UpdateChangeSetChecksumGenerator

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.