AssertOnNumberOfColumns_HasNumberOfColumnsGreaterThan_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.api.assertions;

import org.assertj.core.api.Assertions;
import org.assertj.db.api.ChangeAssert;
import org.assertj.db.api.ChangeRowAssert;
import org.assertj.db.api.TableAssert;
import org.assertj.db.api.TableRowAssert;
import org.assertj.db.common.AbstractTest;
import org.assertj.db.common.NeedReload;
import org.assertj.db.type.Changes;
import org.assertj.db.type.Request;
import org.assertj.db.type.Table;
import org.junit.Test;

import static org.assertj.db.api.Assertions.assertThat;
import static org.junit.Assert.fail;

/**
 * Tests on {@link org.assertj.db.api.assertions.AssertOnNumberOfColumns} class :
 * {@link org.assertj.db.api.assertions.AssertOnNumberOfColumns#hasNumberOfColumnsGreaterThan(int)} method.
 *
 * @author Régis Pouiller
 *
 */
public class AssertOnNumberOfColumns_HasNumberOfColumnsGreaterThan_Test extends AbstractTest {

  /**
   * This method tests the {@code hasNumberOfColumnsGreaterThan} assertion method.
   */
  @Test
  @NeedReload
  public void test_has_number_of_columns() {
    Table table = new Table(source, "actor");
    Changes changes = new Changes(table).setStartPointNow();
    updateChangesForTests();
    changes.setEndPointNow();

    ChangeAssert changeAssert = assertThat(changes).change();
    ChangeAssert changeAssert2 = changeAssert.hasNumberOfColumnsGreaterThan(4);
    Assertions.assertThat(changeAssert).isSameAs(changeAssert2);

    ChangeRowAssert changeRowAssert = assertThat(changes).change().rowAtEndPoint();
    ChangeRowAssert changeRowAssert2 = changeRowAssert.hasNumberOfColumnsGreaterThan(4);
    Assertions.assertThat(changeRowAssert).isSameAs(changeRowAssert2);

    TableAssert tableAssert = assertThat(table);
    TableAssert tableAssert2 = tableAssert.hasNumberOfColumnsGreaterThan(4);
    Assertions.assertThat(tableAssert).isSameAs(tableAssert2);

    TableRowAssert tableRowAssert = assertThat(table).row();
    TableRowAssert tableRowAssert2 = tableRowAssert.hasNumberOfColumnsGreaterThan(4);
    Assertions.assertThat(tableRowAssert).isSameAs(tableRowAssert2);
  }

  /**
   * This method should fail because the number of columns is different.
   */
  @Test
  @NeedReload
  public void should_fail_because_number_of_columns_is_different() {
    Request request = new Request(source, "select * from actor");
    Changes changes = new Changes(request).setStartPointNow();
    updateChangesForTests();
    changes.setEndPointNow();

    try {
      assertThat(changes).change().hasNumberOfColumnsGreaterThan(9);
      fail("An exception must be raised");
    } catch (AssertionError e) {
      Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[Change at index 0 of Changes on 'select * from actor' request of 'sa/jdbc:h2:mem:test' source] %n"
                                                                    + "Expecting size (number of columns) to be greater than :%n"
                                                                    + "   <9>%n"
                                                                    + "but was:%n"
                                                                    + "   <5>"));
    }
    try {
      assertThat(changes).change().rowAtEndPoint().hasNumberOfColumnsGreaterThan(9);
      fail("An exception must be raised");
    } catch (AssertionError e) {
      Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[Row at end point of Change at index 0 of Changes on 'select * from actor' request of 'sa/jdbc:h2:mem:test' source] %n"
                                                                    + "Expecting size (number of columns) to be greater than :%n"
                                                                    + "   <9>%n"
                                                                    + "but was:%n"
                                                                    + "   <5>"));
    }
    try {
      assertThat(request).hasNumberOfColumnsGreaterThan(9);
      fail("An exception must be raised");
    } catch (AssertionError e) {
      Assertions.assertThat(e.getMessage()).isEqualTo(String.format("['select * from actor' request] %n"
                                                                    + "Expecting size (number of columns) to be greater than :%n"
                                                                    + "   <9>%n"
                                                                    + "but was:%n"
                                                                    + "   <5>"));
    }
    try {
      assertThat(request).row().hasNumberOfColumnsGreaterThan(9);
      fail("An exception must be raised");
    } catch (AssertionError e) {
      Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[Row at index 0 of 'select * from actor' request] %n"
                                                                    + "Expecting size (number of columns) to be greater than :%n"
                                                                    + "   <9>%n"
                                                                    + "but was:%n"
                                                                    + "   <5>"));
    }
  }
}