/** 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 should fail because the number of modified columns is greater or equal. */ @Test public void should_fail_because_number_of_modified_columns_is_greater_or_equal() throws Exception { WritableAssertionInfo info = new WritableAssertionInfo(); info.description("description"); Table table = new Table(); TableAssert tableAssert = assertThat(table); Row rowAtStartPoint = getRow( null, Arrays.asList("ID", "NAME", "FIRSTNAME", "BIRTH"), Arrays.asList( getValue(null, 1), getValue(null, "Weaver"), getValue(null, "Sigourney"), getValue(null, Date.valueOf("1949-10-08")))); Row rowAtEndPoint = getRow( null, Arrays.asList("ID", "NAME", "FIRSTNAME", "BIRTH"), Arrays.asList( getValue(null, 1), getValue(null, "Weaverr"), getValue(null, "Sigourneyy"), getValue(null, Date.valueOf("1949-10-08")))); Change change = getChange(DataType.TABLE, "test", ChangeType.MODIFICATION, rowAtStartPoint, rowAtEndPoint); try { AssertionsOnModifiedColumns.hasNumberOfModifiedColumnsLessThan(tableAssert, info, change, 1); fail("An exception must be raised"); } catch (AssertionError e) { Assertions.assertThat(e.getMessage()) .isEqualTo( String.format( "[description] %n" + "Expecting :%n" + " number of modifications is less than 1%n" + "but was:%n" + " 2")); } }