Author name: Ashish Kumar

Database Operations compare Function “<testdata_name>” with another Function “<testdata_name>” in SQL Database Keyword Given, When, And, Then Description Will compare the both functions and return the result Declaration Code Element Application Test Data Then compare Function “” with another Function “” in SQL Database NILL NILL A B Funtion1 FuntionName1 Funtion2 FuntionName2 Remarks Both “<testdata_name>” instances should be provided in double quotes. Restriction Both functions must exist. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations compare procedure “<testdata_name>” with another procedure “<testdata_name>” in SQL Database</testdata_name></testdata_name> Keyword Given, When, And, Then Description Will compare both procedures and return the result Declaration Code Element Application Test Data Then compare procedure “” with another procedure “” in SQL Database NILL NILL A B Procedure1 ProcedureName1 Procedure2 ProcedureName2 Remarks Both “<testdata_name>” instances should be provided in double quotes. Restriction Both procedures must exist. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations compare table “<testdata_name>” with table “<testdata_name>” in SQL database</testdata_name></testdata_name> Keyword Given, When, And, Then Description Will compare both tables from the single connection of the database. Declaration Code Element Application Test Data Then compare table “” with table “” in SQL database NILL NILL A B Table1 FirstName Table2 LastName Remarks Both “<testdata_name>” instances should be provided in double quotes. Restriction Both tables must exist. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations compare the both databases Keyword Given, When, And, Then Description Will compare both databases. i.e. Schema, Tables, Views and Procedures. Declaration Code Element Application Test Data Then compare the both databases NILL NILL NILL Remarks The databases must be specified correctly. Restriction Both databases must be accessible. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations start timer for database Keyword Given, When, And, Then Description Will start the timer Declaration Code Element Application Test Data Then start timer for database NILL NILL NILL Remarks No specific remarks. Restriction The timer must be implemented correctly. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations wait for “<testdata_name>” seconds in database Keyword Given, When, And, Then Description Will wait for given time in seconds Declaration Code Element Application Test Data Then wait for “” seconds in database NILL NILL A B PerformanceTime 30 Remarks The “<testdata_name>” should be provided in double quotes. Restriction The wait time must be reasonable. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations run and verify sensitive data encryption for query “<testdata_name><testdata_name>” and column “</testdata_name><testdata_name><testdata_name><testdata_name>“</testdata_name></testdata_name> Keyword Given, When, And, Then Description Will run and verify the field is encrypted or not. Declaration Code Element Application Test Data Then run and verify sensitive data encryption for query “” and column “” NILL NILL A B QueryName select * from EmployeName; ColumnName EmployeName Remarks Both “<testdata_name>” instances should be provided in double quotes. Restriction The query must target sensitive data. Table of contents Keyword Description Declaration Remarks Restriction