Solitera may collect certain information by automated means, such as cookies and web beacons, when a user visits our website. A “cookie” is a small piece of data that a website can send to your browser, which may then be stored on your system. learn more
Database Operations
- Database Connection StepDef
- SQL Query StepDef
- run query ā
ā - start timer for database
- compare the both databases
- run query ā
ā and verify the text ā ā - compare Function ā
ā with another Function ā ā in SQL Database - compare procedure ā
ā with another procedure ā ā in SQL Database - compare table ā
ā with table ā ā in SQL database - run ā
ā query and verify ā ā text in ā ā column name in the database - run āvar_nameā procedure and verify ā
ā text in ā ā column name in the database - run and verify sensitive data encryption for query ā
ā and column ā ā - wait for ā
ā seconds in database - run āvar_nameā procedure in the database
- create a procedure āvar_nameā with query ā
ā in the database
- run query ā
- Database Verification StepDef
- verify the database connection
- verify āvar_nameā procedure in the database
- verify performance with in ā
ā seconds - user verifies data is not accessible without proper access for query <testdata_name>
- verify that all values in column ā
ā of table ā ā are unique - verify that the values in column ā
ā of table ā ā are within the range ā ā to ā ā - verify that all values in column ā
ā of table ā ā exist in column ā ā of table ā ā - verify that the row count of table ā
ā is ā ā - verify the data values of columns from Excel ā
ā for table ā ā - verify the structure of variables, foreign keys, and primary keys from Excel ā
ā for table ā ā
- No SQL Query StepDef
- verify data with key ā
ā and value ā ā should be updated to ā ā in the ā ā collection in the NoSQL database - verify data with key ā
ā and value ā ā should not exist in the ā ā collection in the NoSQL database - delete the data with key ā
ā and value ā ā from the ā ā collection in the NoSQL database - update the data with key ā
ā and value ā ā in the ā ā collection in the NoSQL database to ā ā - insert data ā
ā & verify it with ā ā collection in NoSQL database - run query document with key ā
ā & value ā ā and verify ā ā key & ā ā value with ā ā collection in NOSQL database
- verify data with key ā
close database connection with “application_name” configuration
close database connection with “application_name” configuration
close database connection with “application_name” configuration
Keyword
Given, When, And, Then
Description
Will close the database connection using the given configuration
Declaration
- Code
- Element
- Application
- Test Data
Then close database connection with "LocalDatabase" configuration
NILL
LocalDatabase
database
MYSQL
8.3.0
jdbc:mysql://localhost:3306
STANDARD
root
root
soliterata
com.mysql.cj.jdbc.Driver
NILL
Remarks
- The “applicationVar_name” should be provided in double quotes and must correspond to a valid configuration.
Restriction
- The configuration details must be defined in the application configuration file.
- Last updated on: May 28, 2024
Table of contents