Start handling ids as numbers, rather than strings

squee, returns all data as strings, and expects strings as inputs to
queries. So, keeping the ids as strings was easy initially, but it means that
you can't tell from the type whether it should be quoted, or not...

Therefore, handle ids as strings, converting them to numbers when they're
fetched from the database, and back to strings as part of the queries.

1 files changed, 7 insertions, 6 deletions

diff --git a/guix-data-service/model/lint-warning-message.scm b/guix-data-service/model/lint-warning-message.scm
index 7e54e41..85183a3 100644
--- a/guix-data-service/model/lint-warning-message.scm
+++ b/guix-data-service/model/lint-warning-message.scm
@@ -26,7 +26,7 @@
            "('{"
            (string-join
             (map number->string
-                 (sort (map string->number lint-message-ids) <))
+                 (sort lint-message-ids <))
             ", ")
            "}')")
           " RETURNING id")))
@@ -47,10 +47,11 @@
            (string-append
             "SELECT id FROM lint_warning_message_sets "
             "WHERE message_ids = ARRAY["
-            (string-join lint-warning-message-ids ", ")
+            (string-join (map number->string lint-warning-message-ids) ", ")
             "]"))))
 
-    (match lint-message-set-id
-      (((id)) id)
-      (()
-       (insert-lint-warning-message-set conn lint-warning-message-ids)))))
+    (string->number
+     (match lint-message-set-id
+       (((id)) id)
+       (()
+        (insert-lint-warning-message-set conn lint-warning-message-ids))))))