history.sql RawHistoryFolder

1-- name: GetHistory :many
2SELECT *
3FROM history
4ORDER BY last_visited DESC
5LIMIT ?;
6
7-- name: GetHistoryWithOffset :many
8SELECT *
9FROM history
10ORDER BY last_visited DESC
11LIMIT ? OFFSET ?;
12
13-- name: AddOrUpdateHistory :exec
14INSERT INTO history (url, title) 
15VALUES (?, ?)
16ON CONFLICT(url) 
17DO UPDATE SET 
18    visit_count = visit_count + 1,
19    last_visited = CURRENT_TIMESTAMP,
20    title = EXCLUDED.title;
21
22-- name: SearchHistory :many
23SELECT *
24FROM history 
25WHERE url LIKE '%' || ? || '%' OR title LIKE '%' || ? || '%'
26ORDER BY visit_count DESC, last_visited DESC
27LIMIT ?;
28
29-- name: UpdateHistoryFavicon :exec
30UPDATE history 
31SET favicon_url = ?
32WHERE url = ?;
33
34-- name: DeleteHistory :exec
35DELETE FROM history
36WHERE id = ?;
37
38-- name: GetShortcuts :many
39SELECT id, shortcut, url_template, description, created_at
40FROM shortcuts
41ORDER BY shortcut;