sessions.sql RawHistoryFolder

1-- name: InsertSession :exec
2INSERT INTO sessions (id, type, started_at, ended_at)
3VALUES (?, ?, ?, ?);
4
5-- name: GetSessionByID :one
6SELECT * FROM sessions WHERE id = ? LIMIT 1;
7
8-- name: GetActiveBrowserSession :one
9SELECT * FROM sessions
10WHERE type = 'browser' AND ended_at IS NULL
11ORDER BY started_at DESC
12LIMIT 1;
13
14-- name: GetRecentSessions :many
15SELECT * FROM sessions
16ORDER BY started_at DESC
17LIMIT ?;
18
19-- name: MarkSessionEnded :exec
20UPDATE sessions
21SET ended_at = ?
22WHERE id = ?;
23
24-- name: DeleteSession :exec
25DELETE FROM sessions WHERE id = ?;
26
27-- name: DeleteOldestExitedSessions :execrows
28-- Deletes exited browser sessions beyond the keep limit, keeping the most recent ones.
29DELETE FROM sessions
30WHERE id IN (
31    SELECT id FROM sessions
32    WHERE type = 'browser' AND ended_at IS NOT NULL
33    ORDER BY ended_at DESC
34    LIMIT -1 OFFSET ?
35);
36
37-- name: DeleteExitedSessionsBefore :execrows
38-- Deletes exited browser sessions older than the given cutoff time.
39DELETE FROM sessions
40WHERE type = 'browser'
41  AND ended_at IS NOT NULL
42  AND ended_at < ?;