package liquibase.change.core;
import liquibase.change.AbstractChangeTest;
import liquibase.database.core.MockDatabase;
import liquibase.statement.SqlStatement;
import liquibase.statement.core.DropColumnStatement;
import static org.junit.Assert.*;
import org.junit.Test;
/**
* Tests for {@link DropColumnChange}
*/
public class DropColumnChangeTest extends AbstractChangeTest {
@Override
@Test
public void getRefactoringName() throws Exception {
assertEquals("Drop Column", new DropColumnChange().getChangeMetaData().getDescription());
}
@Override
@Test
public void generateStatement() throws Exception {
DropColumnChange change = new DropColumnChange();
change.setSchemaName("SCHEMA_NAME");
change.setTableName("TABLE_NAME");
change.setColumnName("COL_HERE");
SqlStatement[] sqlStatements = change.generateStatements(new MockDatabase());
assertEquals(1, sqlStatements.length);
assertTrue(sqlStatements[0] instanceof DropColumnStatement);
assertEquals("SCHEMA_NAME", ((DropColumnStatement) sqlStatements[0]).getSchemaName());
assertEquals("TABLE_NAME", ((DropColumnStatement) sqlStatements[0]).getTableName());
assertEquals("COL_HERE", ((DropColumnStatement) sqlStatements[0]).getColumnName());
}
@Override
@Test
public void getConfirmationMessage() throws Exception {
DropColumnChange change = new DropColumnChange();
change.setTableName("TABLE_NAME");
change.setColumnName("COL_HERE");
assertEquals("Column TABLE_NAME.COL_HERE dropped", change.getConfirmationMessage());
}
}