git.iko.soy/crush
on cfdca35 help sign in
crush/internal/db/sql/sessions.sql
74 lines 1.2 kB history raw
1-- name: CreateSession :one
2INSERT INTO sessions (
3 id,
4 parent_session_id,
5 title,
6 message_count,
7 prompt_tokens,
8 completion_tokens,
9 cost,
10 summary_message_id,
11 updated_at,
12 created_at
13) VALUES (
14 ?,
15 ?,
16 ?,
17 ?,
18 ?,
19 ?,
20 ?,
21 null,
22 strftime('%s', 'now'),
23 strftime('%s', 'now')
24) RETURNING *;
26-- name: GetSessionByID :one
27SELECT *
28FROM sessions
29WHERE id = ? LIMIT 1;
31-- name: GetLastSession :one
32SELECT *
33FROM sessions
34ORDER BY updated_at DESC
35LIMIT 1;
37-- name: ListSessions :many
38SELECT *
39FROM sessions
40WHERE parent_session_id is NULL
41ORDER BY updated_at DESC;
43-- name: UpdateSession :one
44UPDATE sessions
45SET
46 title = ?,
47 prompt_tokens = ?,
48 completion_tokens = ?,
49 summary_message_id = ?,
50 cost = ?,
51 todos = ?
52WHERE id = ?
53RETURNING *;
55-- name: UpdateSessionTitleAndUsage :exec
56UPDATE sessions
57SET
58 title = ?,
59 prompt_tokens = prompt_tokens + ?,
60 completion_tokens = completion_tokens + ?,
61 cost = cost + ?,
62 updated_at = strftime('%s', 'now')
63WHERE id = ?;
66-- name: RenameSession :exec
67UPDATE sessions
68SET
69 title = ?
70WHERE id = ?;
72-- name: DeleteSession :exec
73DELETE FROM sessions
74WHERE id = ?;