/** This method should fail because the value is no close to. */
@Test
@NeedReload
public void should_fail_because_value_is_not_close_to() {
Table table = new Table(source, "test");
Changes changes = new Changes(table).setStartPointNow();
update("update test set var14 = 1 where var1 = 1");
changes.setEndPointNow();
try {
assertThat(changes)
.change()
.column("var10")
.valueAtEndPoint()
.isCloseTo(
DateTimeValue.of(DateValue.of(2014, 5, 24), TimeValue.of(9, 46, 31)),
TimeValue.of(0, 0, 0, 1));
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage())
.isEqualTo(
String.format(
"[Value at end point of Column at index 9 (column name : VAR10) of Change at index 0 (with primary key : [1]) of Changes on TEST table of 'sa/jdbc:h2:mem:test' source] %n"
+ "Expecting:%n"
+ " <2014-05-24T09:46:30.000000000>%n"
+ "to be close to: %n"
+ " <2014-05-24T09:46:31.000000000> %n"
+ " with tolerance <00:00:00.000000001>"));
}
try {
assertThat(table)
.column("var10")
.value()
.isCloseTo(
DateTimeValue.of(DateValue.of(2014, 5, 24), TimeValue.of(9, 46, 31)),
TimeValue.of(0, 0, 0, 100));
fail("An exception must be raised");
} catch (AssertionError e) {
Assertions.assertThat(e.getMessage())
.isEqualTo(
String.format(
"[Value at index 0 of Column at index 9 (column name : VAR10) of TEST table] %n"
+ "Expecting:%n"
+ " <2014-05-24T09:46:30.000000000>%n"
+ "to be close to: %n"
+ " <2014-05-24T09:46:31.000000000> %n"
+ " with tolerance <00:00:00.000000100>"));
}
}
/** This method tests the {@code isCloseTo} assertion method. */
@Test
@NeedReload
public void test_is_close_to() {
Table table = new Table(source, "test");
Changes changes = new Changes(table).setStartPointNow();
update("update test set var14 = 1 where var1 = 1");
changes.setEndPointNow();
ChangeColumnValueAssert changeColumnValueAssert =
assertThat(changes).change().column("var10").valueAtEndPoint();
ChangeColumnValueAssert changeColumnValueAssert2 =
changeColumnValueAssert.isCloseTo(
DateTimeValue.of(DateValue.of(2014, 5, 24), TimeValue.of(9, 46, 30)),
TimeValue.of(0, 0, 0));
Assertions.assertThat(changeColumnValueAssert).isSameAs(changeColumnValueAssert2);
TableColumnValueAssert tableColumnValueAssert = assertThat(table).column("var10").value();
TableColumnValueAssert tableColumnValueAssert2 =
tableColumnValueAssert.isCloseTo(
DateTimeValue.of(DateValue.of(2014, 5, 24), TimeValue.of(9, 46, 30)),
TimeValue.of(0, 0, 0));
Assertions.assertThat(tableColumnValueAssert).isSameAs(tableColumnValueAssert2);
}