1-- name: GetMessage :one
 2SELECT *
 3FROM messages
 4WHERE id = ? LIMIT 1;
 5
 6-- name: ListMessagesBySession :many
 7SELECT *
 8FROM messages
 9WHERE session_id = ?
10ORDER BY created_at ASC;
11
12-- name: CreateMessage :one
13INSERT INTO messages (
14    id,
15    session_id,
16    message_data,
17    created_at,
18    updated_at
19) VALUES (
20    ?, ?, ?, strftime('%s', 'now'), strftime('%s', 'now')
21)
22RETURNING *;
23
24-- name: DeleteMessage :exec
25DELETE FROM messages
26WHERE id = ?;
27
28-- name: DeleteSessionMessages :exec
29DELETE FROM messages
30WHERE session_id = ?;