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 the multi database connections
close the multi database connections
close the multi database connections
Keyword
Given, When, And, Then
Description
Will close the multi database connections in SQL database
Declaration
- Code
- Element
- Application
- Test Data
Then close the multi database connections
NILL
NILL
NILL
Remarks
- Multiple database connections must be previously established.
Restriction
- The method must handle multiple connections appropriately.
- Last updated on: May 28, 2024
Table of contents