Liquibase Integration Tests 2.0.2

Clover Coverage Report - Liquibase Integration Tests 2.0.2

Coverage timestamp: Wed Dec 31 1969 19:00:00 EST

FRAMES NO FRAMES SHOW HELP

Statistics for file RenameColumnExecuteTest.java:
Stmts:	20	LOC:	56	Total cmp:	4	Stmts/Method:	10
Branches:	4	NCLOC:	46	Cmp density:	0.2	Methods/Class:	2
Methods:	2			Avg method cmp:	2
Classes:	1

Expand All

RenameColumnExecuteTest

Line # 16

Total Statements 20

% Filtered 0%

Complexity 4

Uncovered Elements 26

TOTAL Coverage 0%

0.0

No Tests

Collapse All

package liquibase.statementexecute;

import liquibase.database.Database;

import liquibase.database.core.*;

import liquibase.database.typeconversion.TypeConverterFactory;

import liquibase.statement.NotNullConstraint;

import liquibase.statement.SqlStatement;

import liquibase.statement.core.CreateTableStatement;

import liquibase.statement.core.RenameColumnStatement;

import liquibase.test.DatabaseTestContext;

import org.junit.Test;

import java.util.ArrayList;

import java.util.List;

public class RenameColumnExecuteTest extends AbstractExecuteTest {

protected static final String TABLE_NAME = "table_name";

protected static final String COLUMN_NAME = "column_name";

@Override

protected List<? extends SqlStatement> setupStatements(Database database) {

ArrayList<CreateTableStatement> statements = new ArrayList<CreateTableStatement>();

CreateTableStatement table = new CreateTableStatement(null, TABLE_NAME);

if (database instanceof MySQLDatabase) {

table.addPrimaryKeyColumn("id", TypeConverterFactory.getInstance().findTypeConverter(database).getDataType("int", false), null, "pk_", null);

} else {

table.addColumn("id", TypeConverterFactory.getInstance().findTypeConverter(database).getDataType("int", false), null, new NotNullConstraint());

}

table.addColumn(COLUMN_NAME, TypeConverterFactory.getInstance().findTypeConverter(database).getDataType("int", false));

statements.add(table);

if (database.supportsSchemas()) {

table = new CreateTableStatement(DatabaseTestContext.ALT_SCHEMA, TABLE_NAME);

table

.addColumn("id", TypeConverterFactory.getInstance().findTypeConverter(database).getDataType("int", false), null, new NotNullConstraint());

statements.add(table);

}

return statements;

}

@SuppressWarnings("unchecked")

@Test

public void noSchema() throws Exception {

this.statementUnderTest = new RenameColumnStatement(null, TABLE_NAME, COLUMN_NAME, "new_name", "int");

assertCorrect("rename column table_name.column_name to new_name", DerbyDatabase.class, InformixDatabase.class, MaxDBDatabase.class);

assertCorrect("alter table table_name alter column column_name rename to new_name", H2Database.class, HsqlDatabase.class);

assertCorrect("alter table table_name alter column column_name to new_name", FirebirdDatabase.class);

assertCorrect("alter table `table_name` change `column_name` `new_name` int", MySQLDatabase.class);

assertCorrect("exec sp_rename '[dbo].[table_name].[column_name]', 'new_name'", MSSQLDatabase.class);

assertCorrect("alter table [table_name] rename \"column_name\" to \"new_name\"",SybaseASADatabase.class);

assertCorrectOnRest("alter table [table_name] rename column [column_name] to [new_name]");

}