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: GetHistoryEntry :one
35SELECT *
36FROM history
37WHERE url = ?
38LIMIT 1;
39
40-- name: DeleteHistory :exec
41DELETE FROM history
42WHERE id = ?;