323768 - Update database schema to allow for more complex testcase relationships

Status: RESOLVED FIXED

(Webtools Graveyard :: Litmus, defect)

Description

[Chris Cooper [:coop] (he/him)]

The current Litmus database schema assumes a static relationship between products, platforms, testcases, subgroups, and testgroups. This makes two things difficult:

1) Maintaining basic information (e.g. a single platform like Windows) is hard because it is stored on a per-product basis.
2) Similarly, testcases can belong to only a single testgroup/subgroup, so testcase reuse is impossible without copying the entire testcase and associated data. Testcase reuse will be necessary to allow for custom test runs, but also just to reuse testcases between products, e.g. between Firefox and SeaMonkey.

The solution is to break out the existing linkage fields into proper join tables. This will also require a reworking of the perl modules that represent these classes, and potentially some modifications to the CGI scripts.

Comment 1

[Chris Cooper [:coop] (he/him)]

First round of changes have been checed in. These changes include:
* new join table for platforms/products
* new join table for testcases/subgroups
* new join table for subgroups/testgroups
* new join table for testgroups/branches
* base tables for test runs

Comment 2

[Chris Cooper [:coop] (he/him)]

We may require some small changes/additions in the future, but the core changes have now been made to the database