favicon.sql RawHistoryFolder

1-- name: GetFavicon :one
2SELECT * FROM favicons WHERE key = ? LIMIT 1;
3
4-- name: UpsertFavicon :exec
5INSERT INTO favicons (
6    key,
7    source_url,
8    page_url,
9    source,
10    content_hash,
11    content_type,
12    updated_at,
13    last_checked_at
14)
15VALUES (?, ?, ?, ?, ?, ?, ?, ?)
16ON CONFLICT(key) DO UPDATE SET
17    source_url = EXCLUDED.source_url,
18    page_url = EXCLUDED.page_url,
19    source = EXCLUDED.source,
20    content_hash = EXCLUDED.content_hash,
21    content_type = EXCLUDED.content_type,
22    updated_at = EXCLUDED.updated_at,
23    last_checked_at = EXCLUDED.last_checked_at;
24
25-- name: UpdateFaviconLastChecked :exec
26UPDATE favicons
27SET content_hash = ?, last_checked_at = ?
28WHERE key = ?;
29
30-- name: DeleteFavicon :exec
31DELETE FROM favicons WHERE key = ?;