launchpad-dev team mailing list archive

[Muharem Hrnjadovic <muharem@xxxxxxxxxx>]

Aaron Bentley wrote:
> Julian Edwards wrote:
>> == Proposed changes ==
>>
>> The first stage is to retain the existing functionality for Soyuz package 
>> builds, but allow other types of jobs to run later.
>>
>> `Job` rows will be created in tandem with the build jobs, however log files 
>> will continue to be stored in the librarian (they get big).
>>
>> || BuildPackageJob || job (FK) | build (FK) | ... 
>> || BuildQueue || job (FK) | job_type (enum) | lastscore (int) | ... 
>>
>> BuildPackageJob will link the build record to the Job record.  BuildQueue 
>> loses its build FK and now links to the build via the BuildPackageJob record 
>> with the same job ID.
> 
> Does job_type indicate whether it is a BuildPackageJob,
> BuildPackageRecipeJob or BuildTranslationsJob?  Or would it be a subtype?

It is the former. This enables us to query/know the (right) table with
the information specific to the job i.e. the `Build` foreign key for the
 `BuildPackageJob`.

Best regards

-- 
Muharem Hrnjadovic <muharem@xxxxxxxxxxxxx>
Public key id   : B2BBFCFC
Key fingerprint : A5A3 CC67 2B87 D641 103F  5602 219F 6B60 B2BB FCFC

Attachment: signature.asc
Description: OpenPGP digital signature