Deleting all results by using the command line

You can delete all results and project data that is stored in the results database and you no longer require the stored results by using the HCL OneTest™ API command line.

The syntax to delete all results that are stored in a results database is as follows:

IntegrationTesterCmd <Options> delete-all-results
Note: When you run this command, you can view the progress of the deletion in a progress bar.

The syntax to delete all results of the tests in a project that are stored in a results database is as follows:

IntegrationTesterCmd --project <project_name> delete-all-results
Note: When you specify the --project option, the results database that you configured for the project is accessed and you need not explicitly specify the details of the results database or your credentials to access the results database. The results of the Suites and tests in the project that were run are deleted from the results database.
For example, if the project is c:\MyProjects\testproject1 that has the results database configured with the following details:
  • Database URL as jdbc:db2://localhost:50000/resultdb
  • User name as jkelly
  • Password as hayling
The command to delete all test results of the tests in the project that are stored in the results database is as follows:

IntegrationTesterCmd --project c:\MyProjects\testproject1 delete-all-results

The syntax to delete all results in a results database that is secured by a user name and password is as follows:

IntegrationTesterCmd --databaseURL <results_database_URL> --dbuser <user_name> --password <password> delete-all-results
Note: The results database might be configured as the results database for different projects by different testers. You can use this command to clear the results database of the stored records if you did not set up the results database. You can delete all the stored results by using the credentials of the database owner.

For example, to delete all test results in a results database with the URL as jdbc:db2://localhost:50000/resultdb, user name as jkelly, password as hayling, the command is as follows:

IntegrationTesterCmd --databaseURL jdbc:db2://localhost:50000/resultdb --dbuser jkelly --password hayling delete-all-results

Important: After you delete all test suite results and project data in the results database, you must restart any HCL OneTest™ API workbench instances or HCL OneTest™ API Agent instances that were using the results database. 

The following table lists the options that you can use with the IntegrationTesterCmd command for deleting all test results.

Table 1. List of available options
Options Description
--project/-p Path to project file (optional). Used to limit the deletion to test suite results to a specific project. If not specified then databaseUrl, dbuser, and password are the required options.
--databaseUrl/-b Results database URL. For more information on the specification of database URLs when using IP literal addresses, see IP literal address.
--dbuser/-g Results database user name
--password/-h Results database password