fix wrong dbix:class:loader generation

[?]

Feb 25, 2010, 10:22 AM

VVOAXWH4EKVYSDOOKDQN3FHU2JRNNKEG7G4E7YRB7HEVYXHVP63QC

Dependencies

[2] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
[3] B72GLND4
[4] ZI535LI6 * hydra: 'new' UI for project/jobset/job/build
[5] TQKGQ5R3
[6] S5PV6IIM * Represent jobs explicitly in the DB.
[7] V4RNHJNR * Add a link to each project's homepage. Suggested by karltk.
[8] EYNG4EL4 * Regenerate the bindings from a clean sqlite database.
[9] TLZ2SPBR
[10] OZ5UBJEK
[11] 7YBYT2LQ
[12] RU7AQO7U * Role-based access control. Only admins can create projects. Only
[13] R5D7DZPE
[14] AHTEIK7G * Added a maintainers field to the Builds table.
[15] VJHIHMEH * Store the meta.longDescription and meta.license attributes in the
[16] QNDXPVCI * Store the jobset's nixExprPath and nixExprInput fields in a build to
[17] D3DIBMOK * For products that are directories (like manuals), allow a default
[18] H7CNGK4O * Log evaluation errors etc. in the DB.
[19] KOTB7BKV
[20] SJLEZFC4 check getHydraPath in stead of Envvar HYDRA_DBI directly
[21] 3HCBU2FA
[22] TWVSALRL * Allow the maximum number of concurrent builds per platform to be
[23] 37R34XJO * Negative caching: don't perform a build if a dependency already
[24] 4D4U5IPY * Allow jobsets to be disabled.
[25] L2E6EVE2 * Merged the Build and Job tables.
[26] GNIEG2GC * Disambiguate jobs by jobset name. I.e. jobs with the same name in
[27] BHZXGT2H * Channels: provide an index page that lists all the packages in the
[28] RBNQKATL * Adding persistant releases. A release is a named set of builds.
[29] 67P45PY4
[30] PHX2HIVG * Store info about the build inputs in the build record.
[31] P5X4P6VK * Renaming "release sets" to "views" (not finished yet). Having
[32] YTZOC7C5 * Editing of jobset inputs.
[33] Z4KRJX4Q * In the last succeeded / job status queries, use the Builds.isCurrent
[34] VCOSLZRP
[35] ECBA3GQO * Make the schema class names match the case of the SQL table names.
[36] KN3VYE5P * Cleaned up the foreign key constraints.
[37] FHF6IZJQ * Basic release management: releases are now dynamically computed as
[38] WYN733ST * Store build duration, handle cached builds.
[39] 6BLUKEQ2 * Caching of "path" inputs, and fake a revision number for those.
[40] BD3GRK4B * Get rid of "positive failures" and separate log phases.
[41] LCKWLQW3 * In Sqlite "release" is now a keyword, so use "release_" instead.
[42] CMU3YKOU * Store the release name.
[43] ZVTSOVHN * Support Subversion checkouts.
[44] SZYY2EQQ * Make the queries more readable.
[45] SHBLLAVH * More global substitution.
[46] 2I2ZX6JB * Make the "latest succeeded" query (used by the "latest" channel)
[47] DVNWJXWW * Generic declaration of build products.
[48] X27GNHDV * Basic job info in the database.
[49] 3E6IP3R3 * Add the name of the jobset to ReleaseSetJobs, otherwise we can't
[50] JTRG7RDQ add support for git as jobinput
[51] S6OISBQ3 * Mark the "current" builds in a jobset, i.e. those corresponding to
[52] IK53RV4V
[53] S66BOMVU * Added authentication.
[54] BVOPAMLS
[55] GWCV3TQV * BuildInputs table: link to dependencies, include store paths.
[56] ZEHSSVFG
[57] J5UVLXOK * Start of a basic Catalyst web interface.
[58] M552HLIA * Support variant builds.
[59] CLJQCY2X * Store info about all the build actions and allow them to be
[60] YAPITGB3 * Boolean inputs.
[61] 3ZCEPLNO
[62] 3HEMN2Q2 * Speed up the jobstatus query a little bit.
[*] 2QA4Y4G3 * hydra: added index, actual build time (buildstep with same outpath, so without deps) of the build
[*] SJN2QPWH * Big speed-up of the job status page and the channel generation (such

Change contents

replacement in src/lib/Hydra/Schema/Builds.pm at line 424

[3.6194]→[2.9869:10011](∅→∅)

# Created by DBIx::Class::Schema::Loader v0.05003 @ 2010-02-25 10:29:41
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dsXIx+mh+etSD7zKQJ6I3A

[3.6194]

[3.62]

# Created by DBIx::Class::Schema::Loader v0.05003 @ 2010-02-25 11:19:24
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oCkX9bughWPZg6JKaOxDJA
edit in src/lib/Hydra/Schema/Builds.pm at line 453

[3.3767]

[64.293]

);

__PACKAGE__->has_one(
"actualBuildStep",
"Hydra::Schema::BuildSteps",
{ 'foreign.outpath' => 'self.outpath'
, 'foreign.build' => 'self.id'
},
replacement in src/lib/Hydra/Schema/Builds.pm at line 509

[3.877]→[2.10012:10076](∅→∅)

(select project, jobset, job, system, max(id) as id

[3.877]

[3.733]

(select
(select max(id) from builds b
where
project = activeJobs.project and jobset = activeJobs.jobset
and job = activeJobs.job and system = activeJobs.system
and finished = 1
) as id
replacement in src/lib/Hydra/Schema/Builds.pm at line 517

[3.777]→[2.10077:10248](∅→∅)

natural join Builds
where finished = 1
group by project, jobset, job, system)
as latest
natural join Builds x

[3.777]

[3.1090]

) as latest
join Builds x using (id)
edit in src/lib/Hydra/Schema/Builds.pm at line 522

[3.1135]

[3.1135]

makeSource("ActiveJobs$name", "(select distinct project, jobset, job from Builds where isCurrent = 1 $constraint)");
replacement in src/lib/Hydra/Schema/Builds.pm at line 530

[3.1238]→[2.10249:10313](∅→∅)

(select project, jobset, job, system, max(id) as id

[3.1238]

[3.895]

(select
(select max(id) from builds b
where
project = activeJobs.project and jobset = activeJobs.jobset
and job = activeJobs.job and system = activeJobs.system
and finished = 1
and exists (select 1 from buildresultinfo where id = b.id and buildstatus = 0)
) as id
edit in src/lib/Hydra/Schema/Builds.pm at line 539

[3.939]→[2.10314:10492](∅→∅)

natural join Builds
natural join BuildResultInfo
where finished = 1 and buildStatus = 0
group by project, jobset, job, system
replacement in src/lib/Hydra/Schema/Builds.pm at line 540

[3.1495]→[2.10493:10523](∅→∅)

natural join Builds

[3.1495]

[3.1525]

join Builds using (id)
edit in src/lib/Hydra/Schema/Builds.pm at line 552

[65.3229]

[3.6337]