[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
01/06: Set an order for select-outputs-without-known-nar-entries
From: |
Christopher Baines |
Subject: |
01/06: Set an order for select-outputs-without-known-nar-entries |
Date: |
Sat, 14 Mar 2020 09:15:25 -0400 (EDT) |
cbaines pushed a commit to branch master
in repository data-service.
commit 6e81acf0a5c0b75c3f491d875753ae4231aac55d
Author: Christopher Baines <address@hidden>
AuthorDate: Fri Mar 13 23:34:56 2020 +0000
Set an order for select-outputs-without-known-nar-entries
Pulling out the recent entries first.
---
guix-data-service/model/nar.scm | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/guix-data-service/model/nar.scm b/guix-data-service/model/nar.scm
index 4c5d070..ff6a5d5 100644
--- a/guix-data-service/model/nar.scm
+++ b/guix-data-service/model/nar.scm
@@ -305,7 +305,7 @@ ORDER BY COUNT(*) DESC")
(define query
(string-append
"
-SELECT DISTINCT derivation_output_details.path
+SELECT DISTINCT derivation_output_details.path, derivation_output_details.id
FROM derivations
INNER JOIN derivation_outputs
ON derivations.id = derivation_outputs.derivation_id
@@ -346,6 +346,7 @@ WHERE derivation_output_details.path NOT IN (
")
)"))
"
+ORDER BY derivation_output_details.id DESC
LIMIT 10000"))
(map car (exec-query conn query (list (number->string build-server-id)))))
- branch master updated (baeae56 -> ded4df6), Christopher Baines, 2020/03/14
- 02/06: Increase the batch size for fetching builds/narinfo files, Christopher Baines, 2020/03/14
- 01/06: Set an order for select-outputs-without-known-nar-entries,
Christopher Baines <=
- 04/06: Improve the 404 pages, Christopher Baines, 2020/03/14
- 05/06: Provide more information if the server can't bind the port, Christopher Baines, 2020/03/14
- 06/06: Move and improve the "starting the server" message, Christopher Baines, 2020/03/14
- 03/06: Improve handling of errors, Christopher Baines, 2020/03/14