Identification of test suite iteration in the external Database
I've a question about External database use for reporting. I have a testsuite which is launched every night by 10 PM for ~5 hours. Results are logged in database correctly, but I have not found a way to identify (**differentiate**) each iteration of the test suite, in the database. In testreport table, I see that there is column called testgroup and another one called testsubgroup, but they are always empty. Have you any solution or idea to deal with that? Using iTest v. 4.2
Just to confirm: is the question related to iTest? Also, it always helps to include the version of the product being used.
No worries. And if one of the answers solves your problem, please give it the "Accept this answer as correct" checkmark. Good luck.
Following scenario could help you to achieve your requirement. 1. I have created a command session test-case Main.fftc which runs under job new_job.ffjd. 2. Then I have passed the value to --group option in iTestRt command based on the time-stamp of new test-case Main.fftc which executes the test-suite under second_job.ffjd in iTestRt. The scenario is like this. new_job.ffjd->Main.fftc->which runs second_job.ffjd in rt(which has the test-suite). Please find the attached test-case and screen shot for your reference. ![alt text][1] [link text][2] [1]: /storage/temp/3504-itestrt.png [2]: /storage/temp/3505-main.fftc Please let me know how it goes.
I believe adding group value to the database is not available in iTest GUI.But we can do this using itestRT feature. Following are the steps to insert group value into test-report table.
1.In itestRT Run the test-suit by connecting to External database as shown in the screenshot.Which will create a **group my** in the reports table for all the test-cases under test-suit. itestrt --itar "c:\Users\PAXTERRA\Desktop" --licenseServer Xx.xx.xx.xx --dbtype MySQL --ipaddr localhost --catalog itestdb1 --trdb.user root --trdb.password ******* --group my --job project://my_project/testbeds/new_job.ffjd ![alt text][1] 2.Then issue a query in the database to fetch the reports under the group **my** as shown in the below screenshot. ![alt text][2] [1]: /storage/temp/3501-itestrt.png [2]: /storage/temp/3502-database.png Hope this will help you.
Hi Nagesh, This answers to a part of my question thanks a lot. I'll try this to fill testgroup in database. BUT the problem asked here is to differentiate 2 iterations of the same test suite launched two different days. Startdate can't help here because some test cases can start before midnight and others after for the same testsuite. I'm looking for a way to have something like "My1" for test suite launched day 1 "My2" for test suite launched day 2 ... If someone have an idea :). Thanks in advance. TMA
4 People are following this question.
