This week, I worked on separating Job Status(s) from the common Jobs table (long overdue, I think for a year).
As I wrote previously, not all values linked to a JobID are not really accessed in the day to day functions of the DIRACGrid project. Last time, Job Attributes were shifted to ES backend for accessing it with similar efficiency as Job Parameters. For Job Status, a new table has been created keeping MySQL backend with the following entities:
As I wrote previously, not all values linked to a JobID are not really accessed in the day to day functions of the DIRACGrid project. Last time, Job Attributes were shifted to ES backend for accessing it with similar efficiency as Job Parameters. For Job Status, a new table has been created keeping MySQL backend with the following entities:
- JobID (primary key)
- Status
- Minor Status
- Application Status
So, along with shifting the values to the new table (JobsStatus), functions are modified/added to access (read/write) the table:
- "setJobStatus": The existing function is modified to write in the new table.
- "getJobStatus": The new function has been added to access values in the new table. Along with this, it keeps back support to access the values that were already written in the Jobs table.
Commits related to the work can be found below:
- Add tables and functions for JobStatus: b60cd0f44e9c2cb134565613fe553404d64b78b6
- Replace functions with new ones in services: 75885bcf2cb64c60e193dc847d943ea457b8ff7c
Comments
Post a Comment