Examples with Database liquibase.database.Database used on opensource projects

Example 11 with Database

use of liquibase.database.Database in project liquibase by liquibase.

the class SpringLiquibase method getDatabaseProductName.

public String getDatabaseProductName() throws DatabaseException {
    Connection connection = null;
    Database database = null;
    String name = "unknown";
    try {
        connection = getDataSource().getConnection();
        database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(connection));
        name = database.getDatabaseProductName();
    } catch (SQLException e) {
        throw new DatabaseException(e);
    } finally {
        if (database != null) {
            database.close();
        } else if (connection != null) {
            try {
                if (!connection.getAutoCommit()) {
                    connection.rollback();
                }
                connection.close();
            } catch (Exception e) {
                log.warning("problem closing connection", e);
            }
        }
    }
    return name;
}

Example 12 with Database

use of liquibase.database.Database in project liquibase by liquibase.

the class AbstractDatabaseDiffTask method getDiffResult.

protected DiffResult getDiffResult() {
    Liquibase liquibase = getLiquibase();
    Database targetDatabase = liquibase.getDatabase();
    Database referenceDatabase = createDatabaseFromType(referenceDatabaseType);
    CatalogAndSchema targetCatalogAndSchema = buildCatalogAndSchema(targetDatabase);
    CatalogAndSchema referenceCatalogAndSchema = buildCatalogAndSchema(referenceDatabase);
    CompareControl.SchemaComparison[] schemaComparisons = { new CompareControl.SchemaComparison(referenceCatalogAndSchema, targetCatalogAndSchema) };
    SnapshotGeneratorFactory snapshotGeneratorFactory = SnapshotGeneratorFactory.getInstance();
    DatabaseSnapshot referenceSnapshot;
    try {
        referenceSnapshot = snapshotGeneratorFactory.createSnapshot(referenceDatabase.getDefaultSchema(), referenceDatabase, new SnapshotControl(referenceDatabase, diffTypes));
    } catch (LiquibaseException e) {
        throw new BuildException("Unable to create a DatabaseSnapshot. " + e.toString(), e);
    }
    CompareControl compareControl = new CompareControl(schemaComparisons, referenceSnapshot.getSnapshotControl().getTypesToInclude());
    try {
        return liquibase.diff(referenceDatabase, targetDatabase, compareControl);
    } catch (LiquibaseException e) {
        throw new BuildException("Unable to diff databases. " + e.toString(), e);
    }
}

Example 13 with Database

use of liquibase.database.Database in project liquibase by liquibase.

the class BaseLiquibaseTask method execute.

@Override
public final void execute() throws BuildException {
    super.execute();
    log("Starting Liquibase.", Project.MSG_INFO);
    classLoader = getProject().createClassLoader(classpath);
    classLoader.setParent(this.getClass().getClassLoader());
    classLoader.setThreadContextLoader();
    validateParameters();
    Database database = null;
    try {
        ResourceAccessor resourceAccessor = createResourceAccessor(classLoader);
        database = createDatabaseFromType(databaseType);
        liquibase = new Liquibase(getChangeLogFile(), resourceAccessor, database);
        if (changeLogParameters != null) {
            changeLogParameters.applyParameters(liquibase);
        }
        if (isPromptOnNonLocalDatabase() && !liquibase.isSafeToRunUpdate() && UIFactory.getInstance().getFacade().promptForNonLocalDatabase(liquibase.getDatabase())) {
            log("User chose not to run task against a non-local database.", Project.MSG_INFO);
            return;
        }
        if (shouldRun()) {
            executeWithLiquibaseClassloader();
        }
    } catch (LiquibaseException e) {
        throw new BuildException("Unable to initialize Liquibase. " + e.toString(), e);
    } finally {
        closeDatabase(database);
        classLoader.resetThreadContextLoader();
        classLoader.cleanup();
        classLoader = null;
    }
}

Example 14 with Database

use of liquibase.database.Database in project liquibase by liquibase.

the class DatabaseType method createDatabase.

public Database createDatabase(ClassLoader classLoader) {
    logParameters();
    validateParameters();
    try {
        DatabaseFactory databaseFactory = DatabaseFactory.getInstance();
        if (databaseClass != null) {
            Database databaseInstance = (Database) ClasspathUtils.newInstance(databaseClass, classLoader, Database.class);
            databaseFactory.register(databaseInstance);
        }
        DatabaseConnection jdbcConnection;
        if (getUrl().startsWith("offline:")) {
            jdbcConnection = new OfflineConnection(getUrl(), new ClassLoaderResourceAccessor(classLoader));
        } else {
            Driver driver = (Driver) ClasspathUtils.newInstance(getDriver(), classLoader, Driver.class);
            if (driver == null) {
                throw new BuildException("Unable to create Liquibase Database instance. Could not instantiate the JDBC driver.");
            }
            Properties connectionProps = new Properties();
            String user = getUser();
            if (user != null && !user.isEmpty()) {
                connectionProps.setProperty(USER, user);
            }
            String password = getPassword();
            if (password != null && !password.isEmpty()) {
                connectionProps.setProperty(PASSWORD, password);
            }
            ConnectionProperties connectionProperties = getConnectionProperties();
            if (connectionProperties != null) {
                connectionProps.putAll(connectionProperties.buildProperties());
            }
            Connection connection = driver.connect(getUrl(), connectionProps);
            if (connection == null) {
                throw new BuildException("Unable to create Liquibase Database instance. Could not connect to the database.");
            }
            jdbcConnection = new JdbcConnection(connection);
        }
        Database database = databaseFactory.findCorrectDatabaseImplementation(jdbcConnection);
        String schemaName = getDefaultSchemaName();
        if (schemaName != null) {
            database.setDefaultSchemaName(schemaName);
        }
        String catalogName = getDefaultCatalogName();
        if (catalogName != null) {
            database.setDefaultCatalogName(catalogName);
        }
        String currentDateTimeFunction = getCurrentDateTimeFunction();
        if (currentDateTimeFunction != null) {
            database.setCurrentDateTimeFunction(currentDateTimeFunction);
        }
        database.setOutputDefaultSchema(isOutputDefaultSchema());
        database.setOutputDefaultCatalog(isOutputDefaultCatalog());
        String liquibaseSchemaName = getLiquibaseSchemaName();
        if (liquibaseSchemaName != null) {
            database.setLiquibaseSchemaName(liquibaseSchemaName);
        }
        String liquibaseCatalogName = getLiquibaseCatalogName();
        if (liquibaseCatalogName != null) {
            database.setLiquibaseCatalogName(liquibaseCatalogName);
        }
        String databaseChangeLogTableName = getDatabaseChangeLogTableName();
        if (databaseChangeLogTableName != null) {
            database.setDatabaseChangeLogTableName(databaseChangeLogTableName);
        }
        String databaseChangeLogLockTableName = getDatabaseChangeLogLockTableName();
        if (databaseChangeLogLockTableName != null) {
            database.setDatabaseChangeLogLockTableName(databaseChangeLogLockTableName);
        }
        String liquibaseTablespaceName = getLiquibaseTablespaceName();
        if (liquibaseTablespaceName != null) {
            database.setLiquibaseTablespaceName(liquibaseTablespaceName);
        }
        return database;
    } catch (SQLException e) {
        throw new BuildException("Unable to create Liquibase database instance. A JDBC error occurred. " + e.toString(), e);
    } catch (DatabaseException e) {
        throw new BuildException("Unable to create Liquibase database instance. " + e.toString(), e);
    }
}

Example 15 with Database

use of liquibase.database.Database in project liquibase by liquibase.

the class CommandLineUtils method createDatabaseObject.

public static Database createDatabaseObject(ResourceAccessor resourceAccessor, String url, String username, String password, String driver, String defaultCatalogName, String defaultSchemaName, boolean outputDefaultCatalog, boolean outputDefaultSchema, String databaseClass, String driverPropertiesFile, String propertyProviderClass, String liquibaseCatalogName, String liquibaseSchemaName, String databaseChangeLogTableName, String databaseChangeLogLockTableName) throws DatabaseException {
    try {
        liquibaseCatalogName = StringUtils.trimToNull(liquibaseCatalogName);
        liquibaseSchemaName = StringUtils.trimToNull(liquibaseSchemaName);
        defaultCatalogName = StringUtils.trimToNull(defaultCatalogName);
        defaultSchemaName = StringUtils.trimToNull(defaultSchemaName);
        databaseChangeLogTableName = StringUtils.trimToNull(databaseChangeLogTableName);
        databaseChangeLogLockTableName = StringUtils.trimToNull(databaseChangeLogLockTableName);
        Database database = DatabaseFactory.getInstance().openDatabase(url, username, password, driver, databaseClass, driverPropertiesFile, propertyProviderClass, resourceAccessor);
        if (!database.supportsSchemas()) {
            if (defaultSchemaName != null && defaultCatalogName == null) {
                defaultCatalogName = defaultSchemaName;
            }
            if (liquibaseSchemaName != null && liquibaseCatalogName == null) {
                liquibaseCatalogName = liquibaseSchemaName;
            }
        }
        defaultCatalogName = StringUtils.trimToNull(defaultCatalogName);
        defaultSchemaName = StringUtils.trimToNull(defaultSchemaName);
        database.setDefaultCatalogName(defaultCatalogName);
        database.setDefaultSchemaName(defaultSchemaName);
        database.setOutputDefaultCatalog(outputDefaultCatalog);
        database.setOutputDefaultSchema(outputDefaultSchema);
        database.setLiquibaseCatalogName(liquibaseCatalogName);
        database.setLiquibaseSchemaName(liquibaseSchemaName);
        if (databaseChangeLogTableName != null) {
            database.setDatabaseChangeLogTableName(databaseChangeLogTableName);
            if (databaseChangeLogLockTableName != null) {
                database.setDatabaseChangeLogLockTableName(databaseChangeLogLockTableName);
            } else {
                database.setDatabaseChangeLogLockTableName(databaseChangeLogTableName + "LOCK");
            }
        }
        //Todo: move to database object methods in 4.0
        initializeDatabase(username, defaultCatalogName, defaultSchemaName, database);
        //            }
        return database;
    } catch (Exception e) {
        throw new DatabaseException(e);
    }
}