From 9e779891fa91f44a9734b79ccb4f6aef48a0de3f Mon Sep 17 00:00:00 2001 From: Leonardo Bishop Date: Thu, 18 Sep 2025 21:00:28 +0100 Subject: Add filters on html page --- pkg/database/query/entries.sql | 6 ++++++ pkg/database/query/kinds.sql | 2 ++ 2 files changed, 8 insertions(+) create mode 100644 pkg/database/query/kinds.sql (limited to 'pkg/database/query') diff --git a/pkg/database/query/entries.sql b/pkg/database/query/entries.sql index 9584adf..37d11ce 100644 --- a/pkg/database/query/entries.sql +++ b/pkg/database/query/entries.sql @@ -20,6 +20,12 @@ SELECT title, url, description, timestamp, kinds.name as kind_name, kinds.emoji JOIN kinds ON entries.kind == kinds.id ORDER BY timestamp DESC; +-- name: GetEntriesByKind :many +SELECT title, url, description, timestamp, kinds.name as kind_name, kinds.emoji as kind_emoji FROM entries +JOIN kinds ON entries.kind == kinds.id +WHERE kinds.name = ? +ORDER BY timestamp DESC; + -- name: GetEntryURLs :many SELECT url FROM entries ORDER BY timestamp DESC; diff --git a/pkg/database/query/kinds.sql b/pkg/database/query/kinds.sql new file mode 100644 index 0000000..91917f3 --- /dev/null +++ b/pkg/database/query/kinds.sql @@ -0,0 +1,2 @@ +-- name: GetKinds :many +SELECT * FROM kinds; -- cgit v1.2.3-70-g09d2