Forum Discussion

TK6666's avatar
TK6666
Contributor
3 years ago

DB Reset script-to run before tests can be executed

Hi   Please could you advise me on how I overcome this issue. I have a PowerShell script that I need to incorporate as part of my keyword tests in order to have the DB reset before I can run my te...
Script Tests
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
3 years ago

In TC, you can use SQL, see for example ADO.CreateConnection.

 

You need to somehow wait until your SQL process has finished before proceeding. 

Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
3 years ago

Once the database script is added to the top of your test cases, then add a loop right after it to look for the last record in the database. If it is not there, wait some more and let the loop check again. If it is there, then fall through the loop and start the actual test cases.