/**
* 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.impl;
import org.assertj.core.api.Assertions;
import org.assertj.core.api.WritableAssertionInfo;
import org.assertj.db.api.TableAssert;
import org.assertj.db.common.AbstractTest;
import org.assertj.db.type.Table;
import org.junit.Test;
import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import static org.assertj.db.api.Assertions.assertThat;
import static org.junit.Assert.fail;
/**
* Tests on {@link org.assertj.db.api.assertions.impl.AssertionsOnColumnOfChangeEquality} class :
* {@link org.assertj.db.api.assertions.impl.AssertionsOnColumnOfChangeEquality#hasValues(org.assertj.db.api.AbstractAssert, org.assertj.core.api.WritableAssertionInfo, org.assertj.db.type.Value, org.assertj.db.type.Value, String, String)} method.
*
* @author RĂ©gis Pouiller
*
*/
public class AssertionsOnColumnOfChangeEquality_HasValues_Two_String_Test extends AbstractTest {
/**
* This method tests the {@code hasValues} assertion method.
*/
@Test
public void test_has_values() throws Exception {
WritableAssertionInfo info = new WritableAssertionInfo();
Table table = new Table();
TableAssert tableAssert = assertThat(table);
TableAssert tableAssert2 = AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, "test1"), getValue(null,
"test2"),
"test1", "test2");
Assertions.assertThat(tableAssert2).isSameAs(tableAssert);
tableAssert2 = AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, 8), getValue(null, 9),
"8", "9");
Assertions.assertThat(tableAssert2).isSameAs(tableAssert);
tableAssert2 = AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Date.valueOf("2007-12-23")),
getValue(null, Date.valueOf("2002-07-25")),
"2007-12-23", "2002-07-25");
Assertions.assertThat(tableAssert2).isSameAs(tableAssert);
tableAssert2 = AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Time.valueOf("09:01:00")),
getValue(null, Time.valueOf("03:30:05")),
"09:01", "03:30:05");
Assertions.assertThat(tableAssert2).isSameAs(tableAssert);
tableAssert2 = AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Timestamp.valueOf("2007-12-23 09:01:00")),
getValue(null, Timestamp.valueOf("2002-07-25 03:30:05")),
"2007-12-23T09:01", "2002-07-25T03:30:05");
Assertions.assertThat(tableAssert2).isSameAs(tableAssert);
}
/**
* This method should fail because the value at start point is different.
*/
@Test
public void should_fail_because_value_at_start_point_is_different() throws Exception {
WritableAssertionInfo info = new WritableAssertionInfo();
info.description("description");
Table table = new Table();
TableAssert tableAssert = assertThat(table);
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, "test1"), getValue(null, "test2"),
"test2", "test2");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that start point:%n"
+ " <\"test1\">%n"
+ "to be equal to: %n"
+ " <\"test2\">"));
}
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, 8), getValue(null, 9),
"9", "9");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that start point:%n"
+ " <\"8\">%n"
+ "to be equal to: %n"
+ " <\"9\">"));
}
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Date.valueOf("2007-12-23")),
getValue(null, Date.valueOf("2002-07-25")),
"2002-07-25", "2002-07-25");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that start point:%n"
+ " <\"2007-12-23\">%n"
+ "to be equal to: %n"
+ " <\"2002-07-25\">"));
}
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Time.valueOf("09:01:00")),
getValue(null, Time.valueOf("03:30:05")),
"03:30:05", "03:30:05");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that start point:%n"
+ " <\"09:01:00.000000000\">%n"
+ "to be equal to: %n"
+ " <\"03:30:05\">"));
}
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Timestamp.valueOf("2007-12-23 09:01:00")),
getValue(null, Timestamp.valueOf("2002-07-25 03:30:05")),
"2002-07-25T03:30:05", "2002-07-25T03:30:05");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that start point:%n"
+ " <\"2007-12-23T09:01:00.000000000\">%n"
+ "to be equal to: %n"
+ " <\"2002-07-25T03:30:05\">"));
}
}
/**
* This method should fail because the value at end point is different.
*/
@Test
public void should_fail_because_value_at_end_point_is_different() throws Exception {
WritableAssertionInfo info = new WritableAssertionInfo();
info.description("description");
Table table = new Table();
TableAssert tableAssert = assertThat(table);
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, "test1"), getValue(null, "test1"),
"test1", "test2");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that end point:%n"
+ " <\"test1\">%n"
+ "to be equal to: %n"
+ " <\"test2\">"));
}
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, 8), getValue(null, 8),
"8", "9");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that end point:%n"
+ " <\"8\">%n"
+ "to be equal to: %n"
+ " <\"9\">"));
}
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Date.valueOf("2007-12-23")),
getValue(null, Date.valueOf("2002-07-26")),
"2007-12-23", "2002-07-25");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that end point:%n"
+ " <\"2002-07-26\">%n"
+ "to be equal to: %n"
+ " <\"2002-07-25\">"));
}
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Time.valueOf("09:01:00")),
getValue(null, Time.valueOf("03:30:06")),
"09:01", "03:30:05");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that end point:%n"
+ " <\"03:30:06.000000000\">%n"
+ "to be equal to: %n"
+ " <\"03:30:05\">"));
}
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, Timestamp.valueOf("2007-12-23 09:01:00")),
getValue(null, Timestamp.valueOf("2002-07-25 03:30:06")),
"2007-12-23T09:01", "2002-07-25T03:30:05");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that end point:%n"
+ " <\"2002-07-25T03:30:06.000000000\">%n"
+ "to be equal to: %n"
+ " <\"2002-07-25T03:30:05\">"));
}
}
/**
* This method should fail because one of the values is not a text.
*/
@Test
public void should_fail_because_one_value_is_not_a_text() throws Exception {
WritableAssertionInfo info = new WritableAssertionInfo();
info.description("description");
Table table = new Table();
TableAssert tableAssert = assertThat(table);
try {
AssertionsOnColumnOfChangeEquality.hasValues(tableAssert, info,
getValue(null, false), getValue(null, "test2"),
"test1", "test2");
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage()).isEqualTo(String.format("[description] %n"
+ "Expecting that the value at start point:%n"
+ " <false>%n"
+ "to be of type%n"
+ " <[TEXT, NUMBER, DATE, TIME, DATE_TIME, UUID, NOT_IDENTIFIED]>%n"
+ "but was of type%n"
+ " <BOOLEAN>"));
}
}
}