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 ā
insert the data from Excel “<testdata_name>” into the database table “<testdata_name>”
insert the data from Excel “<testdata_name>” into the database table “<testdata_name>”
insert the data from Excel “<testdata_name>” into the database table “<testdata_name>”
Keyword
Given, When, And, Then
Description
Will inserts data from the specified Excel file into the specified database table.
Declaration
- Code
- Element
- Application
- Test Data
Then insert the data from Excel "" into the database table ""
NILL
NILL
Remarks
- Both Excel file and table names must be valid.
Restriction
- The Excel file and table must exist.
- Last updated on: June 4, 2024
Table of contents