Request_Rows_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.junit.Test;

import java.math.BigDecimal;

import static org.assertj.core.api.Assertions.assertThat;

/**
 * Tests on the {@code Row} of {@code Request}.
 * <p>
 * These tests are on the values in the {@code Row} got from a {@code Request}.
 * </p>
 * 
 * @author Régis Pouiller
 * 
 */
public class Request_Rows_Test extends AbstractTest {

  /**
   * This method test the rows got from a {@code Source}.
   */
  @Test
  public void test_rows_with_source_set() {
    Request request = new Request(source, "SELECT actor.name, actor.firstname, movie.year, interpretation.character "
        + " FROM movie, actor, interpretation"
        + " WHERE movie.id = interpretation.id_movie"
        + " AND interpretation.id_actor = actor.id"
        + " ORDER BY actor.name, movie.year");

    assertThat(request.getRowsList()).as("Values of the request")
        .hasSize(5);

    assertThat(request.getRow(0).getColumnsNameList()).containsExactly("NAME", "FIRSTNAME", "YEAR", "CHARACTER");
    assertThat(request.getRow(0).getColumnValue(0).getValue()).isEqualTo("Phoenix");
    assertThat(request.getRow(0).getColumnValue("firstName").getValue()).isEqualTo("Joaquim");

    assertThat(request.getRow(0).getValuesList().get(0).getValue()).isEqualTo("Phoenix");
    assertThat(request.getRow(0).getValuesList().get(1).getValue()).isEqualTo("Joaquim");
    assertThat(request.getRow(0).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(2004));
    assertThat(request.getRow(0).getValuesList().get(3).getValue()).isEqualTo("Lucius Hunt");
    assertThat(request.getRow(1).getValuesList().get(0).getValue()).isEqualTo("Weaver");
    assertThat(request.getRow(1).getValuesList().get(1).getValue()).isEqualTo("Sigourney");
    assertThat(request.getRow(1).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(1979));
    assertThat(request.getRow(1).getValuesList().get(3).getValue()).isEqualTo("Ellen Louise Ripley");
    assertThat(request.getRow(2).getValuesList().get(0).getValue()).isEqualTo("Weaver");
    assertThat(request.getRow(2).getValuesList().get(1).getValue()).isEqualTo("Sigourney");
    assertThat(request.getRow(2).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(2004));
    assertThat(request.getRow(2).getValuesList().get(3).getValue()).isEqualTo("Alice Hunt");
    assertThat(request.getRow(3).getValuesList().get(0).getValue()).isEqualTo("Weaver");
    assertThat(request.getRow(3).getValuesList().get(1).getValue()).isEqualTo("Sigourney");
    assertThat(request.getRow(3).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(2009));
    assertThat(request.getRow(3).getValuesList().get(3).getValue()).isEqualTo("Dr Grace Augustine");
    assertThat(request.getRow(4).getValuesList().get(0).getValue()).isEqualTo("Worthington");
    assertThat(request.getRow(4).getValuesList().get(1).getValue()).isEqualTo("Sam");
    assertThat(request.getRow(4).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(2009));
    assertThat(request.getRow(4).getValuesList().get(3).getValue()).isEqualTo("Jake Sully");
  }

  /**
   * This method test the rows got from a {@code DataSource}.
   */
  @Test
  public void test_rows_with_datasource_set() {
    Request request = new Request(dataSource, "SELECT actor.name, actor.firstname, movie.year, interpretation.character "
        + " FROM movie, actor, interpretation"
        + " WHERE movie.id = interpretation.id_movie"
        + " AND interpretation.id_actor = actor.id"
        + " ORDER BY actor.name, movie.year");

    assertThat(request.getRowsList()).as("Values of the request")
        .hasSize(5);
    assertThat(request.getRow(0).getValuesList().get(0).getValue()).isEqualTo("Phoenix");
    assertThat(request.getRow(0).getValuesList().get(1).getValue()).isEqualTo("Joaquim");
    assertThat(request.getRow(0).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(2004));
    assertThat(request.getRow(0).getValuesList().get(3).getValue()).isEqualTo("Lucius Hunt");
    assertThat(request.getRow(1).getValuesList().get(0).getValue()).isEqualTo("Weaver");
    assertThat(request.getRow(1).getValuesList().get(1).getValue()).isEqualTo("Sigourney");
    assertThat(request.getRow(1).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(1979));
    assertThat(request.getRow(1).getValuesList().get(3).getValue()).isEqualTo("Ellen Louise Ripley");
    assertThat(request.getRow(2).getValuesList().get(0).getValue()).isEqualTo("Weaver");
    assertThat(request.getRow(2).getValuesList().get(1).getValue()).isEqualTo("Sigourney");
    assertThat(request.getRow(2).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(2004));
    assertThat(request.getRow(2).getValuesList().get(3).getValue()).isEqualTo("Alice Hunt");
    assertThat(request.getRow(3).getValuesList().get(0).getValue()).isEqualTo("Weaver");
    assertThat(request.getRow(3).getValuesList().get(1).getValue()).isEqualTo("Sigourney");
    assertThat(request.getRow(3).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(2009));
    assertThat(request.getRow(3).getValuesList().get(3).getValue()).isEqualTo("Dr Grace Augustine");
    assertThat(request.getRow(4).getValuesList().get(0).getValue()).isEqualTo("Worthington");
    assertThat(request.getRow(4).getValuesList().get(1).getValue()).isEqualTo("Sam");
    assertThat(request.getRow(4).getValuesList().get(2).getValue()).isEqualTo(new BigDecimal(2009));
    assertThat(request.getRow(4).getValuesList().get(3).getValue()).isEqualTo("Jake Sully");
  }

  /**
   * This method should throw a {@code NullPointerException} because of calling {@code getColumnValue} with null in parameter.
   */
  @Test(expected = NullPointerException.class)
  public void should_throw_NullPointerException_because_column_name_parameter_is_null_when_calling_getColumnValue() {
    Request request = new Request(dataSource, "SELECT actor.name, actor.firstname, movie.year, interpretation.character "
        + " FROM movie, actor, interpretation"
        + " WHERE movie.id = interpretation.id_movie"
        + " AND interpretation.id_actor = actor.id"
        + " ORDER BY actor.name, movie.year");
    request.getRow(0).getColumnValue(null);
  }

  /**
   * This method test that the call to {@code getColumnValue} return null when the column name in parameter don't exist.
   */
  @Test
  public void test_that_we_get_null_when_calling_getColumnValue_and_the_column_name_dont_exist() {
    Request request = new Request(dataSource, "SELECT actor.name, actor.firstname, movie.year, interpretation.character "
        + " FROM movie, actor, interpretation"
        + " WHERE movie.id = interpretation.id_movie"
        + " AND interpretation.id_actor = actor.id"
        + " ORDER BY actor.name, movie.year");
    assertThat(request.getRow(0).getColumnValue("not_exist")).isNull();
  }

}