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 “
compare table “<testdata_name>” with table “<testdata_name>” in SQL database
compare table “<testdata_name>” with table “<testdata_name>” in SQL database
compare table “<testdata_name>” with table “<testdata_name>” in SQL database
Keyword
Given, When, And, Then
Description
Will compare both tables from the single connection of the database.
Declaration
Remarks
- Both “<testdata_name>” instances should be provided in double quotes.
Restriction
- Both tables must exist.
- Last updated on: May 29, 2024
Table of contents