Postgres

Type: Relational Database Management System (RDBMS)

Description: Open-source, object-relational database system known for its extensibility and support for various data types. It emphasizes standards compliance and SQL flexibility.

How to send the query

Description

<postgres> – the command which is responsible for sending the queries to Postgres DB in testing scenarios

Required parameters:

comment
alias - unique name of the DB you configured in your integration.xml file
file - specifies the expected file name
query - contains the Postgres DB query

Optional parameters :

condition - condition according to which this test step will or won't be executed
threshold - parameter, where the maximum execution time of the command is defined (milliseconds), if the execution time is exceeded, the step will be defined as failed

<postgres comment="Get all user's from system" alias="ALIAS" file="expected_1.json"> <query>SELECT * FROM t_user</query> </postgres>

Last updated on