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 ā
verify the data values of columns from Excel “<testdata_name>” for table “<testdata_name>”
verify the data values of columns from Excel “<testdata_name>” for table “<testdata_name>”
verify the data values of columns from Excel “<testdata_name>” for table “<testdata_name>”
Keyword
Given, When, And, Then
Description
Will compares the data values in the specified columns from the Excel file with the corresponding data in the specified database table to ensure they match.
Declaration
- Code
- Element
- Application
- Test Data
Then verify the data values of columns from Excel "" for table ""
NILL
NILL
Remarks
- Both Excel file and table names must be valid.
Restriction
- The Excel file and table must exist.
- Last updated on: May 29, 2024
Table of contents