SQL Query StepDef

Database Operations 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 A B ExcelName Company TableName EmployeName Remarks Both Excel file and table names must be valid. Restriction The Excel file and table must exist. Table of contents Keyword Description Declaration Remarks Restriction

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

Database Operations run “<testdata_name><testdata_name> “procedure in the database</testdata_name> Keyword Given, When, And, Then Description Will run the procedure in SQL database Declaration Code Element Application Test Data Then run “Procedure_Name” procedure in the database NILL NILL A B Procedure_Name Procedure1 Remarks The “<testdata_name>” should be provided in double quotes. Restriction The procedure must exist in the database. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations run “var_name” procedure and verify “<testdata_name>” text in “<testdata_name>” column name in the database Keyword Given, When, And, Then Description Will run the procedure and verify the output from the column name in SQL Database. Declaration Code Element Application Test Data Then run “Procedure1” procedure and verify “” text in “” column name in the database NILL NILL A B RequiredText Solitera RequiredColumnName EFname Remarks All “<testdata_name>” instances should be provided in double quotes. Restriction The procedure, verification text, and column name must be valid. Table of contents Keyword Description Declaration Remarks Restriction