BUGREAPER: module-db

https://bugreaper.net/

Is part of the BugReaper JAVA test helper framework that simplifies SQL-databases interaction in automated tests. It provides easy configuration, convenient APIs for working with SQL-database data, and built-in assertions, allowing you to write readable and maintainable tests with minimal boilerplate.

apiDOC

Wiki

EXAMPLES.md

Requirements:

JAVA >= 17

IMPORTANT! Add the JDBC dependency for the database type you are using (not included in the helper).

for example:

implementation 'org.mariadb.jdbc:mariadb-java-client:2.7.12'

implementation "com.mysql:mysql-connector-j:8.2.0"
implementation "mysql:mysql-connector-java:8.0.33"

implementation 'org.postgresql:postgresql:42.7.1'

implementation 'com.oracle.database.jdbc:ojdbc11:23.2.0.0'

implementation 'com.microsoft.sqlserver:mssql-jdbc:12.4.2.jre11'

Logging:

<logger name="bugreaper-module-db" level="INFO"/>

Tested with:

mcr.microsoft.com/mssql/server:2022-CU26-ubuntu-22.04
mcr.microsoft.com/mssql/server:2025-CU7-ubuntu-22.04

mariadb:10.11.18
mariadb:12.3.2

mysql:8.4.11
mysql:26.7.0

postgres:14.23
postgres:18.4

gvenzl/oracle-xe:21-slim-faststart
gvenzl/oracle-free:23.26.2-slim-faststart

clickhouse/clickhouse-server:25.8
clickhouse/clickhouse-server:26.3.17.56

Real examples here:

• Report-db

• Tests