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

Example 6 with AddColumnStatement

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

the class AddColumnExecutorTest method generateSql_primaryKey.

@SuppressWarnings("unchecked")
@Test
public void generateSql_primaryKey() throws Exception {
    this.statementUnderTest = new AddColumnStatement(null, "table_name", "column_name", "int", null, new PrimaryKeyConstraint());
    assertCorrect("alter table [table_name] add [column_name] int not null primary key", HsqlDatabase.class);
    assertCorrect("alter table [table_name] add [column_name] int primary key not null", SybaseASADatabase.class, SybaseDatabase.class);
    assertCorrect("alter table [dbo].[table_name] add [column_name] int not null primary key", MSSQLDatabase.class);
    assertCorrect("alter table table_name add column_name int not null primary key", PostgresDatabase.class);
    assertCorrect("alter table `table_name` add `column_name` int not null primary key", MySQLDatabase.class);
    assertCorrect("ALTER TABLE [table_name] ADD [column_name] int PRIMARY KEY NOT NULL");
}

Example 7 with AddColumnStatement

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

the class AddColumnExecutorTest method notNull.

@SuppressWarnings("unchecked")
@Test
public void notNull() throws Exception {
    this.statementUnderTest = new AddColumnStatement(null, null, TABLE_NAME, "column_name", "int", 42, new NotNullConstraint());
    assertCorrect("ALTER TABLE [table_name] ADD [column_name] int DEFAULT 42 NOT NULL", SybaseASADatabase.class, SybaseDatabase.class);
    assertCorrect("alter table table_name add column_name int default 42 not null", InformixDatabase.class);
    assertCorrect("alter table [table_name] add [column_name] int not null constraint df_table_name_column_name default 42", MSSQLDatabase.class);
    assertCorrect("alter table table_name add column_name int default 42 not null", OracleDatabase.class, DerbyDatabase.class, HsqlDatabase.class, DB2Database.class, H2Database.class, FirebirdDatabase.class);
    assertCorrect("not supported. fixme!!", SQLiteDatabase.class);
    assertCorrectOnRest("ALTER TABLE [table_name] ADD [column_name] int NOT NULL DEFAULT 42");
}

Example 8 with AddColumnStatement

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

the class AddColumnExecutorTest method generateSql_notNull.

@SuppressWarnings("unchecked")
@Test
public void generateSql_notNull() throws Exception {
    this.statementUnderTest = new AddColumnStatement(null, null, "table_name", "column_name", "int", 42, new NotNullConstraint());
    assertCorrect("alter table [table_name] add [column_name] int default 42 not null", SybaseASADatabase.class, SybaseDatabase.class);
    assertCorrect("alter table table_name add column_name int not null default 42", PostgresDatabase.class);
    assertCorrect("alter table [table_name] add [column_name] int not null constraint df_table_name_column_name default 42", MSSQLDatabase.class);
    assertCorrect("alter table table_name add column_name int not null default 42", MySQLDatabase.class);
    assertCorrect("not supported. fixme!!", SQLiteDatabase.class);
    assertCorrect("ALTER TABLE [table_name] ADD [column_name] int DEFAULT 42 NOT NULL");
}

Example 9 with AddColumnStatement

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

the class AddColumnExecutorTest method autoIncrement.

@SuppressWarnings("unchecked")
@Test
public void autoIncrement() throws Exception {
    this.statementUnderTest = new AddColumnStatement(null, TABLE_NAME, "column_name", "int", null, new AutoIncrementConstraint());
    assertCorrect("ALTER TABLE [dbo].[table_name] ADD [column_name] int auto_increment_clause", MSSQLDatabase.class);
    assertCorrect("alter table [table_name] add [column_name] int default autoincrement null", SybaseASADatabase.class);
    assertCorrect("alter table [table_name] add [column_name] int identity null", SybaseDatabase.class);
    assertCorrect("alter table [table_name] add [column_name] serial", PostgresDatabase.class, InformixDatabase.class);
    assertCorrect("not supported. fixme!!", SQLiteDatabase.class);
    assertCorrectOnRest("ALTER TABLE [table_name] ADD [column_name] int auto_increment_clause");
}

Example 10 with AddColumnStatement

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

the class AddColumnGeneratorDefaultClauseBeforeNotNullTest method validate_noAutoIncrementWithDerby.

@Test
public void validate_noAutoIncrementWithDerby() {
    ValidationErrors validationErrors = generatorUnderTest.validate(new AddColumnStatement(null, null, "table_name", "column_name", "int", null, new AutoIncrementConstraint("column_name")), new DerbyDatabase(), new MockSqlGeneratorChain());
    assertTrue(validationErrors.getErrorMessages().contains("Cannot add an identity column to derby"));
}