Database Verification StepDef

Database Operations verify the structure of variables, foreign keys, and primary keys from Excel “<testdata_name>” for table “<testdata_name>” Keyword Given, When, And, Then Description Will checks that the structure of the specified table, including variables, foreign keys, and primary keys, matches the structure defined in the specified Excel file. Declaration Code Element Application Test Data Then verify the structure of variables, foreign keys, and primary keys from Excel “” for 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 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 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 verify that the row count of table “<testdata_name>” is “<testdata_name>” Keyword Given, When, And, Then Description Will verifies that the total number of rows in the specified table matches the expected row count. Declaration Code Element Application Test Data Then verify that the row count of table “” is “” NILL NILL A B TableName Company CountNumber 20 Remarks Table name must be valid. Restriction The table must exist. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations verify that the values in column “<testdata_name>” of table “<testdata_name>” are within the range “<testdata_name>” to “<testdata_name>” Keyword Given, When, And, Then Description Will ensures that all values in the specified column of the given table fall within the specified range. Declaration Code Element Application Test Data Then verify that the values in column “” of table “” are within the range “” to “” NILL NILL A B Column ColumnName Table TableName Range1 Content Range2 Content Remarks Column and table names must be valid. Restriction The table and column must exist. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations verify that all values in column “<testdata_name>” of table “<testdata_name>” exist in column “<testdata_name>” of table “<testdata_name>“ Keyword Given, When, And, Then Description Will ensures that all values present in the specified column of the first table also exist in the specified column of the second table. Declaration Code Element Application Test Data Then verify that all values in column “” of table “” exist in column “” of table “” NILL NILL A B Column1 ColumnName1 Table1 TableName1 Column2 ColumnName2 Table2 TableName2 Remarks Column and table names must be valid. Restriction Both tables and columns must exist. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations verify that all values in column “<testdata_name>” of table “<testdata_name>” are unique Keyword Given, When, And, Then Description Will verifies that all entries in the specified column of the given table are unique and do not repeat. Declaration Code Element Application Test Data Then verify that all values in column “” of table “” are unique NILL NILL A B ColumnName Salary TableName Employee Remarks Column and table names must be valid. Restriction The table and column must exist. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations user verifies data is not accessible without proper access for query Keyword Given, When, And, Then Description Will verify the database is not accessible without proper accesses. Declaration Code Element Application Test Data Then user verifies data is not accessible without proper access for query “” NILL NILL A B QueryName select * from Persons; Remarks The “<testdata_name>” should be provided in double quotes. Restriction The query must test access control effectively. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations verify performance with in “<testdata_name>” seconds Keyword Given, When, And, Then Description Will verify the performance of the SQL database Declaration Code Element Application Test Data Then verify performance with in “” seconds NILL NILL A B PerformanceTime 30 Remarks The “<testdata_name>” should be provided in double quotes. Restriction The performance threshold must be realistic and measurable. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations verify “var_name” procedure in the database Keyword Given, When, And, Then Description Will verify the procedure in SQL database. Declaration Code Element Application Test Data Then verify “Procedure1″ procedure in the database NILL NILL NILL Remarks The “<testdata_name>” should be provided in double quotes. Restriction The procedure name must be valid. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations verify the database connection Keyword Given, When, And, Then Description Will verify if the SQL database is connected Declaration Code Element Application Test Data Then verify the database connection NILL NILL NILL Remarks Nill Restriction The database connection must be established. Table of contents Keyword Description Declaration Remarks Restriction