summaryrefslogtreecommitdiffhomepage
path: root/internal/db
diff options
context:
space:
mode:
authoradamdottv <[email protected]>2025-05-14 13:06:09 -0500
committeradamdottv <[email protected]>2025-05-14 13:06:09 -0500
commit3982be4310aa57209fd4ce2be833c3515f759ba8 (patch)
tree1bf577d7185afb153dd1f3e8fd7c4dbe36bb6448 /internal/db
parent4c998d4f4ff2d9570796a81a95eb84d34d0a6939 (diff)
downloadopencode-3982be4310aa57209fd4ce2be833c3515f759ba8.tar.gz
opencode-3982be4310aa57209fd4ce2be833c3515f759ba8.zip
feat: session specific logs
Diffstat (limited to 'internal/db')
-rw-r--r--internal/db/logs.sql.go2
-rw-r--r--internal/db/sql/logs.sql2
2 files changed, 2 insertions, 2 deletions
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