CreateProcedureChangeTest.java

package liquibase.change.core;

import liquibase.change.AbstractChangeTest;
import static org.junit.Assert.*;
import org.junit.Test;

public abstract class CreateProcedureChangeTest extends AbstractChangeTest {

    @Override
    @Test
    public void getRefactoringName() throws Exception {
        assertEquals("Create Procedure", new CreateProcedureChange().getChangeMetaData().getDescription());
    }

//    @Test
//    public void generateStatement() throws Exception {
//        new DatabaseTestTemplate().testOnAllDatabases(new DatabaseTest() {
//            public void performTest(Database database) throws Exception {
//                CreateProcedureChange change = new CreateProcedureChange();
//                change.setProcedureBody("CREATE PROC PROCBODY HERE");
//                change.setComments("Comments go here");
//
//                SqlStatement[] sqlStatements = change.generateStatements(database);
//                assertEquals(1, sqlStatements.length);
//                assertTrue(sqlStatements[0] instanceof RawSqlStatement);
//
//                assertEquals("CREATE PROC PROCBODY HERE", ((RawSqlStatement) sqlStatements[0]).getSqlStatement(database));
//
//                if (database instanceof OracleDatabase) {
//                    assertEquals("\n/", sqlStatements[0].getEndDelimiter(database));
//                } else {
//                    assertEquals(";", sqlStatements[0].getEndDelimiter(database));
//                }
//            }
//        });
//    }

    @Override
    @Test
    public void getConfirmationMessage() throws Exception {
        CreateProcedureChange refactoring = new CreateProcedureChange();
        assertEquals("Stored procedure created", refactoring.getConfirmationMessage());
    }
}