diff options
| author | Christopher Baines <mail@cbaines.net> | 2020-10-02 17:52:07 +0100 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2020-10-02 17:52:07 +0100 |
| commit | 125a35fce557ed0c73872944c04ec39d10b4ca1c (patch) | |
| tree | 02d8b4d2cd56d5f743b7d4c0e095730ae78d0afe | |
| parent | af40c1ac139d43dd91d11c0af6fcf597833ccf83 (diff) | |
| download | data-service-125a35fce557ed0c73872944c04ec39d10b4ca1c.tar data-service-125a35fce557ed0c73872944c04ec39d10b4ca1c.tar.gz | |
Reformat lint warning related query
| -rw-r--r-- | guix-data-service/model/lint-warning-message.scm | 23 |
1 files changed, 12 insertions, 11 deletions
diff --git a/guix-data-service/model/lint-warning-message.scm b/guix-data-service/model/lint-warning-message.scm index 1d736b4..72a8617 100644 --- a/guix-data-service/model/lint-warning-message.scm +++ b/guix-data-service/model/lint-warning-message.scm @@ -77,15 +77,16 @@ (define (lint-warning-message-locales-for-revision conn commit-hash) (exec-query conn - "SELECT DISTINCT lint_warning_messages.locale - from lint_warning_messages - INNER JOIN lint_warning_message_sets - ON lint_warning_messages.id = ANY (lint_warning_message_sets.message_ids) - INNER JOIN lint_warnings - ON lint_warning_message_sets.id = lint_warnings.lint_warning_message_set_id - INNER JOIN guix_revision_lint_warnings - ON lint_warnings.id = guix_revision_lint_warnings.lint_warning_id - INNER JOIN guix_revisions - ON guix_revision_lint_warnings.guix_revision_id = guix_revisions.id - AND guix_revisions.commit = $1" + " +SELECT DISTINCT lint_warning_messages.locale +FROM lint_warning_messages +INNER JOIN lint_warning_message_sets + ON lint_warning_messages.id = ANY (lint_warning_message_sets.message_ids) +INNER JOIN lint_warnings + ON lint_warning_message_sets.id = lint_warnings.lint_warning_message_set_id +INNER JOIN guix_revision_lint_warnings + ON lint_warnings.id = guix_revision_lint_warnings.lint_warning_id +INNER JOIN guix_revisions + ON guix_revision_lint_warnings.guix_revision_id = guix_revisions.id + AND guix_revisions.commit = $1" (list commit-hash))) |