From 69bc97bdbe330c084d9937360dd11c04b617033d Mon Sep 17 00:00:00 2001
From: Jordan <me@jordan.im>
Date: Sun, 26 Dec 2021 20:55:20 -0700
Subject: web, db: add wildcard URL search

---
 db.go | 16 +++++++++++++++-
 1 file changed, 15 insertions(+), 1 deletion(-)

(limited to 'db.go')

diff --git a/db.go b/db.go
index 6aa53a5..7521666 100644
--- a/db.go
+++ b/db.go
@@ -156,7 +156,7 @@ func (db *SqliteDB) Stats() (*Stats, error) {
 }
 
 func (db *SqliteDB) ListEntries(limit int, offset int, user string,
-	guild string, channel string) (*[]Entry, error) {
+	guild string, channel string, search string) (*[]Entry, error) {
 
 	query := `
 		SELECT urls.id, urls.url, users.user_id, guilds.guild_id, channels.channel_id, status_code
@@ -202,6 +202,20 @@ func (db *SqliteDB) ListEntries(limit int, offset int, user string,
 			args = append(args, channel)
 		}
 	}
+	if search != "" {
+		if !hasWhere {
+			query = fmt.Sprintf(`%s
+			WHERE urls.url LIKE '%%' || ? || '%%'
+			`, query)
+			args = append(args, search)
+			hasWhere = true
+		} else {
+			query = fmt.Sprintf(`%s
+			AND urls.url LIKE '%%' || ? || '%%'
+			`, query)
+			args = append(args, search)
+		}
+	}
 	query = fmt.Sprintf(`%s
 		ORDER BY urls.id DESC
 		LIMIT ? OFFSET ?;`, query)
-- 
cgit v1.2.3-54-g00ecf