favorites.sql RawHistoryFolder

1-- name: GetAllFavorites :many
2SELECT * FROM favorites ORDER BY position ASC;
3
4-- name: GetFavoriteByID :one
5SELECT * FROM favorites WHERE id = ? LIMIT 1;
6
7-- name: GetFavoriteByURL :one
8SELECT * FROM favorites WHERE url = ? LIMIT 1;
9
10-- name: GetFavoritesByFolder :many
11SELECT * FROM favorites WHERE folder_id = ? ORDER BY position ASC;
12
13-- name: GetFavoritesWithoutFolder :many
14SELECT * FROM favorites WHERE folder_id IS NULL ORDER BY position ASC;
15
16-- name: GetFavoriteByShortcut :one
17SELECT * FROM favorites WHERE shortcut_key = ? LIMIT 1;
18
19-- name: CreateFavorite :one
20INSERT INTO favorites (url, title, favicon_url, folder_id, position, created_at, updated_at)
21VALUES (?, ?, ?, ?, COALESCE((SELECT MAX(position) + 1 FROM favorites), 0), CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)
22RETURNING *;
23
24-- name: UpdateFavorite :exec
25UPDATE favorites
26SET title = ?, favicon_url = ?, updated_at = CURRENT_TIMESTAMP
27WHERE id = ?;
28
29-- name: UpdateFavoritePosition :exec
30UPDATE favorites SET position = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?;
31
32-- name: SetFavoriteFolder :exec
33UPDATE favorites SET folder_id = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?;
34
35-- name: SetFavoriteShortcut :exec
36UPDATE favorites SET shortcut_key = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?;
37
38-- name: DeleteFavorite :exec
39DELETE FROM favorites WHERE id = ?;