Clover Coverage Report - Liquibase Core 2.0.3-SNAPSHOT
Coverage timestamp: Sat Aug 6 2011 11:33:15 EDT
19   59   4   4.75
0   46   0.21   4
4     1  
1    
 
  DropNotNullConstraintChangeTest       Line # 16 19 0% 4 0 100% 1.0
 
  (4)
 
1    package liquibase.change.core;
2   
3    import liquibase.change.AbstractChangeTest;
4    import liquibase.database.Database;
5    import liquibase.database.core.FirebirdDatabase;
6    import liquibase.database.core.MockDatabase;
7    import liquibase.database.core.SQLiteDatabase;
8    import liquibase.statement.SqlStatement;
9    import liquibase.statement.core.SetNullableStatement;
10    import static org.junit.Assert.*;
11    import org.junit.Test;
12   
13    /**
14    * Tests for {@link DropNotNullConstraintChange}
15    */
 
16    public class DropNotNullConstraintChangeTest extends AbstractChangeTest {
17   
 
18  1 toggle @Override
19    @Test
20    public void getRefactoringName() throws Exception {
21  1 assertEquals("Drop Not-Null Constraint", new DropNotNullConstraintChange().getChangeMetaData().getDescription());
22    }
23   
 
24  1 toggle @Override
25    @Test
26    public void generateStatement() throws Exception {
27  1 DropNotNullConstraintChange change = new DropNotNullConstraintChange();
28  1 change.setSchemaName("SCHEMA_NAME");
29  1 change.setTableName("TABLE_NAME");
30  1 change.setColumnName("COL_HERE");
31  1 change.setColumnDataType("varchar(200)");
32   
33  1 SqlStatement[] sqlStatements = change.generateStatements(new MockDatabase());
34  1 assertEquals(1, sqlStatements.length);
35  1 assertTrue(sqlStatements[0] instanceof SetNullableStatement);
36  1 assertEquals("SCHEMA_NAME", ((SetNullableStatement) sqlStatements[0]).getSchemaName());
37  1 assertEquals("TABLE_NAME", ((SetNullableStatement) sqlStatements[0]).getTableName());
38  1 assertEquals("COL_HERE", ((SetNullableStatement) sqlStatements[0]).getColumnName());
39  1 assertEquals("varchar(200)", ((SetNullableStatement) sqlStatements[0]).getColumnDataType());
40  1 assertTrue(((SetNullableStatement) sqlStatements[0]).isNullable());
41    }
42   
 
43  1 toggle @Override
44    @Test
45    public void getConfirmationMessage() throws Exception {
46  1 DropNotNullConstraintChange change = new DropNotNullConstraintChange();
47  1 change.setTableName("TABLE_NAME");
48  1 change.setColumnName("COL_HERE");
49  1 assertEquals("Null constraint dropped from TABLE_NAME.COL_HERE", change.getConfirmationMessage());
50   
51    }
52   
 
53  15 toggle @Override
54    protected boolean changeIsUnsupported(Database database) {
55  15 return database instanceof FirebirdDatabase
56    || database instanceof SQLiteDatabase;
57    }
58   
59    }