diff options
| author | Leonardo Bishop <me@leonardobishop.net> | 2025-09-18 21:00:28 +0100 |
|---|---|---|
| committer | Leonardo Bishop <me@leonardobishop.net> | 2025-09-18 21:00:28 +0100 |
| commit | 9e779891fa91f44a9734b79ccb4f6aef48a0de3f (patch) | |
| tree | 7b60a2129966461ed56532768c847595fd371377 /pkg/database/query/entries.sql | |
| parent | 39a926cd521806aedc298ddd671d1a118794fcec (diff) | |
Add filters on html page
Diffstat (limited to 'pkg/database/query/entries.sql')
| -rw-r--r-- | pkg/database/query/entries.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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; |