Package net.bugreaper.modules.db

Class PostgreSQL

java.lang.Object

net.bugreaper.modules.db.jdbc.JdbcExecutor<PostgreSQL>

net.bugreaper.modules.db.PostgreSQL

All Implemented Interfaces:

SqlConfig<PostgreSQL>, SqlGet, SqlPost

public class PostgreSQL
extends JdbcExecutor<PostgreSQL>

Class for interacting with PostgreSQL

For one instance run recommended: PostgreSQL db = PostgreSQL.getInstance()

Contains methods for:

asserts with await, change data (create, update, clean)
more info JdbcExecutor

Field Summary

Fields

Modifier and Type	Field	Description
protected static final String	COUNT
protected String	getColumnsQuery
protected JdbcDirectivesHikari	jdbc
protected String	password
protected static final String	SELECT_ALL
protected String	url
protected String	username

Constructor Summary

Constructors

Constructor	Description
PostgreSQL()	Constructs PostgreSQL client configuration.
PostgreSQL(String dbUrl, String username, String passwd)	Creates a new PostgreSQL database helper instance with the specified connection parameters.

Method Summary

Modifier and Type	Method	Description
protected void	assertCountInTableBuilder(String tableName, String conditions, Object[][] conditionsArray, String expectedCount, int awaitMs)
static PostgreSQL	getInstance()	Returns the singleton instance of PostgreSQL with config builder PostgreSQL().
protected String[]	getTableColumns(String tableName)	Get array with table column list
protected void	recordExistsBuilder(String tableName, String conditions, Object[][] conditionsArray, int awaitMs)
void	renameTable(String tableName)	Rename table(add suffix "_X_")
void	rollbackTable(String tableName)	Rollback table(remove suffix "_X_") after SqlPost.renameTable(java.lang.String)
protected void	seeInDbByCondMethod(String tableName, String conditions)
protected void	showDataFromTableMethod(String tableName)
void	truncateTableCascade(String tableName)	Truncate(clean) table and all connected by foreign keys tables

Methods inherited from class net.bugreaper.modules.db.jdbc.JdbcExecutor

deleteFromTable, deleteFromTable, deleteFromTable, getConfigSummary, insertIntoTable, insertIntoTable, insertIntoTable, runScript, runScriptFromFile, seeRecordExistsInTable, seeRecordExistsInTable, seeRecordExistsInTableCustom, seeRowsCountInTableExactly, seeRowsCountInTableExactly, seeRowsCountInTableExactly, seeRowsCountInTableExactlyCustom, seeTableDoesNotEmpty, seeTableIsEmpty, self, setAwaitMs, setTemplatesDirectory, showDataByCondition, showDataFromTable, truncateTable, truncateTables, updateTable, updateTable, updateTable, withAwaitMs

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

jdbc

protected JdbcDirectivesHikari jdbc

getColumnsQuery

protected String getColumnsQuery

url

protected String url

username

protected String username

password

protected String password

SELECT_ALL

protected static final String SELECT_ALL

See Also:

• Constant Field Values

COUNT

protected static final String COUNT

See Also:

• Constant Field Values

Constructor Details

PostgreSQL

public PostgreSQL(String dbUrl,
 String username,
 String passwd)

Creates a new PostgreSQL database helper instance with the specified connection parameters.

Parameters:

dbUrl - the JDBC connection URL for the PostgreSQL database

username - the username used to authenticate with the database

passwd - the password used to authenticate with the database

Throws:

IllegalArgumentException - if any of the required parameters are null or empty

PostgreSQL

public PostgreSQL()

Constructs PostgreSQL client configuration.

Loads configuration values from a YAML file.

more info JdbcExecutor(String dbType, String getColumnsQuery)

Method Details

getInstance

public static PostgreSQL getInstance()

Returns the singleton instance of PostgreSQL with config builder PostgreSQL().

This implementation is thread-safe using method-level synchronization.

Returns:

the singleton instance of PostgreSQL

truncateTableCascade

@Step("Truncate table {tableName} CASCADE")
public void truncateTableCascade(String tableName)

Truncate(clean) table and all connected by foreign keys tables

Parameters:

tableName - schema_name.table_name

renameTable

@Step("Rename table {tableName}")
public void renameTable(String tableName)

Description copied from interface: SqlPost

Rename table(add suffix "_X_")

Note: After test rollback with SqlPost.rollbackTable(java.lang.String).

Specified by:

renameTable in interface SqlPost

Overrides:

renameTable in class JdbcExecutor<PostgreSQL>

Parameters:

tableName - schema_name.table_name

rollbackTable

@Step("Rollback table {tableName}")
public void rollbackTable(String tableName)

Description copied from interface: SqlPost

Rollback table(remove suffix "_X_") after SqlPost.renameTable(java.lang.String)

Specified by:

rollbackTable in interface SqlPost

Overrides:

rollbackTable in class JdbcExecutor<PostgreSQL>

Parameters:

tableName - schema_name.table_name

assertCountInTableBuilder

@Step("(DB)[ASSERT] Count records in {tableName} {conditions} EQUAL {expectedCount}")
protected void assertCountInTableBuilder(String tableName,
 String conditions,
 @Param(mode=HIDDEN)
 Object[][] conditionsArray,
 String expectedCount,
 @Param(mode=HIDDEN)
 int awaitMs)

recordExistsBuilder

@Step("(DB)[ASSERT] Record/s exists in {tableName} {conditions}")
protected void recordExistsBuilder(String tableName,
 String conditions,
 @Param(mode=HIDDEN)
 Object[][] conditionsArray,
 @Param(mode=HIDDEN)
 int awaitMs)

showDataFromTableMethod

protected void showDataFromTableMethod(String tableName)

seeInDbByCondMethod

@Step("(DB)[ASSERT] Records exists in {tableName}: {conditions}")
protected void seeInDbByCondMethod(String tableName,
 String conditions)

getTableColumns

protected String[] getTableColumns(String tableName)

Get array with table column list

Parameters:

tableName - table name

Returns:

Strings... with columns names