From 3982be4310aa57209fd4ce2be833c3515f759ba8 Mon Sep 17 00:00:00 2001
From: adamdottv <2363879+adamdottv@users.noreply.github.com>
Date: Wed, 14 May 2025 13:06:09 -0500
Subject: feat: session specific logs

---
 internal/db/logs.sql.go  | 2 +-
 internal/db/sql/logs.sql | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

(limited to 'internal/db')

diff --git a/internal/db/logs.sql.go b/internal/db/logs.sql.go
index 5c6ea6722..343b34d7c 100644
--- a/internal/db/logs.sql.go
+++ b/internal/db/logs.sql.go
@@ -101,7 +101,7 @@ func (q *Queries) ListAllLogs(ctx context.Context, limit int64) ([]Log, error) {
 const listLogsBySession = `-- name: ListLogsBySession :many
 SELECT id, session_id, timestamp, level, message, attributes, created_at, updated_at FROM logs
 WHERE session_id = ?
-ORDER BY timestamp ASC
+ORDER BY timestamp DESC
 `
 
 func (q *Queries) ListLogsBySession(ctx context.Context, sessionID sql.NullString) ([]Log, error) {
diff --git a/internal/db/sql/logs.sql b/internal/db/sql/logs.sql
index 4fc640830..9d20800d9 100644
--- a/internal/db/sql/logs.sql
+++ b/internal/db/sql/logs.sql
@@ -18,7 +18,7 @@ INSERT INTO logs (
 -- name: ListLogsBySession :many
 SELECT * FROM logs
 WHERE session_id = ?
-ORDER BY timestamp ASC;
+ORDER BY timestamp DESC;
 
 -- name: ListAllLogs :many
 SELECT * FROM logs
-- 
cgit v1.2.3