diff options
| author | Danjela Lura <danielaluraa@gmail.com> | 2020-05-28 22:17:11 +0200 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-06-07 20:17:03 +0100 |
| commit | f67bea719d07cf48818bc0c2a1adca4edb291cd7 (patch) | |
| tree | db42bd81351e88154541e87b38d01108379d2636 /sqitch | |
| parent | ae6541af1e23ec0a9d20e9abee73d3404d58078c (diff) | |
| download | data-service-f67bea719d07cf48818bc0c2a1adca4edb291cd7.tar data-service-f67bea719d07cf48818bc0c2a1adca4edb291cd7.tar.gz | |
Get the translated lint checker descriptions into the database
Signed-off-by: Christopher Baines <mail@cbaines.net>
Diffstat (limited to 'sqitch')
4 files changed, 55 insertions, 0 deletions
diff --git a/sqitch/deploy/translations_for_lint_checker_descriptions.sql b/sqitch/deploy/translations_for_lint_checker_descriptions.sql new file mode 100644 index 0000000..3a2ed8e --- /dev/null +++ b/sqitch/deploy/translations_for_lint_checker_descriptions.sql @@ -0,0 +1,40 @@ +-- Deploy guix-data-service:translations_for_lint_checker_descriptions to pg + +BEGIN; + +CREATE TABLE lint_checker_descriptions ( + id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY, + locale varchar NOT NULL, + description varchar NOT NULL, + UNIQUE (locale, description) +); + +CREATE TABLE lint_checker_description_sets ( + id integer NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY, + description_ids integer[] NOT NULL, + UNIQUE (description_ids) +); + +ALTER TABLE lint_checkers ADD COLUMN lint_checker_description_set_id integer REFERENCES lint_checker_description_sets(id); + +INSERT INTO lint_checker_descriptions(locale, description) +SELECT DISTINCT 'en_US.utf8', description + FROM lint_checkers; + +INSERT INTO lint_checker_description_sets (description_ids) +SELECT DISTINCT ARRAY_AGG( + id) + FROM lint_checker_descriptions + GROUP BY id; + +UPDATE lint_checkers + SET lint_checker_description_set_id = + lint_checker_description_sets.id + FROM lint_checker_description_sets + INNER JOIN lint_checker_descriptions + ON lint_checker_description_sets.description_ids[1] = lint_checker_descriptions.id + WHERE lint_checkers.description = lint_checker_descriptions.description; + +ALTER TABLE lint_checkers DROP COLUMN description; + +COMMIT; diff --git a/sqitch/revert/translations_for_lint_checker_descriptions.sql b/sqitch/revert/translations_for_lint_checker_descriptions.sql new file mode 100644 index 0000000..a310ea5 --- /dev/null +++ b/sqitch/revert/translations_for_lint_checker_descriptions.sql @@ -0,0 +1,7 @@ +-- Revert guix-data-service:translations_for_lint_checker_descriptions from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index cb57737..911c43b 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -59,3 +59,4 @@ load_new_guix_revision_jobs_make_commits_unique 2020-03-27T21:38:42Z Christopher remove_odd_package_derivations 2020-04-24T20:36:06Z Christopher Baines <mail@cbaines.net> # Remove odd package derivations build_servers_lookup_builds 2020-05-24T15:18:09Z Christopher Baines <mail@cbaines.net> # Add build_servers.lookup_builds make_nar_urls_file_size_optional 2020-06-03T05:27:29Z Christopher Baines <mail@cbaines.net> # Make the nar_urls.file_size optional +translations_for_lint_checker_descriptions 2020-05-22T19:49:37Z daniela <daniela@linux-ijv5> # Support translations for lint checker descriptions diff --git a/sqitch/verify/translations_for_lint_checker_descriptions.sql b/sqitch/verify/translations_for_lint_checker_descriptions.sql new file mode 100644 index 0000000..7736f88 --- /dev/null +++ b/sqitch/verify/translations_for_lint_checker_descriptions.sql @@ -0,0 +1,7 @@ +-- Verify guix-data-service:translations_for_lint_checker_descriptions on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; |