[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
02/06: Reformat lint warning related query
From: |
Christopher Baines |
Subject: |
02/06: Reformat lint warning related query |
Date: |
Fri, 2 Oct 2020 15:15:39 -0400 (EDT) |
cbaines pushed a commit to branch master
in repository data-service.
commit 125a35fce557ed0c73872944c04ec39d10b4ca1c
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Fri Oct 2 17:52:07 2020 +0100
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)))
- branch master updated (6e0e33a -> 470573b), Christopher Baines, 2020/10/02
- 02/06: Reformat lint warning related query,
Christopher Baines <=
- 01/06: Speed up a query for derivation builds, Christopher Baines, 2020/10/02
- 05/06: Add an index for derivation_sources.derivation_source_file_id, Christopher Baines, 2020/10/02
- 04/06: Make with-postgresql-connection work with multiple values, Christopher Baines, 2020/10/02
- 06/06: Delete derivation_source_files that are unreferenced, Christopher Baines, 2020/10/02
- 03/06: Change a constraint to add ON DELETE CASCADE, Christopher Baines, 2020/10/02