how to Insert a test case Execution Record Programmatically in the test case execution records table in RQM ?
Dear All,
I am able to update the execution records in rqm given its ID with the help of "RQM URL UTILITY " using these commands
java -jar RQMUrlUtility.jar -command GET -user <userid> -password <pwd> -filepath file.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/QM_Area/executionresult/urn:com.ibm.rqm:executionresult:1
but i need things like
1. in the given PUT command example we are able to get the xml in the file provided in command , is it possible to get xml packet in return instead of physical file , though i can read xml from the file but sometimes its not possible to create files due to some security reasons.
2. in the above PUT command example we can update the status of the test case execution record given the execution table record ID which always increments when any testcase is executed . SO is there any way that we can insert a test case execution record instead of updating it. OR if we can get the ID of the last testcase execution record in the execution record table for a particular test case.
3. how can we programmatically execute the test case in rqm with the help of any utility.
I am able to update the execution records in rqm given its ID with the help of "RQM URL UTILITY " using these commands
java -jar RQMUrlUtility.jar -command GET -user <userid> -password <pwd> -filepath file.xml -url https://localhost:9443/jazz/service/com.ibm.rqm.integration.service.IIntegrationService/resources/QM_Area/executionresult/urn:com.ibm.rqm:executionresult:1
but i need things like
1. in the given PUT command example we are able to get the xml in the file provided in command , is it possible to get xml packet in return instead of physical file , though i can read xml from the file but sometimes its not possible to create files due to some security reasons.
2. in the above PUT command example we can update the status of the test case execution record given the execution table record ID which always increments when any testcase is executed . SO is there any way that we can insert a test case execution record instead of updating it. OR if we can get the ID of the last testcase execution record in the execution record table for a particular test case.
3. how can we programmatically execute the test case in rqm with the help of any utility.
One answer
Some answers:
1. No, not using the RQM URL Utility. Instead of using the RQM URL Utility, consider writing your own HTTP client or using the Poster/HTTPRequester Firefox plug-ins to receive the raw XML response content.
Note: Your example uses a HTTP GET request .
2. In your example, you are using a test case result (executionresult resource). The executionresult resource ID does not increment but rather a new executionresult resource is created during each test case execution. Likewise, new test case execution record (executionworkitem resource) can be created and associated it to a test case. Finally, you can GET the test case execution record(s) (executionworkitem resource(s)) that are associated to a specific test case (testcase resource) using a fields filter (see https://jazz.net/products/rational-quality-manager/api-doc-4.0.6/schemas/qm_xsd/elements/executionworkitem.html#a31 and https://jazz.net/wiki/bin/view/Main/RqmApi#fields).
Note: Your example uses a HTTP GET request .
3. No, this is not supported using the RQM URL Utility. Note, the RQM URL Utility is just a simple HTTP client that can be executed from the command line. See https://jazz.net/wiki/bin/view/Main/RQMTestAutomationAdapterAPI for writing test automation tools.
1. No, not using the RQM URL Utility. Instead of using the RQM URL Utility, consider writing your own HTTP client or using the Poster/HTTPRequester Firefox plug-ins to receive the raw XML response content.
Note: Your example uses a HTTP GET request .
2. In your example, you are using a test case result (executionresult resource). The executionresult resource ID does not increment but rather a new executionresult resource is created during each test case execution. Likewise, new test case execution record (executionworkitem resource) can be created and associated it to a test case. Finally, you can GET the test case execution record(s) (executionworkitem resource(s)) that are associated to a specific test case (testcase resource) using a fields filter (see https://jazz.net/products/rational-quality-manager/api-doc-4.0.6/schemas/qm_xsd/elements/executionworkitem.html#a31 and https://jazz.net/wiki/bin/view/Main/RqmApi#fields).
Note: Your example uses a HTTP GET request .
3. No, this is not supported using the RQM URL Utility. Note, the RQM URL Utility is just a simple HTTP client that can be executed from the command line. See https://jazz.net/wiki/bin/view/Main/RQMTestAutomationAdapterAPI for writing test automation tools.
Comments
Dear Paul,
Thanks for you're valuable reply.
Actually I am new to RQM can you please help me by sending a sample code for http client through which i can understand how to use RQMAPI and it will be a great help if you can suggest me a sample code for inserting a testexecution record in rqm because I'm not able to understand the RQMAPI and how to use it.
Thanks & Regards