Home

DBTestCompare

Application to compare results of two SQL queries

It reads tests definitions in XML format form specified directory and than runs them (as TestNG test). If two SQL returns different results -> test fails. Application supports TeamCity Service Messages (##teamcity messages) so if teamcityLogsEnabled is set to "true" (config file or command line parameter), you will see nice test tree in TeamCity logs.

To execute tests run program:

java -jar DBTestCompare-1.0-SNAPSHOT-jar-with-dependencies.jar

Program searches for tests definitions by default in folder "test-definitions". JDBC drivers must be present in "jdbc_drivers" folder. Licensed database drivers are NOT included, only open source like MySQL, MariaDB and PostgreSQL. Download licensed database drivers from the producer of database e.g. Microsoft and put them in "jdbc_drivers" folder (on the same level as *.jar file).

You can override some of the application configuration properties, run app with:

-DtestsDir=path -set tests directory (default: test-definitions)

-DteamcityLogsEnabled=true -log test output in TeamCity format

-DfilterInclude=a.b,g.z.f -comma separated directories or test files which you want to include

-DfilterExclude=a.b.test -comma separated directories or test files which you want to exclude

for example:

java -DtestsDir=my_tests -jar DBTestCompare-1.0-SNAPSHOT-jar-with-dependencies.jar

Provided features are listed in README file.

Where to start?

---

• See Getting started.