30 lines (26 loc) · 706 Bytes

Db Checker Usage

Add dependency

<dependency>
    <groupId>ua.ardas</groupId>
    <artifactId>db-test-utils</artifactId>
    <version>${db-test-utils.version}</version>
    <scope>test</scope>
</dependency>

Use DbChecker in tests

@Autowired
private DbChecker dbChecker;

@Test
public void check_contacts_row() {
    dbChecker.checkDb(
        new CheckerExpectedData()
            .addRow("1", "test@example.com")
            .addRow("2", CheckerExpectedData.NULL),
        "select ContactId, Email from dbo.Contacts where ContactId in (?, ?)",
        1, 2
    );
}

Expected data can be created either via new CheckerExpectedData() or new DbChecker.ExpectedData().