SQL Query StepDef

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

Database Operations create a procedure “var_name” with query “<testdata_name>” in the database Keyword Given, When, And, Then Description Create a procedure with the given query in SQL database. Declaration Code Element Application Test Data Then create a procedure “Procedure1” with query “” in the database NILL NILL A B SelectQuery SELECT EFname from table1 where Eid=’1001′; Remarks Both “<testdata_name>” instances should be provided in double quotes. Restriction The procedure name and query must be valid. Table of contents Keyword Description Declaration Remarks Restriction

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