diff options
| author | Leonardo Bishop <me@leonardobishop.net> | 2025-09-09 22:44:09 +0100 |
|---|---|---|
| committer | Leonardo Bishop <me@leonardobishop.net> | 2025-09-09 22:44:09 +0100 |
| commit | f1741a7faa9538e9b12ac60e0fbf6c7721a36059 (patch) | |
| tree | 2b70b14fc20a8520718910a0cd2e0134790c6f53 /pkg/database/query | |
Initial commit
Diffstat (limited to 'pkg/database/query')
| -rw-r--r-- | pkg/database/query/entries.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/pkg/database/query/entries.sql b/pkg/database/query/entries.sql new file mode 100644 index 0000000..1927468 --- /dev/null +++ b/pkg/database/query/entries.sql @@ -0,0 +1,11 @@ +-- name: CreateEntryWithKindName :one +INSERT INTO entries (title, kind, url, description) +SELECT ?, kinds.id, ?, ? +FROM kinds +WHERE kinds.name = ? +RETURNING *; + +-- name: GetEntries :many +SELECT title, url, description, timestamp, kinds.name as kind_name, kinds.emoji as kind_emoji FROM entries +JOIN kinds ON entries.id == kinds.id +ORDER BY timestamp DESC; |