Ability to connect to our DB to run DB validations. What are the possible connectivity issues and possibility to connect?
You can create a SQL script that do DB SQL queries and validate them as the following example:
-- step=Connect
-Connect-- username=aiq
-aiq-- password=thePasswordGoesHere
-thePasswordGoesHere-- url=jdbc:mysql://mysqlsmoketest.us-west-2.rds.amazonaws.com:3306/aiq
-aiq-- driver_class=com.mysql.jdbc.Driver
-Driver-- database=aiq
-aiq-- dialect=org.appvance.hibernate.dialect.MySQLDialect
-MySQLDialect-- connect
-connect-- step=Step1
SELECTStep1SELECT * FROM `aiq`.`SummaryElement` LIMIT 100;
100;-- step=Step2
SELECTStep2SELECT * FROM `aiq`.`Definition` LIMIT 100;
100;-- step=Step3
SELECTStep3SELECT * FROM `aiq`.`NodePerScenario` LIMIT 100;
100;-- step=Step4
SELECTStep4SELECT * FROM `aiq`.`SummaryElement` LIMIT 100;
100;-- step=Step5
SELECTStep5SELECT * FROM `aiq`.`UTPIterationPerExecution` LIMIT 100;
100;-- step=Step6
SELECTStep6SELECT * FROM `aiq`.`TypeLong` LIMIT 100;
100;-- step=Step7
SELECTStep7SELECT * FROM `aiq`.`UTPScenarioExecution` LIMIT 100;
100;-- step=Step8
SELECTStep8SELECT * FROM `aiq`.`UTPIterationPerExecution` LIMIT 100;
100;-- step=Step9
SELECTStep9SELECT * FROM `aiq`.`DefaultPercentil` LIMIT 100;
100;-- step=Step10
SELECTStep10SELECT * FROM `aiq`.`DetailedDuration` LIMIT 100;
100;-- step=Step11
SELECTStep11SELECT * FROM `aiq`.`DetailedElementAttribute` LIMIT 100;
100;-- step=Step12
SELECTStep12SELECT * FROM `aiq`.`SummaryChildElement` LIMIT 100;
100;-- step=Step13
SELECTStep13SELECT * FROM `aiq`.`SummaryElement` LIMIT 100;
100;-- step=Step14
SELECTStep14SELECT * FROM `aiq`.`Definition` LIMIT 100;
100;-- step=Step15
SELECTStep15SELECT * FROM `aiq`.`NodePerScenario` LIMIT 100;
100;-- step=Step16
SELECTStep16SELECT * FROM `aiq`.`SummaryElement` LIMIT 100;
100;-- step=Step17
SELECTStep17SELECT * FROM `aiq`.`UTPIterationPerExecution` LIMIT 100;
100;-- step=Step18
SELECTStep18SELECT * FROM `aiq`.`TypeLong` LIMIT 100;
100;-- step=Step19
SELECTStep19SELECT * FROM `aiq`.`UTPScenarioExecution` LIMIT 100;
100;-- step=Step20
SELECTStep20SELECT * FROM `aiq`.`UTPIterationPerExecution` LIMIT 100;
100;-- step=Step21
SELECTStep21SELECT * FROM `aiq`.`DefaultPercentil` LIMIT 100;
100;-- step=Step22
SELECTStep22SELECT * FROM `aiq`.`DetailedDuration` LIMIT 100;
100;-- step=BeforeDisc
-BeforeDisc-- step=Disconnect
-Disconnect-- disconnect
if the sql script contains a line after a SELECT line
-- storeInLocker=MyTestLockerKey1
then the result from the SELECT call will be stored in TheLocker (memory) with a name "MyTestLockerKey1"
You can then use a next script in your use case that consume that response (Java, TestNG, TestDesigner, or others)
Last updated: JuneOctober 02,15, 20232026
If you have any feedback on this topic, please contact us at documentation@appvance.ai