/**
* 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.output;
import org.assertj.core.api.Assertions;
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 java.io.ByteArrayOutputStream;
import static org.assertj.db.output.Outputs.output;
/**
* Test the output of values.
*
* @author Régis Pouiller
*/
public class OutputterValue_Test extends AbstractTest {
/**
* This method tests the {@code output} output method.
*/
@Test
public void test_output_for_row_from_table() throws Exception {
Table table = new Table(source, "actor");
ByteArrayOutputStream byteArrayOutputStream0 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream1 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream2 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream3 = new ByteArrayOutputStream();
Outputs.output(table).row().value().toStream(byteArrayOutputStream0).returnToRow()
.value(1).toStream(byteArrayOutputStream1)
.value().toStream(byteArrayOutputStream2)
.row(2).value(2).toStream(byteArrayOutputStream3);
Assertions.assertThat(byteArrayOutputStream0.toString()).isEqualTo(String.format("[Value at index 0 (column name : ID) of Row at index 0 of ACTOR table]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 1 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream1.toString()).isEqualTo(String.format("[Value at index 1 (column name : NAME) of Row at index 0 of ACTOR table]%n"
+ "|--------|%n"
+ "| NAME |%n"
+ "| (TEXT) |%n"
+ "|--------|%n"
+ "| Weaver |%n"
+ "|--------|%n"));
Assertions.assertThat(byteArrayOutputStream2.toString()).isEqualTo(String.format("[Value at index 2 (column name : FIRSTNAME) of Row at index 0 of ACTOR table]%n"
+ "|-----------|%n"
+ "| FIRSTNAME |%n"
+ "| (TEXT) |%n"
+ "|-----------|%n"
+ "| Sigourney |%n"
+ "|-----------|%n"));
Assertions.assertThat(byteArrayOutputStream3.toString()).isEqualTo(String.format("[Value at index 2 (column name : FIRSTNAME) of Row at index 2 of ACTOR table]%n"
+ "|-----------|%n"
+ "| FIRSTNAME |%n"
+ "| (TEXT) |%n"
+ "|-----------|%n"
+ "| Sam |%n"
+ "|-----------|%n"));
}
/**
* This method tests the {@code output} output method.
*/
@Test
public void test_output_for_row_from_request() throws Exception {
Request request = new Request(source, "select * from actor");
ByteArrayOutputStream byteArrayOutputStream0 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream1 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream2 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream3 = new ByteArrayOutputStream();
Outputs.output(request).row().value().toStream(byteArrayOutputStream0).returnToRow()
.value(1).toStream(byteArrayOutputStream1)
.value().toStream(byteArrayOutputStream2)
.row(2).value(2).toStream(byteArrayOutputStream3);
Assertions.assertThat(byteArrayOutputStream0.toString()).isEqualTo(String.format("[Value at index 0 (column name : ID) of Row at index 0 of 'select * from actor' request]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 1 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream1.toString()).isEqualTo(String.format("[Value at index 1 (column name : NAME) of Row at index 0 of 'select * from actor' request]%n"
+ "|--------|%n"
+ "| NAME |%n"
+ "| (TEXT) |%n"
+ "|--------|%n"
+ "| Weaver |%n"
+ "|--------|%n"));
Assertions.assertThat(byteArrayOutputStream2.toString()).isEqualTo(String.format("[Value at index 2 (column name : FIRSTNAME) of Row at index 0 of 'select * from actor' request]%n"
+ "|-----------|%n"
+ "| FIRSTNAME |%n"
+ "| (TEXT) |%n"
+ "|-----------|%n"
+ "| Sigourney |%n"
+ "|-----------|%n"));
Assertions.assertThat(byteArrayOutputStream3.toString()).isEqualTo(String.format("[Value at index 2 (column name : FIRSTNAME) of Row at index 2 of 'select * from actor' request]%n"
+ "|-----------|%n"
+ "| FIRSTNAME |%n"
+ "| (TEXT) |%n"
+ "|-----------|%n"
+ "| Sam |%n"
+ "|-----------|%n"));
}
/**
* This method tests the {@code output} output method.
*/
@Test
@NeedReload
public void test_output_for_row_from_change() throws Exception {
Changes changes = new Changes(source).setStartPointNow();
updateChangesForTests();
changes.setEndPointNow();
ByteArrayOutputStream byteArrayOutputStream0 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream1 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream2 = new ByteArrayOutputStream();
output(changes).change().rowAtEndPoint().value().toStream(byteArrayOutputStream0)
.changeOfModification().rowAtStartPoint().value().toStream(byteArrayOutputStream1)
.rowAtEndPoint().value().toStream(byteArrayOutputStream2);
Assertions.assertThat(byteArrayOutputStream0.toString()).isEqualTo(String.format("[Value at index 0 (column name : ID) of Row at end point of Change at index 0 (on table : ACTOR and with primary key : [4]) of Changes on tables of 'sa/jdbc:h2:mem:test' source]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 4 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream1.toString()).isEqualTo(String.format("[Value at index 0 (column name : ID) of Row at start point of Change at index 0 (on table : ACTOR and with primary key : [1]) of Changes on tables of 'sa/jdbc:h2:mem:test' source (only modification changes)]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 1 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream2.toString()).isEqualTo(String.format("[Value at index 0 (column name : ID) of Row at end point of Change at index 0 (on table : ACTOR and with primary key : [1]) of Changes on tables of 'sa/jdbc:h2:mem:test' source (only modification changes)]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 1 |%n"
+ "|----------|%n"));
}
/**
* This method tests the {@code output} output method.
*/
@Test
public void test_output_for_column_from_table() throws Exception {
Table table = new Table(source, "actor");
ByteArrayOutputStream byteArrayOutputStream0 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream1 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream2 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream3 = new ByteArrayOutputStream();
Outputs.output(table).column().value().toStream(byteArrayOutputStream0).returnToColumn()
.value(1).toStream(byteArrayOutputStream1)
.value().toStream(byteArrayOutputStream2)
.column("name").value(2).toStream(byteArrayOutputStream3);
Assertions.assertThat(byteArrayOutputStream0.toString()).isEqualTo(String.format("[Value at index 0 of Column at index 0 (column name : ID) of ACTOR table]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 1 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream1.toString()).isEqualTo(String.format("[Value at index 1 of Column at index 0 (column name : ID) of ACTOR table]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 2 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream2.toString()).isEqualTo(String.format("[Value at index 2 of Column at index 0 (column name : ID) of ACTOR table]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 3 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream3.toString()).isEqualTo(String.format("[Value at index 2 of Column at index 1 (column name : NAME) of ACTOR table]%n"
+ "|-------------|%n"
+ "| NAME |%n"
+ "| (TEXT) |%n"
+ "|-------------|%n"
+ "| Worthington |%n"
+ "|-------------|%n"));
}
/**
* This method tests the {@code output} output method.
*/
@Test
public void test_output_for_column_from_request() throws Exception {
Request request = new Request(source, "select * from actor");
ByteArrayOutputStream byteArrayOutputStream0 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream1 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream2 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream3 = new ByteArrayOutputStream();
Outputs.output(request).column().value().toStream(byteArrayOutputStream0).returnToColumn()
.value(1).toStream(byteArrayOutputStream1)
.value().toStream(byteArrayOutputStream2)
.column("name").value(2).toStream(byteArrayOutputStream3);
Assertions.assertThat(byteArrayOutputStream0.toString()).isEqualTo(String.format(
"[Value at index 0 of Column at index 0 (column name : ID) of 'select * from actor' request]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 1 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream1.toString()).isEqualTo(String.format("[Value at index 1 of Column at index 0 (column name : ID) of 'select * from actor' request]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 2 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream2.toString()).isEqualTo(String.format("[Value at index 2 of Column at index 0 (column name : ID) of 'select * from actor' request]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 3 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream3.toString()).isEqualTo(String.format("[Value at index 2 of Column at index 1 (column name : NAME) of 'select * from actor' request]%n"
+ "|-------------|%n"
+ "| NAME |%n"
+ "| (TEXT) |%n"
+ "|-------------|%n"
+ "| Worthington |%n"
+ "|-------------|%n"));
}
/**
* This method tests the {@code output} output method.
*/
@Test
@NeedReload
public void test_output_for_column_from_change() throws Exception {
Changes changes = new Changes(source).setStartPointNow();
updateChangesForTests();
changes.setEndPointNow();
ByteArrayOutputStream byteArrayOutputStream0 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream1 = new ByteArrayOutputStream();
ByteArrayOutputStream byteArrayOutputStream2 = new ByteArrayOutputStream();
output(changes).change().column().valueAtStartPoint().toStream(byteArrayOutputStream0)
.valueAtEndPoint().toStream(byteArrayOutputStream1)
.column().valueAtEndPoint().toStream(byteArrayOutputStream2);
Assertions.assertThat(byteArrayOutputStream0.toString()).isEqualTo(String.format("[Value at start point of Column at index 0 (column name : ID) of Change at index 0 (on table : ACTOR and with primary key : [4]) of Changes on tables of 'sa/jdbc:h2:mem:test' source]%n"
+ "|------------------|%n"
+ "| ID |%n"
+ "| (NOT_IDENTIFIED) |%n"
+ "|------------------|%n"
+ "| null |%n"
+ "|------------------|%n"));
Assertions.assertThat(byteArrayOutputStream1.toString()).isEqualTo(String.format("[Value at end point of Column at index 0 (column name : ID) of Change at index 0 (on table : ACTOR and with primary key : [4]) of Changes on tables of 'sa/jdbc:h2:mem:test' source]%n"
+ "|----------|%n"
+ "| ID |%n"
+ "| (NUMBER) |%n"
+ "|----------|%n"
+ "| 4 |%n"
+ "|----------|%n"));
Assertions.assertThat(byteArrayOutputStream2.toString()).isEqualTo(String.format("[Value at end point of Column at index 1 (column name : NAME) of Change at index 0 (on table : ACTOR and with primary key : [4]) of Changes on tables of 'sa/jdbc:h2:mem:test' source]%n"
+ "|--------|%n"
+ "| NAME |%n"
+ "| (TEXT) |%n"
+ "|--------|%n"
+ "| Murray |%n"
+ "|--------|%n"));
}
}