zoom.sql RawHistoryFolder

1-- name: GetZoomLevel :one
2-- Get zoom level for a specific domain
3SELECT zoom_factor FROM zoom_levels WHERE domain = ? LIMIT 1;
4
5-- name: SetZoomLevel :exec
6-- Set or update zoom level for a domain with validation
7INSERT INTO zoom_levels (domain, zoom_factor, updated_at) 
8VALUES (?, ?, CURRENT_TIMESTAMP) 
9ON CONFLICT(domain) DO UPDATE SET 
10    zoom_factor = excluded.zoom_factor,
11    updated_at = excluded.updated_at;
12
13-- name: DeleteZoomLevel :exec
14-- Delete zoom level setting for a domain
15DELETE FROM zoom_levels WHERE domain = ?;
16
17-- name: ListZoomLevels :many
18-- List all zoom level settings ordered by most recently updated
19SELECT domain, zoom_factor, updated_at FROM zoom_levels ORDER BY updated_at DESC;
20
21-- name: CleanupOldZoomLevels :exec
22-- Cleanup zoom level entries older than specified days
23DELETE FROM zoom_levels WHERE updated_at < datetime('now', '-' || ? || ' days');
24
25-- name: GetZoomLevelWithDefault :one
26-- Get zoom level for domain with default fallback
27SELECT COALESCE(
28    (SELECT zoom_factor FROM zoom_levels WHERE domain = ? LIMIT 1),
29    1.0
30) as zoom_factor;