MySQL

Type: Relational Database Management System (RDBMS)

Description: Open-source RDBMS widely used for web applications. It is known for its speed, reliability, and ease of use. MySQL supports SQL and is often associated with the LAMP stack.

How to send the query

Description

<mysql> – command which is responsible for sending the queries to mysql 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 MySQL 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

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

Last updated on