action #5848
closedRemove job_states and job_results tables
Description
It makes no sense to keep such tables. It introduces a lot of sql joins with no benefit. The possible values should be kept in Perl code and the current foreign keys should be just labels.
Updated by oholecek over 9 years ago
While you are at it, commands table is no longer used too (and associated relationship with workers table).
Updated by ancorgs over 9 years ago
And dependencies also seems to be a similar case to states and results
Updated by ancorgs over 9 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 40
Still WIP, but I already have a working version without job_states and job_results. Removed 30 different database calls (counting joins and queries) so far.
Updated by ancorgs over 9 years ago
- % Done changed from 40 to 60
Finished removal of job_states and job_results tables. https://progress.opensuse.org/issues/5848
Updated by ancorgs over 9 years ago
- % Done changed from 60 to 80
Removal of table 'dependencies' added to the PR. BTW, the right (non-recursive) link is https://github.com/os-autoinst/openQA/pull/140 :-)
Updated by ancorgs over 9 years ago
- Status changed from In Progress to Closed
- % Done changed from 80 to 100
Added removal of table 'commands' to the PR. We should be done with database schema cleanup now.