Changes_Exception_Test.java

/**
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with
 * the License. You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on
 * an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the
 * specific language governing permissions and limitations under the License.
 *
 * Copyright 2012-2016 the original author or authors.
 */
package org.assertj.db.type;

import org.assertj.db.common.AbstractTest;
import org.assertj.db.common.DefaultConnection;
import org.assertj.db.common.DefaultDataSource;
import org.assertj.db.common.DefaultStatement;
import org.assertj.db.exception.AssertJDBException;
import org.junit.Test;

import javax.sql.DataSource;
import java.sql.*;

/**
 * Tests on the exceptions of Changes
 * 
 * @author Régis Pouiller
 * 
 */
public class Changes_Exception_Test extends AbstractTest {

  /**
   * This method should fail because the connection throw an exception when getting an object.
   */
  @Test(expected = AssertJDBException.class)
  public void should_fail_because_connection_throws_exception_when_getting_an_object() {
    DataSource ds = new DefaultDataSource(dataSource);
    Table table = new Table(ds, "movi");
    Changes changes = new Changes().setTables(table);
    changes.setStartPointNow();
  }

  /**
   * This method should fail because the connection throw an exception when getting the tables.
   */
  @Test(expected = AssertJDBException.class)
  public void should_fail_because_connection_throws_exception_when_getting_tables() {
    DataSource ds = new DefaultDataSource(dataSource) {
      @Override
      public Connection getConnection() throws SQLException {
        return new DefaultConnection(thisDataSource.getConnection()) {

          
          @Override
          public DatabaseMetaData getMetaData() throws SQLException {
            throw new SQLException();
          }
        };
      }
    };
    Table table = new Table(ds, "movi");
    Changes changes = new Changes().setTables(table);
    changes.setStartPointNow();
  }


  /**
   * This method should fail because the connection throw an exception when executing a query.
   */
  @Test(expected = AssertJDBException.class)
  public void should_fail_because_connection_throws_exception_when_executing_a_query() {
    DataSource ds = new DefaultDataSource(dataSource) {
      @Override
      public Connection getConnection() throws SQLException {
        return new DefaultConnection(thisDataSource.getConnection()) {

          @Override
          public Statement createStatement() throws SQLException {
            return new DefaultStatement(thisConnection.createStatement()) {

              @Override
              public ResultSet executeQuery(String sql) throws SQLException {
                throw new SQLException();
              }
            };
          }
        };
      }
    };
    Table table = new Table(ds, "movi");
    Changes changes = new Changes().setTables(table);
    changes.setStartPointNow();
  }

  /**
   * This method should fail because the connection throw an exception when getting metadata.
   */
  @Test(expected = AssertJDBException.class)
  public void should_fail_because_connection_throws_exception_when_getting_metadata() {
    DataSource ds = new DefaultDataSource(dataSource) {
      @Override
      public Connection getConnection() throws SQLException {
        return new DefaultConnection(thisDataSource.getConnection()) {

          @Override
          public DatabaseMetaData getMetaData() throws SQLException {
            throw new SQLException();
          }
        };
      }
    };
    Table table = new Table(ds, "movi");
    Changes changes = new Changes().setTables(table);
    changes.setStartPointNow();
  }

  /**
   * This method should fail because the connection throw an exception when creating a statement.
   */
  @Test(expected = AssertJDBException.class)
  public void should_fail_because_connection_throws_exception_when_creating_a_statement() {
    DataSource ds = new DefaultDataSource(dataSource) {
      @Override
      public Connection getConnection() throws SQLException {
        return new DefaultConnection(thisDataSource.getConnection()) {

          @Override
          public Statement createStatement() throws SQLException {
            throw new SQLException();
          }
        };
      }
    };
    Table table = new Table(ds, "movi");
    Changes changes = new Changes().setTables(table);
    changes.setStartPointNow();
  }

  /**
   * This method should fail because the connection throw an exception when getting a connection.
   */
  @Test(expected = AssertJDBException.class)
  public void should_fail_because_connection_throws_exception_when_getting_a_connection() {
    DataSource ds = new DefaultDataSource(dataSource) {
      @Override
      public Connection getConnection() throws SQLException {
        throw new SQLException();
      }
    };
    Table table = new Table(ds, "movi");
    Changes changes = new Changes().setTables(table);
    changes.setStartPointNow();
  }

  /**
   * This method should fail because the table is null.
   */
  @Test(expected = NullPointerException.class)
  public void should_fail_because_table_is_null() {
    new Changes().setTables((Table) null);
  }

  /**
   * This method should fail because the request is null.
   */
  @Test(expected = NullPointerException.class)
  public void should_fail_because_request_is_null() {
    new Changes().setRequest(null);
  }

  /**
   * This method should fail because setting end point before start point.
   */
  @Test(expected = AssertJDBException.class)
  public void should_fail_because_end_before_start() {
    Table table = new Table(dataSource, "test");
    Changes changes = new Changes().setTables(table);
    changes.setEndPointNow();
  }

  /**
   * This method should fail because getting list of changes before setting end point.
   */
  @Test(expected = AssertJDBException.class)
  public void should_fail_because_getting_list_of_changes_before_end() {
    Table table = new Table(dataSource, "test");
    Changes changes = new Changes().setTables(table);
    changes.setStartPointNow();
    changes.getChangesList();
  }

  /**
   * This method should fail because the table name is null.
   */
  @Test(expected = NullPointerException.class)
  public void should_fail_because_tablename_is_null() {
    new Changes(source).getChangesOfTable(null);
  }

  /**
   * This method should fail because the type is null.
   */
  @Test(expected = NullPointerException.class)
  public void should_fail_because_type_is_null() {
    new Changes(source).getChangesOfType(null);
  }
}