Examples of liquibase.Liquibase

liquibase.Liquibase
Primary facade class for interacting with Liquibase. The built in command line, Ant, Maven and other ways of running Liquibase are wrappers around methods in this class.

    @Test
    public void runUpdateOnOldChangelogTableFormat() throws Exception {
        if (database == null) {
            return;
        }
        Liquibase liquibase = createLiquibase(completeChangeLog);
        clearDatabase(liquibase);




        ((JdbcConnection) database.getConnection()).getUnderlyingConnection().createStatement().execute("CREATE TABLE DATABASECHANGELOG (id varchar(150) NOT NULL, " +
                "author varchar(150) NOT NULL, " +
                "filename varchar(255) NOT NULL, " +
                "dateExecuted "+ DataTypeFactory.getInstance().fromDescription("datetime", database).toDatabaseDataType(database) +" NOT NULL, " +
                "md5sum varchar(32), " +
                "description varchar(255), " +
                "comments varchar(255), " +
                "tag varchar(255), " +
                "liquibase varchar(10), " +
                "PRIMARY KEY(id, author, filename))");


        liquibase = createLiquibase(completeChangeLog);
        liquibase.update(this.contexts);


    }

View Full Code Here

        if (database == null) {
            return;
        }


        StringWriter output = new StringWriter();
        Liquibase liquibase = createLiquibase(completeChangeLog);
        clearDatabase(liquibase);


        liquibase = createLiquibase(completeChangeLog);
        liquibase.update(this.contexts, output);


        String outputResult = output.getBuffer().toString();
        assertNotNull(outputResult);
        assertTrue(outputResult.length() > 100); //should be pretty big
        System.out.println(outputResult);

View Full Code Here

    public void testUpdateTwice() throws Exception {
        if (database == null) {
            return;
        }


        Liquibase liquibase = createLiquibase(completeChangeLog);
        clearDatabase(liquibase);


        liquibase = createLiquibase(completeChangeLog);
        liquibase.update(this.contexts);
        liquibase.update(this.contexts);
    }

View Full Code Here

    public void testUpdateClearUpdate() throws Exception {
        if (database == null) {
            return;
        }


        Liquibase liquibase = createLiquibase(completeChangeLog);
        clearDatabase(liquibase);


        liquibase = createLiquibase(completeChangeLog);
        liquibase.update(this.contexts);
        clearDatabase(liquibase);


        liquibase = createLiquibase(completeChangeLog);
        liquibase.update(this.contexts);
    }

View Full Code Here

    public void testRollbackableChangeLog() throws Exception {
        if (database == null) {
            return;
        }


        Liquibase liquibase = createLiquibase(rollbackChangeLog);
        clearDatabase(liquibase);


        liquibase = createLiquibase(rollbackChangeLog);
        liquibase.update(this.contexts);


        liquibase = createLiquibase(rollbackChangeLog);
        liquibase.rollback(new Date(0), this.contexts);


        liquibase = createLiquibase(rollbackChangeLog);
        liquibase.update(this.contexts);


        liquibase = createLiquibase(rollbackChangeLog);
        liquibase.rollback(new Date(0), this.contexts);
    }

View Full Code Here

    public void testRollbackableChangeLogScriptOnExistingDatabase() throws Exception {
        if (database == null) {
            return;
        }


        Liquibase liquibase = createLiquibase(rollbackChangeLog);
        clearDatabase(liquibase);


        liquibase = createLiquibase(rollbackChangeLog);
        liquibase.update(this.contexts);


        StringWriter writer = new StringWriter();


        liquibase = createLiquibase(rollbackChangeLog);
        liquibase.rollback(new Date(0), this.contexts, writer);


//        System.out.println("Rollback SQL for "+driverName+StreamUtil.getLineSeparator()+StreamUtil.getLineSeparator()+writer.toString());
    }

View Full Code Here

            return;
        }


        StringWriter writer = new StringWriter();


        Liquibase liquibase = createLiquibase(rollbackChangeLog);
        clearDatabase(liquibase);


        liquibase = createLiquibase(rollbackChangeLog);
        liquibase.futureRollbackSQL(this.contexts, writer);


//        System.out.println("Rollback SQL for future "+driverName+"\n\n"+writer.toString());
    }

View Full Code Here

    public void testTag() throws Exception {
        if (database == null) {
            return;
        }


        Liquibase liquibase = createLiquibase(completeChangeLog);
        clearDatabase(liquibase);


        liquibase = createLiquibase(completeChangeLog);
        liquibase.update(this.contexts);


        liquibase.tag("Test Tag");
    }

View Full Code Here

                output.flush();
            } finally {
                output.close();
            }


            Liquibase liquibase = createLiquibase(tempFile.getName());
            clearDatabase(liquibase);


            DatabaseSnapshot emptySnapshot = SnapshotGeneratorFactory.getInstance().createSnapshot(database.getDefaultSchema(), database, new SnapshotControl(database));


            //run again to test changelog testing logic
            liquibase = createLiquibase(tempFile.getName());
            try {
                liquibase.update(this.contexts);
            } catch (ValidationFailedException e) {
                e.printDescriptiveError(System.out);
                throw e;
            }


//            tempFile.deleteOnExit();


            DatabaseSnapshot migratedSnapshot = SnapshotGeneratorFactory.getInstance().createSnapshot(database.getDefaultSchema(), database, new SnapshotControl(database));


            DiffResult finalDiffResult = DiffGeneratorFactory.getInstance().compare(originalSnapshot, migratedSnapshot, compareControl);
            try {
                assertTrue(finalDiffResult.areEqual());
            } catch (AssertionError e) {
                new DiffToReport(finalDiffResult, System.err).print();
                throw e;
            }


            //diff to empty and drop all
            DiffResult emptyDiffResult = DiffGeneratorFactory.getInstance().compare(emptySnapshot, migratedSnapshot, compareControl);
            output = new FileOutputStream(tempFile);
            try {
                new DiffToChangeLog(emptyDiffResult, new DiffOutputControl(true, true, true)).print(new PrintStream(output));
                output.flush();
            } finally {
                output.close();
            }


            liquibase = createLiquibase(tempFile.getName());
            System.out.println("updating from "+tempFile.getCanonicalPath());
            try {
                liquibase.update(this.contexts);
            } catch (LiquibaseException e) {
                throw e;
            }


            DatabaseSnapshot emptyAgainSnapshot = SnapshotGeneratorFactory.getInstance().createSnapshot(database.getDefaultSchema(), database, new SnapshotControl(database));

View Full Code Here

        }
        if (!database.supportsSchemas()) {
            return;
        }


        Liquibase liquibase = createLiquibase(includedChangeLog);
        clearDatabase(liquibase);


        database.setDefaultSchemaName("lbcat2");


        LockService lockService = LockServiceFactory.getInstance().getLockService(database);
        lockService.forceReleaseLock();


        liquibase.update(includedChangeLog);


        DatabaseSnapshot originalSnapshot = SnapshotGeneratorFactory.getInstance().createSnapshot(database.getDefaultSchema(), database, new SnapshotControl(database));


        CompareControl compareControl = new CompareControl(new CompareControl.SchemaComparison[]{new CompareControl.SchemaComparison(CatalogAndSchema.DEFAULT, new CatalogAndSchema(null, "lbcat2"))}, originalSnapshot.getSnapshotControl().getTypesToInclude());
        DiffResult diffResult = DiffGeneratorFactory.getInstance().compare(database, null, compareControl);


        File tempFile = File.createTempFile("liquibase-test", ".xml");


        FileOutputStream output = new FileOutputStream(tempFile);
        try {
            new DiffToChangeLog(diffResult, new DiffOutputControl()).print(new PrintStream(output));
            output.flush();
        } finally {
            output.close();
        }


        liquibase = createLiquibase(tempFile.getName());
        clearDatabase(liquibase);


        //run again to test changelog testing logic
        Executor executor = ExecutorService.getInstance().getExecutor(database);
        try {
            executor.execute(new DropTableStatement("lbcat2", "lbcat2", database.getDatabaseChangeLogTableName(), false));
        } catch (DatabaseException e) {
            //ok
        }
        try {
            executor.execute(new DropTableStatement("lbcat2", "lbcat2", database.getDatabaseChangeLogLockTableName(), false));
        } catch (DatabaseException e) {
            //ok
        }
        database.commit();


        DatabaseConnection connection = DatabaseTestContext.getInstance().getConnection(url);
        database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(connection);
        database.setDefaultSchemaName("lbcat2");
        liquibase = createLiquibase(tempFile.getName());
        try {
            liquibase.update(this.contexts);
        } catch (ValidationFailedException e) {
            e.printDescriptiveError(System.out);
            throw e;
        }

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

Related Classes of liquibase.Liquibase

ch.inftec.ju.testing.db.DbSchemaUtil

com.aceevo.ursus.db.liquibase.LiquibaseServiceImpl

com.commafeed.backend.service.StartupService

com.hascode.tutorial.setup.InitializerBean

liquibase.database.DatabaseConnection

liquibase.dbtest.AbstractIntegrationTest

liquibase.dbtest.h2.H2IntegrationTest

liquibase.dbtest.mssql.AbstractMssqlIntegrationTest

liquibase.dbtest.mssql.MssqlIntegrationTest

liquibase.dbtest.oracle.OracleIntegrationTest

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.