Ashish kumar, Author at SoliteraTA

SoliteraTA

Categories
Database Operation Database Verification StepDef Step Defination

verify “var_name” procedure in the database

verify “var_name” procedure in the database

verify “var_name” procedure in the database

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

verify “var_name” procedure in the database

Keyword

Given, When, And, Then

Description

Will verify the procedure in SQL database.

Declaration
				
					Then verify "Procedure1" procedure in the database
				
			
				
					NILL
				
			
				
					NILL
				
			
				
					NILL
				
			
Remarks

Nill

Restriction
  1. The variable used in this step definition is a dynamic variable and it must be already created.
Categories
Database Operation Database Verification StepDef Step Defination

verify the database connection

verify the database connection

verify the database connection

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

verify the database connection

Keyword

Given, When, And, Then

Description

Will verify if the SQL database is connected

Declaration
				
					Then verify the database connection
				
			
				
					NILL
				
			
				
					NILL
				
			
				
					NILL
				
			
Remarks

Nill

Restriction

Nill

Categories
Database Operation SQL Query StepDef Step Defination

run “var_name” procedure and verify “<testdata_name>” text in “<testdata_name>” column name in the database

run “var_name” procedure and verify “<testdata_name>” text in “<testdata_name>” column name in the database

run “var_name” procedure and verify “<testdata_name>” text in “<testdata_name>” column name in the database

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

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
				
					Then run "Procedure1" procedure and verify "<RequiredText>" text in "<RequiredColumnName>" column name in the database
				
			
				
					NILL
				
			
				
					NILL
				
			
A
B
RequiredText
Solitera
RequiredColumnName
EFname
Remarks
  1. This step definition will only work if the procedure will be created using DQL commands, which return the schema in the result.
Restriction

Nill

Categories
Database Operation SQL Query StepDef Step Defination

run “var_name” procedure in the database

run “var_name” procedure in the database

run “var_name” procedure in the database

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

run “var_name” procedure in the database

Keyword

Given, When, And, Then

Description

Will run the procedure in SQL database

Declaration
				
					Then run "Procedure1" procedure in the database
				
			
				
					NILL
				
			
				
					NILL
				
			
				
					NILL
				
			
Remarks

Nill

Restriction

Nill

Categories
Database Operation SQL Query StepDef Step Defination

create a procedure “var_name” with query “<testdata_name>” in the database

create a procedure “var_name” with query “<testdata_name>” in the database

create a procedure “var_name” with query “<testdata_name>” in the database

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

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
				
					Then create a procedure "Procedure1" with query "<SelectQuery>" in the database
				
			
				
					NILL
				
			
				
					NILL
				
			
A
B
SelectQuery
SELECT EFname from table1 where Eid='1001';
Remarks
  1.  The first variable used in the step definition can have any name of the user’s choice and using its name we can access it.
Restriction
  1.  The second variable used in the step definition should exist in the test data file.
Categories
Database Operation SQL Query StepDef Step Defination

run “<testdata_name>” query and verify “<testdata_name>” text in “<testdata_name>” column name in the database

run “<testdata_name>” query and verify “<testdata_name>” text in “<testdata_name>” column name in the database

run “<testdata_name>” query and verify “<testdata_name>” text in “<testdata_name>” column name in the database

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

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
				
					Then run "<SelectQuery>" query and verify "<RequiredText>" text in "<RequiredColumnName>" column name in the database
				
			
				
					NILL
				
			
				
					NILL
				
			
A
B
SelectQuery
SELECT EFname from table1 where Eid='1001';
RequiredText
Solitera
RequiredColumnName
EFname
Remarks
  1.  This step definition will work only with DQL commands, which return the schema in the result.
Restriction
  1. The variable used in the step definition should exist in the test data file.
Categories
Database Operation SQL Query StepDef Step Defination

run query “<testdata_name>” and verify the text “<testdata_name>”

run query “<testdata_name>” and verify the text “<testdata_name>”

run query “<testdata_name>” and verify the text “<testdata_name>”

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

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
				
					Then run query "<SelectQuery>" and verify the text "<RequiredText>"
				
			
				
					NILL
				
			
				
					NILL
				
			
A
B
SelectQuery
SELECT EFname from table1 where Eid='1001';
RequiredText
Solitera
Remarks
  1.  This step definition will work only with DQL commands, which return the schema in the result.
Restriction
  1. The variable used in the step definition should exist in the test data file.
Categories
Database Operation SQL Query StepDef Step Defination

run query “<testdata_name>”

run query “<testdata_name>”

run query “<testdata_name>”

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

run query “<testdata_name>”

Keyword

Given, When, And, Then

Description

Will run query in the SQL Database.

Declaration
				
					Then run query "<InsertQuery>"
				
			
				
					NILL
				
			
				
					NILL
				
			
A
B
InsertQuery
INSERT INTO Table1 (Eid, EFname, ELname, Ephone) VALUES ('1001', 'Solitera', 'TA', '7894561230');
Remarks
  1. The “String Value” that is used through test data file should be in angular brackets.
Restriction
  1. The value used in the step definition should exist in the testdata file with value.
Categories
Database Connection StepDef Database Operation Step Defination

close database connection with “application_name” configuration

close database connection with “application_name” configuration

close database connection with “application_name” configuration

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

close database connection with “application_name” configuration

Keyword

Given, When, And, Then

Description

Will close the database connection using the given configuration

Declaration
				
					Then close database connection with "LocalDatabase" configuration
				
			
				
					NILL
				
			
				
					
<environment>
  <config>
    <name>LocalDatabase</name>
    <type>database</type>
    <db_type>MYSQL</db_type>
    <db_version>8.3.0</db_version>
    <db_url>jdbc:mysql://localhost:3306</db_url>
    <db_con_type>STANDARD</db_con_type>
    <db_username>root</db_username>
    <db_password>root</db_password>
    <db_schema>soliterata</db_schema>
    <db_driver_name>com.mysql.cj.jdbc.Driver</db_driver_name>
  </config>
</environment>
				
			
				
					NILL
				
			
Remarks

 

  1. We can use any variable name
Restriction
  1. The variable used in the step definition should exist in the application file with proper configurations of database.
Categories
Database Connection StepDef Database Operation Step Defination

connect to database with “application_name” configuration

connect to database with “application_name” configuration

connect to database with “application_name” configuration

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

connect to database with “application_name” configuration

Keyword

Given, When, And, Then

Description

Will connect to the database using the given configuration.

Declaration
				
					Given connect to database with "LocalDatabase" configuration
				
			
				
					NILL
				
			
				
					
<environment>
  <config>
    <name>LocalDatabase</name>
    <type>database</type>
    <db_type>MYSQL</db_type>
    <db_version>8.3.0</db_version>
    <db_url>jdbc:mysql://localhost:3306</db_url>
    <db_con_type>STANDARD</db_con_type>
    <db_username>root</db_username>
    <db_password>root</db_password>
    <db_schema>soliterata</db_schema>
    <db_driver_name>com.mysql.cj.jdbc.Driver</db_driver_name>
  </config>
</environment>
				
			
				
					NILL
				
			
Remarks

 

  1. We can use any variable name
Restriction
  1. The variable used in the step definition should exist in the application file with proper configurations of database.

Solitera may collect certain information by automated means, such as cookies and web beacons, when a user visits our website. A “cookie” is a small piece of data that a website can send to your browser, which may then be stored on your system. learn more

Choose your Operating System