assertj-db数据库测试利器之datasource

折腾assertj-db

1. assertj-db官网地址
2. 项目添加maven|gradle依赖即可使用

<!-- https://mvnrepository.com/artifact/org.assertj/assertj-db -->
<dependency>
    <groupId>org.assertj</groupId>
    <artifactId>assertj-db</artifactId>
    <version>1.1.1</version>
</dependency>

assert db 原理

• 第一步：assertj-db接入操作我们操作数据库的源，如：MysqlDataSource,mybatis的datasource建议结合spring使用。

Request request = new Request(datasource) or
Changes changes = new Changes(datasource)

• 第二步：assertj-db记录操作过程中所有改变
• 第三步：assertThat(request|changes)...

one case

        mysqlDataSource = new MysqlDataSource();
        mysqlDataSource.setURL("jdbc:mysql://127.0.0.1:3306/testassertdb?characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull");
        mysqlDataSource.setDatabaseName("testassertdb");
        mysqlDataSource.setUser("root");
        mysqlDataSource.setPassword("root");
        Changes changes = new Changes(mysqlDataSource);
        Table table = new Table(mysqlDataSource, "persons");
        changes.setTables(table);
        changes.setStartPointNow();
        makeChanges();
        changes.setEndPointNow();
        assertThat(changes).hasNumberOfChanges(2);

转载于:https://my.oschina.net/heli/blog/1611049