summaryrefslogtreecommitdiffhomepage
path: root/internal/db
diff options
context:
space:
mode:
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