diff options
Diffstat (limited to 'internal/db/sql/messages.sql')
| -rw-r--r-- | internal/db/sql/messages.sql | 45 |
1 files changed, 0 insertions, 45 deletions
diff --git a/internal/db/sql/messages.sql b/internal/db/sql/messages.sql deleted file mode 100644 index 6a3b69f6f..000000000 --- a/internal/db/sql/messages.sql +++ /dev/null @@ -1,45 +0,0 @@ --- name: GetMessage :one -SELECT * -FROM messages -WHERE id = ? LIMIT 1; - --- name: ListMessagesBySession :many -SELECT * -FROM messages -WHERE session_id = ? -ORDER BY created_at ASC; - --- name: ListMessagesBySessionAfter :many -SELECT * -FROM messages -WHERE session_id = ? AND created_at > ? -ORDER BY created_at ASC; - --- name: CreateMessage :one -INSERT INTO messages ( - id, - session_id, - role, - parts, - model -) VALUES ( - ?, ?, ?, ?, ? -) -RETURNING *; - --- name: UpdateMessage :exec -UPDATE messages -SET - parts = ?, - finished_at = ?, - updated_at = strftime('%Y-%m-%dT%H:%M:%f000Z', 'now') -WHERE id = ?; - - --- name: DeleteMessage :exec -DELETE FROM messages -WHERE id = ?; - --- name: DeleteSessionMessages :exec -DELETE FROM messages -WHERE session_id = ?; |
