DatabaseUpdateTest.java

package com.goodworkalan.addendum;

import static com.goodworkalan.addendum.Addendum.CANNOT_ADD_COLUMN;
import static com.goodworkalan.addendum.Addendum.CANNOT_ALTER_COLUMN;
import static com.goodworkalan.addendum.Addendum.CANNOT_CREATE_TABLE;
import static com.goodworkalan.addendum.Addendum.CANNOT_DROP_COLUMN;
import static com.goodworkalan.addendum.Addendum.CANNOT_INSERT;
import static com.goodworkalan.addendum.Addendum.CANNOT_RENAME_TABLE;
import static org.testng.Assert.assertEquals;

import java.sql.Connection;
import java.sql.SQLException;

import org.testng.annotations.Test;

import com.goodworkalan.addendum.dialect.Dialect;
import com.goodworkalan.danger.Danger;

/**
 * Unit tests for the {@link DatabaseUpdate} class.
 * 
 * @author AlanGutierrez
 */
public class DatabaseUpdateTest {
    /** Test the cannot create table error message. */
 //   @Test(expectedExceptions = Danger.class)
    public void cannotCreateTableMessage() {
        try {
            new DatabaseUpdate(CANNOT_CREATE_TABLE, "a", "a") {
                public void execute(Connection connection, Dialect dialect)
                        throws SQLException {
                    throw new SQLException();
                }
            }.update(null, null);
        } catch (Danger e) {
            assertEquals(e.code, CANNOT_CREATE_TABLE);
            System.out.println(e.getMessage());
            throw e;
        }
    }
    
    /** Test the cannot alter column error message. */
 //  @Test(expectedExceptions = Danger.class)
    public void cannotAlterColumnMessage() {
        try {
            new DatabaseUpdate(CANNOT_ALTER_COLUMN, "a", "a") {
                public void execute(Connection connection, Dialect dialect)
                        throws SQLException {
                    throw new SQLException();
                }
            }.update(null, null);
        } catch (Danger e) {
            assertEquals(e.code, CANNOT_ALTER_COLUMN);
            System.out.println(e.getMessage());
            throw e;
        }
    }
    
    /** Test the cannot add column error message. */
 //  @Test(expectedExceptions = Danger.class)
    public void cannotAddColumnMessage() {
        try {
            new DatabaseUpdate(CANNOT_ADD_COLUMN, "a", "a") {
                public void execute(Connection connection, Dialect dialect)
                        throws SQLException {
                    throw new SQLException();
                }
            }.update(null, null);
        } catch (Danger e) {
            assertEquals(e.code, CANNOT_ADD_COLUMN);
            System.out.println(e.getMessage());
            throw e;
        }
    }
    
    /** Test the cannot drop column error message. */
 //  @Test(expectedExceptions = Danger.class)
    public void cannotDropColumnMessage() {
        try {
            new DatabaseUpdate(CANNOT_DROP_COLUMN, "a", "a") {
                public void execute(Connection connection, Dialect dialect)
                throws SQLException {
                    throw new SQLException();
                }
            }.update(null, null);
        } catch (Danger e) {
            assertEquals(e.code, CANNOT_DROP_COLUMN);
            System.out.println(e.getMessage());
            throw e;
        }
    }
    
    /** Test the cannot insert error message. */
 //  @Test(expectedExceptions = Danger.class)
    public void cannotInsertMessage() {
        try {
            new DatabaseUpdate(CANNOT_INSERT, "a") {
                public void execute(Connection connection, Dialect dialect)
                throws SQLException {
                    throw new SQLException();
                }
            }.update(null, null);
        } catch (Danger e) {
            assertEquals(e.code, CANNOT_INSERT);
            System.out.println(e.getMessage());
            throw e;
        }
    }

    /** Test the cannot insert error message. */
 //  @Test(expectedExceptions = Danger.class)
    public void cannotRenameTableMessage() {
        try {
            new DatabaseUpdate(CANNOT_RENAME_TABLE, "a", "b") {
                public void execute(Connection connection, Dialect dialect)
                throws SQLException {
                    throw new SQLException();
                }
            }.update(null, null);
        } catch (Danger e) {
            assertEquals(e.code, CANNOT_RENAME_TABLE);
            System.out.println(e.getMessage());
            throw e;
        }
    }
}