folders.sql RawHistoryFolder

1-- name: GetAllFolders :many
2SELECT * FROM favorite_folders ORDER BY position ASC;
3
4-- name: GetFolderByID :one
5SELECT * FROM favorite_folders WHERE id = ? LIMIT 1;
6
7-- name: GetChildFolders :many
8SELECT * FROM favorite_folders WHERE parent_id = ? ORDER BY position ASC;
9
10-- name: GetRootFolders :many
11SELECT * FROM favorite_folders WHERE parent_id IS NULL ORDER BY position ASC;
12
13-- name: CreateFolder :one
14INSERT INTO favorite_folders (name, icon, parent_id, position, created_at)
15VALUES (?, ?, ?, COALESCE((SELECT MAX(position) + 1 FROM favorite_folders), 0), CURRENT_TIMESTAMP)
16RETURNING *;
17
18-- name: UpdateFolder :exec
19UPDATE favorite_folders SET name = ?, icon = ? WHERE id = ?;
20
21-- name: UpdateFolderPosition :exec
22UPDATE favorite_folders SET position = ? WHERE id = ?;
23
24-- name: DeleteFolder :exec
25DELETE FROM favorite_folders WHERE id = ?;