summaryrefslogtreecommitdiffhomepage
path: root/internal/db/sql/messages.sql
diff options
context:
space:
mode:
Diffstat (limited to 'internal/db/sql/messages.sql')
-rw-r--r--internal/db/sql/messages.sql45
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 = ?;