Merge ~cjwatson/launchpad:db-more-relative-build-scores into launchpad:db-devel

Proposed by Colin Watson
Status: Merged
Approved by: Colin Watson
Approved revision: bda010fd1bae8fb11311cd8441461734c9e91cdd
Merge reported by: Otto Co-Pilot
Merged at revision: not available
Proposed branch: ~cjwatson/launchpad:db-more-relative-build-scores
Merge into: launchpad:db-devel
Diff against target: 20 lines (+14/-0)
1 file modified
database/schema/patch-2211-16-0.sql (+14/-0)
Reviewer Review Type Date Requested Status
William Grant db Approve
Review via email: mp+436041@code.launchpad.net

This proposal supersedes a proposal from 2023-01-19.

Commit message

Add relative_build_score to CharmRecipe/GitRepository/Snap

Description of the change

We've had a request to be able to control build scores for snap recipes, and we might as well give ourselves some more control over a couple of other build types while we're at it.

To post a comment you must log in.
Revision history for this message
William Grant (wgrant) :
review: Approve (db)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1diff --git a/database/schema/patch-2211-16-0.sql b/database/schema/patch-2211-16-0.sql
2new file mode 100644
3index 0000000..86ad4b3
4--- /dev/null
5+++ b/database/schema/patch-2211-16-0.sql
6@@ -0,0 +1,14 @@
7+-- Copyright 2023 Canonical Ltd. This software is licensed under the
8+-- GNU Affero General Public License version 3 (see the file LICENSE).
9+
10+SET client_min_messages=ERROR;
11+
12+ALTER TABLE CharmRecipe ADD COLUMN relative_build_score integer;
13+ALTER TABLE GitRepository ADD COLUMN relative_build_score integer;
14+ALTER TABLE Snap ADD COLUMN relative_build_score integer;
15+
16+COMMENT ON COLUMN CharmRecipe.relative_build_score IS 'A delta to the build score that is applied to all builds of this charm recipe.';
17+COMMENT ON COLUMN GitRepository.relative_build_score IS 'A delta to the build score that is applied to all builds of this Git repository.';
18+COMMENT ON COLUMN Snap.relative_build_score IS 'A delta to the build score that is applied to all builds of this snap recipe.';
19+
20+INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 16, 0);

Subscribers

People subscribed via source and target branches

to status/vote changes: