Database Operation

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

Database Operations run query “<testdata_name>” and verify the text “<testdata_name>” Keyword Given, When, And, Then Description Will run the query and verify the output in SQL Database Declaration Code Element Application Test Data Then run query “” and verify the text “” NILL NILL A B SelectQuery SELECT EFname from table1 where Eid=’1001′; RequiredText Solitera Remarks Both “<testdata_name>” instances should be provided in double quotes. Restriction The query and the verification text must be valid. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations run query “<testdata_name>” Keyword Given, When, And, Then Description Will run query in the SQL Database. Declaration Code Element Application Test Data Then run query “” NILL NILL A B InsertQuery INSERT INTO Table1 (Eid, EFname, ELname, Ephone) VALUES (‘1001’, ‘Solitera’, ‘TA’, ‘7894561230’); Remarks The “<testdata_name>” should be provided in double quotes. Restriction The query must be valid SQL.. Table of contents Keyword Description Declaration Remarks Restriction