Project

General

Profile

action #5848

Remove job_states and job_results tables

Added by ancorgs over 7 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Feature requests
Target version:
Start date:
2015-01-13
Due date:
% Done:

100%

Estimated time:
6.00 h
Difficulty:

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.

History

#1 Updated by oholecek over 7 years ago

While you are at it, commands table is no longer used too (and associated relationship with workers table).

#2 Updated by ancorgs over 7 years ago

And dependencies also seems to be a similar case to states and results

#3 Updated by ancorgs over 7 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.

#4 Updated by ancorgs over 7 years ago

  • % Done changed from 40 to 60

Finished removal of job_states and job_results tables. https://progress.opensuse.org/issues/5848

#5 Updated by coolo over 7 years ago

this is a recursive link :)

#6 Updated by ancorgs over 7 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 :-)

#7 Updated by ancorgs over 7 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.

Also available in: Atom PDF