diff options
| -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))) |