branch master updated: Fix the select-source-files-missing-nars query

[Christopher Baines]

This is an automated email from the git hooks/post-receive script.

cbaines pushed a commit to branch master
in repository data-service.

The following commit(s) were added to refs/heads/master by this push:
     new 8b34126  Fix the select-source-files-missing-nars query
8b34126 is described below

commit 8b34126d220c8375ac185955f540dc13fd38e446
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Thu Sep 16 17:01:34 2021 +0100

    Fix the select-source-files-missing-nars query
    
    Previously, the VALUES list wasn't being generated properly.
---
 guix-data-service/model/derivation.scm | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

diff --git a/guix-data-service/model/derivation.scm 
b/guix-data-service/model/derivation.scm
index 9c58dd0..3e882cb 100644
--- a/guix-data-service/model/derivation.scm
+++ b/guix-data-service/model/derivation.scm
@@ -1753,10 +1753,13 @@ WHERE " criteria ";"))
        "
 WITH RECURSIVE all_derivations AS (
     SELECT column1 AS derivation_id
-    FROM (VALUES ("
-       (string-join (map number->string ids)
+    FROM (VALUES "
+       (string-join (map
+                     (lambda (id)
+                       (string-append "(" id ")"))
+                     (map number->string ids))
                     ", ")
-       ")) AS data
+       ") AS data
   UNION
     SELECT derivation_outputs.derivation_id
     FROM all_derivations