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 almost 10 years ago
While you are at it, commands table is no longer used too (and associated relationship with workers table).
Updated by ancorgs almost 10 years ago
And dependencies also seems to be a similar case to states and results
Updated by ancorgs almost 10 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 almost 10 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 almost 10 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 almost 10 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.