diff options
Diffstat (limited to 'pkg/database/query')
| -rw-r--r-- | pkg/database/query/entries.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/pkg/database/query/entries.sql b/pkg/database/query/entries.sql index 1f39016..9584adf 100644 --- a/pkg/database/query/entries.sql +++ b/pkg/database/query/entries.sql @@ -5,7 +5,27 @@ FROM kinds WHERE kinds.name = ? RETURNING *; +-- name: UpdateEntryKind :one +UPDATE entries +SET kind = (SELECT id FROM kinds WHERE kinds.name = ?) +WHERE entries.id = ? +RETURNING *; + +-- name: DeleteEntry :execrows +DELETE FROM entries +WHERE id = ?; + -- name: GetEntries :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 ORDER BY timestamp DESC; + +-- name: GetEntryURLs :many +SELECT url FROM entries +ORDER BY timestamp DESC; + +-- name: GetEntryByUrl :one +SELECT entries.id, title, url, description, timestamp, kinds.name as kind_name, kinds.emoji as kind_emoji FROM entries +JOIN kinds ON entries.kind == kinds.id +WHERE url = ? +LIMIT 1; |