Examples with JpaUpdaterProvider org.keycloak.connections.jpa.updater.JpaUpdaterProvider used on opensource projects

Example 1 with JpaUpdaterProvider

use of org.keycloak.connections.jpa.updater.JpaUpdaterProvider in project keycloak by keycloak.

the class QuarkusJpaConnectionProviderFactory method createOrUpdateSchema.

private boolean createOrUpdateSchema(String schema, Connection connection, KeycloakSession session) {
    MigrationStrategy strategy = getMigrationStrategy();
    boolean initializeEmpty = config.getBoolean("initializeEmpty", true);
    File databaseUpdateFile = getDatabaseUpdateFile();
    String version = null;
    try {
        try (Statement statement = connection.createStatement()) {
            try (ResultSet rs = statement.executeQuery(String.format(SQL_GET_LATEST_VERSION, getSchema(schema)))) {
                if (rs.next()) {
                    version = rs.getString(1);
                }
            }
        }
    } catch (SQLException ignore) {
    // migration model probably does not exist so we assume the database is empty
    }
    JpaUpdaterProvider updater = session.getProvider(JpaUpdaterProvider.class);
    boolean requiresMigration = version == null || !version.equals(new ModelVersion(Version.VERSION_KEYCLOAK).toString());
    session.setAttribute(VERIFY_AND_RUN_MASTER_CHANGELOG, requiresMigration);
    JpaUpdaterProvider.Status status = updater.validate(connection, schema);
    if (status == JpaUpdaterProvider.Status.VALID) {
        logger.debug("Database is up-to-date");
    } else if (status == JpaUpdaterProvider.Status.EMPTY) {
        if (initializeEmpty) {
            update(connection, schema, session, updater);
        } else {
            switch(strategy) {
                case UPDATE:
                    update(connection, schema, session, updater);
                    break;
                case MANUAL:
                    export(connection, schema, databaseUpdateFile, session, updater);
                    throw new ServerStartupError("Database not initialized, please initialize database with " + databaseUpdateFile.getAbsolutePath(), false);
                case VALIDATE:
                    throw new ServerStartupError("Database not initialized, please enable database initialization", false);
            }
        }
    } else {
        switch(strategy) {
            case UPDATE:
                update(connection, schema, session, updater);
                break;
            case MANUAL:
                export(connection, schema, databaseUpdateFile, session, updater);
                throw new ServerStartupError("Database not up-to-date, please migrate database with " + databaseUpdateFile.getAbsolutePath(), false);
            case VALIDATE:
                throw new ServerStartupError("Database not up-to-date, please enable database migration", false);
        }
    }
    return requiresMigration;
}

Example 2 with JpaUpdaterProvider

use of org.keycloak.connections.jpa.updater.JpaUpdaterProvider in project keycloak by keycloak.

the class DefaultJpaConnectionProviderFactory method migration.

void migration(MigrationStrategy strategy, boolean initializeEmpty, String schema, File databaseUpdateFile, Connection connection, KeycloakSession session) {
    JpaUpdaterProvider updater = session.getProvider(JpaUpdaterProvider.class, LiquibaseJpaUpdaterProviderFactory.PROVIDER_ID);
    JpaUpdaterProvider.Status status = updater.validate(connection, schema);
    if (status == JpaUpdaterProvider.Status.VALID) {
        logger.debug("Database is up-to-date");
    } else if (status == JpaUpdaterProvider.Status.EMPTY) {
        if (initializeEmpty) {
            update(connection, schema, session, updater);
        } else {
            switch(strategy) {
                case UPDATE:
                    update(connection, schema, session, updater);
                    break;
                case MANUAL:
                    export(connection, schema, databaseUpdateFile, session, updater);
                    throw new ServerStartupError("Database not initialized, please initialize database with " + databaseUpdateFile.getAbsolutePath(), false);
                case VALIDATE:
                    throw new ServerStartupError("Database not initialized, please enable database initialization", false);
            }
        }
    } else {
        switch(strategy) {
            case UPDATE:
                update(connection, schema, session, updater);
                break;
            case MANUAL:
                export(connection, schema, databaseUpdateFile, session, updater);
                throw new ServerStartupError("Database not up-to-date, please migrate database with " + databaseUpdateFile.getAbsolutePath(), false);
            case VALIDATE:
                throw new ServerStartupError("Database not up-to-date, please enable database migration", false);
        }
    }
}