File size: 1,207 Bytes
e089492 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 | -- name: CreateSession :one
INSERT INTO sessions (
id,
parent_session_id,
title,
message_count,
prompt_tokens,
completion_tokens,
cost,
summary_message_id,
updated_at,
created_at
) VALUES (
?,
?,
?,
?,
?,
?,
?,
null,
strftime('%s', 'now'),
strftime('%s', 'now')
) RETURNING *;
-- name: GetSessionByID :one
SELECT *
FROM sessions
WHERE id = ? LIMIT 1;
-- name: GetLastSession :one
SELECT *
FROM sessions
ORDER BY updated_at DESC
LIMIT 1;
-- name: ListSessions :many
SELECT *
FROM sessions
WHERE parent_session_id is NULL
ORDER BY updated_at DESC;
-- name: UpdateSession :one
UPDATE sessions
SET
title = ?,
prompt_tokens = ?,
completion_tokens = ?,
summary_message_id = ?,
cost = ?,
todos = ?
WHERE id = ?
RETURNING *;
-- name: UpdateSessionTitleAndUsage :exec
UPDATE sessions
SET
title = ?,
prompt_tokens = prompt_tokens + ?,
completion_tokens = completion_tokens + ?,
cost = cost + ?,
updated_at = strftime('%s', 'now')
WHERE id = ?;
-- name: RenameSession :exec
UPDATE sessions
SET
title = ?
WHERE id = ?;
-- name: DeleteSession :exec
DELETE FROM sessions
WHERE id = ?;
|