From f3fa1981daf5992342316a5680ae8657eab02c2b Mon Sep 17 00:00:00 2001 From: Ricardo Wurmus Date: Thu, 12 Mar 2020 12:13:29 +0100 Subject: bugs: Use inexact queries for names. * mumi/bugs.scm (bugs-by-submitter, bugs-by-owner): Use LIKE to compare argument. --- mumi/bugs.scm | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/mumi/bugs.scm b/mumi/bugs.scm index ef4a6bf..6e1e367 100644 --- a/mumi/bugs.scm +++ b/mumi/bugs.scm @@ -182,7 +182,8 @@ tags=excluded.tags;") (with-db (lambda (db) (sqlite-exec db - "SELECT id FROM bugs WHERE submitter = " submitter ";"))))) + "SELECT id FROM bugs WHERE submitter LIKE " + (string-append "%" submitter "%") ";"))))) (define (bugs-by-owner owner) "Return all bug ids with the given OWNER." @@ -190,7 +191,8 @@ tags=excluded.tags;") (with-db (lambda (db) (sqlite-exec db - "SELECT id FROM bugs WHERE owner = " owner ";"))))) + "SELECT id FROM bugs WHERE owner LIKE " + (string-append "%" owner "%") ";"))))) (define (bugs-by-tag tag) "Return all bug ids that match the given TAG." -- cgit v1.2.3