iens

commit 3a833ff740b918ab61a02759ac1ca0a50a0a0d2b
parent df4d945e8708c1f58ade4338917be64ff31de558
Author: Natasha Kerensikova <natgh@instinctive.eu>
Date:   Sun, 16 Aug 2026 13:43:08 +0000

Comment URL being null or empty is equivalent
Diffstat:
M
src/get-gruiks.scm
 | 
5
+++--

1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/get-gruiks.scm b/src/get-gruiks.scm
@@ -78,8 +78,9 @@
                                              ||'Previously “'||title||'”',
                                              char(10)),
                                   mtime=CAST(strftime('%s', 'now') AS INT)
-                              WHERE url=? AND section=? AND comment_url=?;")
-                     title url source (if comm comm '())))
+                              WHERE url=? AND section=?
+                                AND COALESCE(comment_url,'')=?;")
+                     title url source (if comm comm "")))
       (exec
         (sql db "INSERT INTO gruik(position, notes, ptime,
                                    section, url, title, comment_url,