From 4818bc542611b3ab554824fece8a071b0ac6307b Mon Sep 17 00:00:00 2001 From: adamdottv <2363879+adamdottv@users.noreply.github.com> Date: Thu, 29 May 2025 15:41:13 -0500 Subject: wip: refactoring tui --- internal/db/sql/messages.sql | 45 -------------------------------------------- 1 file changed, 45 deletions(-) delete mode 100644 internal/db/sql/messages.sql (limited to 'internal/db/sql/messages.sql') 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 = ?; -- cgit v1.2.3