Add a relationship table between tickets and test cases in plan, and corresponding API

[Roberto Longobardi]

Add such a relationship table to track n-to-m relationship between the two concepts.

Also add corresponding API to:

• Retrieve all TCs associated to a ticket
• Retrieve all tickets associated to a TC in any test plan
• Retrieve all tickets associated to a TC in a specific plan
• Retrieve all tickets associated to any TC in a specific plan

[Roberto Longobardi]

I implemented a smaller set of requirements with ticket #8259 in release 1.3.11.

Take a look, it may just fit your needs.

[anonymous]

Implemented in 1.4.1.

You now have the ability to programmatically get all of the tickets that have been (explicitly) opened against a test case.

From a TestCase object, you can list the tickets opened against it in any test plan.

From a TestCaseInPlan object, you can list the tickets opened against the test case in the specific plan.

from testmanager.model import TestCase, TestCaseInPlan

tc = TestCase(self.env, id, path)
for t in tc.get_related_tickets():
    result += str(t) + ', '

tc = TestCaseInPlan(self.env, id, planid, path)
for t in tc.get_related_tickets():
    result += str(t) + ', '

This is achieved by adding two custom fields to the ticket object, named 'testcaseid' for the test case ID, and 'planid' for the test plan ID.