Database Connection StepDef

Database Operations setup a connection with database1 “applicationVar_name” & database2 “applicationVar_name” Keyword Given, When, And, Then Description Will setup a connection for two databases in SQL database Declaration Code Element Application Test Data Then setup a connection with database1 “applicationVar_name1” & database2 “applicationVar_name2″ NILL applicationVar_name1 database MYSQL 8.3.0 jdbc:mysql://localhost:3306 STANDARD root root soliterata com.mysql.cj.jdbc.Driver applicationVar_name2 database MYSQL 8.3.0 jdbc:mysql://localhost:3306 STANDARD root root solite com.mysql.cj.jdbc.Driver NILL Remarks The “applicationVar_name” for both databases should be provided in double quotes. Restriction Both configurations must be valid and defined in the application configuration file. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations close the multi database connections Keyword Given, When, And, Then Description Will close the multi database connections in SQL database Declaration Code Element Application Test Data Then close the multi database connections NILL NILL NILL Remarks Multiple database connections must be previously established. Restriction The method must handle multiple connections appropriately. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations close database connection with “application_name” configuration Keyword Given, When, And, Then Description Will close the database connection using the given configuration Declaration Code Element Application Test Data Then close database connection with “LocalDatabase” configuration NILL LocalDatabase database MYSQL 8.3.0 jdbc:mysql://localhost:3306 STANDARD root root soliterata com.mysql.cj.jdbc.Driver NILL Remarks The “applicationVar_name” should be provided in double quotes and must correspond to a valid configuration. Restriction The configuration details must be defined in the application configuration file. Table of contents Keyword Description Declaration Remarks Restriction

Database Operations connect to database with “application_name” configuration Keyword Given, When, And, Then Description Will connect to the database using the given configuration. Declaration Code Element Application Test Data Given connect to database with “LocalDatabase” configuration NILL LocalDatabase database MYSQL 8.3.0 jdbc:mysql://localhost:3306 STANDARD root root soliterata com.mysql.cj.jdbc.Driver NILL Remarks The “applicationVar_name” should be provided in double quotes and must correspond to a valid configuration. Restriction The configuration details must be defined in the application configuration file. Table of contents Keyword Description Declaration Remarks Restriction