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/files.sql    | 69 --------------------------------------------
 internal/db/sql/logs.sql     | 26 -----------------
 internal/db/sql/messages.sql | 45 -----------------------------
 internal/db/sql/sessions.sql | 50 --------------------------------
 4 files changed, 190 deletions(-)
 delete mode 100644 internal/db/sql/files.sql
 delete mode 100644 internal/db/sql/logs.sql
 delete mode 100644 internal/db/sql/messages.sql
 delete mode 100644 internal/db/sql/sessions.sql

(limited to 'internal/db/sql')

diff --git a/internal/db/sql/files.sql b/internal/db/sql/files.sql
deleted file mode 100644
index 560a6984f..000000000
--- a/internal/db/sql/files.sql
+++ /dev/null
@@ -1,69 +0,0 @@
--- name: GetFile :one
-SELECT *
-FROM files
-WHERE id = ? LIMIT 1;
-
--- name: GetFileByPathAndSession :one
-SELECT *
-FROM files
-WHERE path = ? AND session_id = ?
-ORDER BY created_at DESC
-LIMIT 1;
-
--- name: ListFilesBySession :many
-SELECT *
-FROM files
-WHERE session_id = ?
-ORDER BY created_at ASC;
-
--- name: ListFilesByPath :many
-SELECT *
-FROM files
-WHERE path = ?
-ORDER BY created_at DESC;
-
--- name: CreateFile :one
-INSERT INTO files (
-    id,
-    session_id,
-    path,
-    content,
-    version
-) VALUES (
-    ?, ?, ?, ?, ?
-)
-RETURNING *;
-
--- name: UpdateFile :one
-UPDATE files
-SET
-    content = ?,
-    version = ?,
-    updated_at = strftime('%Y-%m-%dT%H:%M:%f000Z', 'now')
-WHERE id = ?
-RETURNING *;
-
--- name: DeleteFile :exec
-DELETE FROM files
-WHERE id = ?;
-
--- name: DeleteSessionFiles :exec
-DELETE FROM files
-WHERE session_id = ?;
-
--- name: ListLatestSessionFiles :many
-SELECT f.*
-FROM files f
-INNER JOIN (
-    SELECT path, MAX(created_at) as max_created_at
-    FROM files
-    GROUP BY path
-) latest ON f.path = latest.path AND f.created_at = latest.max_created_at
-WHERE f.session_id = ?
-ORDER BY f.path;
-
--- name: ListNewFiles :many
-SELECT *
-FROM files
-WHERE is_new = 1
-ORDER BY created_at DESC;
diff --git a/internal/db/sql/logs.sql b/internal/db/sql/logs.sql
deleted file mode 100644
index 9d20800d9..000000000
--- a/internal/db/sql/logs.sql
+++ /dev/null
@@ -1,26 +0,0 @@
--- name: CreateLog :one
-INSERT INTO logs (
-    id,
-    session_id,
-    timestamp,
-    level,
-    message,
-    attributes
-) VALUES (
-    ?,
-    ?,
-    ?,
-    ?,
-    ?,
-    ?
-) RETURNING *;
-
--- name: ListLogsBySession :many
-SELECT * FROM logs
-WHERE session_id = ?
-ORDER BY timestamp DESC;
-
--- name: ListAllLogs :many
-SELECT * FROM logs
-ORDER BY timestamp DESC
-LIMIT ?;
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 = ?;
diff --git a/internal/db/sql/sessions.sql b/internal/db/sql/sessions.sql
deleted file mode 100644
index fd7ffe56c..000000000
--- a/internal/db/sql/sessions.sql
+++ /dev/null
@@ -1,50 +0,0 @@
--- name: CreateSession :one
-INSERT INTO sessions (
-    id,
-    parent_session_id,
-    title,
-    message_count,
-    prompt_tokens,
-    completion_tokens,
-    cost,
-    summary,
-    summarized_at
-) VALUES (
-    ?,
-    ?,
-    ?,
-    ?,
-    ?,
-    ?,
-    ?,
-    ?,
-    ?
-) RETURNING *;
-
--- name: GetSessionByID :one
-SELECT *
-FROM sessions
-WHERE id = ? LIMIT 1;
-
--- name: ListSessions :many
-SELECT *
-FROM sessions
-WHERE parent_session_id is NULL
-ORDER BY created_at DESC;
-
--- name: UpdateSession :one
-UPDATE sessions
-SET
-    title = ?,
-    prompt_tokens = ?,
-    completion_tokens = ?,
-    cost = ?,
-    summary = ?,
-    summarized_at = ?
-WHERE id = ?
-RETURNING *;
-
-
--- name: DeleteSession :exec
-DELETE FROM sessions
-WHERE id = ?;
-- 
cgit v1.2.3