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