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 ā
setup a connection with database1 “applicationVar_name” & database2 “applicationVar_name”
setup a connection with database1 “applicationVar_name” & database2 “applicationVar_name”
setup a connection with database1 “applicationVar_name” & database2 “applicationVar_name”
Keyword
Given, When, And, Then
Description
Will setup a connection for two databases in SQL database
Declaration
- Code
- Element
- Application
- Test Data
Then setup a connection with database1 "applicationVar_name1" & database2 "applicationVar_name2"
NILL
applicationVar_name1
database
MYSQL
8.3.0
jdbc:mysql://localhost:3306
STANDARD
root
root
soliterata
com.mysql.cj.jdbc.Driver
applicationVar_name2
database
MYSQL
8.3.0
jdbc:mysql://localhost:3306
STANDARD
root
root
solite
com.mysql.cj.jdbc.Driver
NILL
Remarks
- The “applicationVar_name” for both databases should be provided in double quotes.
Restriction
- Both configurations must be valid and defined in the application configuration file.
- Last updated on: May 28, 2024
Table of contents