From 125a35fce557ed0c73872944c04ec39d10b4ca1c Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Fri, 2 Oct 2020 17:52:07 +0100 Subject: Reformat lint warning related query --- guix-data-service/model/lint-warning-message.scm | 23 ++++++++++++----------- 1 file 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))) -- cgit v1.2.3