Examples with CreateDatabaseChangeLogLockTableStatement liquibase.statement.core.CreateDatabaseChangeLogLockTableStatement used on opensource projects

Example 1 with CreateDatabaseChangeLogLockTableStatement

use of liquibase.statement.core.CreateDatabaseChangeLogLockTableStatement in project keycloak by keycloak.

the class CustomLockService method init.

@Override
public void init() throws DatabaseException {
    Executor executor = Scope.getCurrentScope().getSingleton(ExecutorService.class).getExecutor(LiquibaseConstants.JDBC_EXECUTOR, database);
    if (!hasDatabaseChangeLogLockTable()) {
        try {
            if (log.isTraceEnabled()) {
                log.trace("Create Database Lock Table");
            }
            executor.execute(new CreateDatabaseChangeLogLockTableStatement());
            database.commit();
        } catch (DatabaseException de) {
            log.warn("Failed to create lock table. Maybe other transaction created in the meantime. Retrying...");
            if (log.isTraceEnabled()) {
                // Log details at trace level
                log.trace(de.getMessage(), de);
            }
            database.rollback();
            throw new LockRetryException(de);
        }
        log.debugf("Created database lock table with name: %s", database.escapeTableName(database.getLiquibaseCatalogName(), database.getLiquibaseSchemaName(), database.getDatabaseChangeLogLockTableName()));
        try {
            Field field = Reflections.findDeclaredField(StandardLockService.class, "hasDatabaseChangeLogLockTable");
            Reflections.setAccessible(field);
            field.set(CustomLockService.this, true);
        } catch (IllegalAccessException iae) {
            throw new RuntimeException(iae);
        }
    }
    try {
        Set<Integer> currentIds = currentIdsInDatabaseChangeLogLockTable();
        if (!currentIds.containsAll(Arrays.asList(DBLockProvider.Namespace.values()))) {
            if (log.isTraceEnabled()) {
                log.tracef("Initialize Database Lock Table, current locks %s", currentIds);
            }
            executor.execute(new CustomInitializeDatabaseChangeLogLockTableStatement(currentIds));
            database.commit();
            log.debug("Initialized record in the database lock table");
        }
    } catch (DatabaseException de) {
        log.warn("Failed to insert first record to the lock table. Maybe other transaction inserted in the meantime. Retrying...");
        if (log.isTraceEnabled()) {
            // Log details at trace level
            log.trace(de.getMessage(), de);
        }
        database.rollback();
        throw new LockRetryException(de);
    }
    // Keycloak doesn't support Derby, but keep it for sure...
    if (executor.updatesDatabase() && database instanceof DerbyDatabase && ((DerbyDatabase) database).supportsBooleanDataType()) {
        // check if the changelog table is of an old smallint vs. boolean format
        String lockTable = database.escapeTableName(database.getLiquibaseCatalogName(), database.getLiquibaseSchemaName(), database.getDatabaseChangeLogLockTableName());
        Object obj = executor.queryForObject(new RawSqlStatement("select min(locked) as test from " + lockTable + " fetch first row only"), Object.class);
        if (!(obj instanceof Boolean)) {
            // wrong type, need to recreate table
            executor.execute(new DropTableStatement(database.getLiquibaseCatalogName(), database.getLiquibaseSchemaName(), database.getDatabaseChangeLogLockTableName(), false));
            executor.execute(new CreateDatabaseChangeLogLockTableStatement());
            executor.execute(new InitializeDatabaseChangeLogLockTableStatement());
        }
    }
}

Example 2 with CreateDatabaseChangeLogLockTableStatement

use of liquibase.statement.core.CreateDatabaseChangeLogLockTableStatement in project liquibase by liquibase.

the class CreateDatabaseChangeLogLockTableExecuteTest method generate.

@Test
public void generate() throws Exception {
    this.statementUnderTest = new CreateDatabaseChangeLogLockTableStatement();
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] boolean not null, " + "[lockgranted] datetime, " + "[lockedby] text, " + "constraint [pk_databasechangeloglock] primary key ([id]))" }, SQLiteDatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] bit not null, " + "[lockgranted] datetime null, " + "[lockedby] varchar(255) null, " + "constraint [pk_databasechangeloglock] primary key ([id]))" }, SybaseDatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] bit not null, " + "[lockgranted] datetime null, " + "[lockedby] varchar(255) null, " + "constraint [pk_databasechangeloglock] primary key ([id]))" }, SybaseASADatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] boolean not null, " + "[lockgranted] datetime, " + "[lockedby] varchar(255), " + "primary key (id))" }, InformixDatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] [int] not null, " + "[locked] [bit] not null, " + "[lockgranted] [datetime2](3), " + "[lockedby] [nvarchar](255), " + "constraint [pk_databasechangeloglock] primary key ([id]))" }, MSSQLDatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] integer not null, " + "[locked] smallint not null, " + "[lockgranted] timestamp, " + "[lockedby] varchar(255), " + "constraint [pk_dbchgloglock] primary key ([id]))" }, DB2Database.class);
    assertCorrect(new String[] { "create table databasechangeloglock (" + "id integer not null, " + "locked number(1) not null, " + "lockgranted timestamp, " + "lockedby varchar2(255), " + "constraint pk_databasechangeloglock primary key (id))" }, OracleDatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] boolean not null, " + "[lockgranted] datetime null, " + "[lockedby] varchar(255) null, " + "constraint [pk_databasechangeloglock] primary key ([id]))" }, MySQLDatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] boolean not null, " + "[lockgranted] datetime null, " + "[lockedby] varchar(255) null, " + "constraint [pk_databasechangeloglock] primary key ([id]))" }, MariaDBDatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] boolean not null, " + "[lockgranted] datetime, " + "[lockedby] varchar(255), " + "constraint [databasechangeloglock_pkey] primary key ([id]))" }, PostgresDatabase.class, CockroachDatabase.class, EnterpriseDBDatabase.class);
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] boolean not null, " + "[lockgranted] datetime, " + "[lockedby] varchar(255), " + "constraint [pk_dbchgloglock] primary key ([id]))" }, Db2zDatabase.class);
    // all other RDBMS
    assertCorrect(new String[] { "create table [databasechangeloglock] (" + "[id] int not null, " + "[locked] boolean not null, " + "[lockgranted] datetime, " + "[lockedby] varchar(255), " + "constraint [pk_databasechangeloglock] primary key ([id]))" });
}