top of page

"I saw the kernel and it cried in binary.”

bugreaper-db_compr.png

Module for interaction with Databases

Oparations:

insertIntoTable

 

runScript
runScriptFromFile


truncateTable

truncateTableCascade*
truncateTables


deleteFromTable


updateTable

Asserts:

seeTableIsEmpty

seeTableDoesNotEmpty

seeRecordExistsInTable

seeRecordExistsInTableCustom

seeRowsCountInTableExactly

Report data:

showDataFromTable
showDataByCondition

Configs:

.withAwaitMs(int)
.setTemplateDirectory(String)

Interactions

insertIntoTable

(String tableName, Object[][] templateArray, Object[][] providedArray)

Merge arrays with data for insert into table

wrap this mathod onse for every table

attach: table with merged data,
sql script

insertIntoTable

(String tableName, Object[][] providedArray)

Merge array with template data (in resource file)

resource file path =
templates/{database_type}/{schema}.{table_name}.json

attach: table with merged data,
sql script

insertIntoTable

(String tableName, String providedJson)

Merge JSON with template data (in resource file)

resource file path =
templates/{database_type}/{schema}.{table_name}.json

attach: table with merged data,
sql script

runScript

(String script)

runScriptFromFile

(String path)

truncateTable

(String tableName)

truncateTableCascade*

(String tableName)

only for PostgreSql

truncateTables

(String... tablesNames)

deleteFromTable

(String tableName)

deleteFromTable

(String tableName, Object[][] conditionsArray)

deleteFromTable

(String tableName, String conditions)

updateTable

(String tableName, Object[][] setArray)

updateTable

(String tableName, Object[][] setArray, Object[][] conditionsArray)

updateTable

(String tableName, String conditions)

INFO

IN progress

Info

in progress

INFO

In progress

© 2025 BUGREAPER

bottom of page