favorites.sql RawHistoryFolder

1-- name: GetAllFavorites :many
2-- Get all favorites ordered by position
3SELECT *
4FROM favorites
5ORDER BY position ASC;
6
7-- name: GetFavoriteByURL :one
8-- Get a specific favorite by URL
9SELECT *
10FROM favorites
11WHERE url = ?
12LIMIT 1;
13
14-- name: CreateFavorite :exec
15-- Insert a new favorite with auto-incremented position
16INSERT INTO favorites (url, title, favicon_url, position, created_at, updated_at)
17VALUES (
18    ?,
19    ?,
20    ?,
21    COALESCE((SELECT MAX(position) + 1 FROM favorites), 0),
22    CURRENT_TIMESTAMP,
23    CURRENT_TIMESTAMP
24);
25
26-- name: UpdateFavorite :exec
27-- Update favorite metadata (title, favicon)
28UPDATE favorites
29SET
30    title = ?,
31    favicon_url = ?,
32    updated_at = CURRENT_TIMESTAMP
33WHERE url = ?;
34
35-- name: DeleteFavorite :exec
36-- Delete a favorite by URL
37DELETE FROM favorites
38WHERE url = ?;
39
40-- name: IsFavorite :one
41-- Check if a URL is favorited
42SELECT COUNT(*) as count
43FROM favorites
44WHERE url = ?
45LIMIT 1;
46
47-- name: UpdateFavoritePosition :exec
48-- Update the position of a favorite
49UPDATE favorites
50SET
51    position = ?,
52    updated_at = CURRENT_TIMESTAMP
53WHERE url = ?;
54
55-- name: GetFavoriteCount :one
56-- Get total count of favorites
57SELECT COUNT(*) as count
58FROM favorites;