diff options
| author | adamdottv <[email protected]> | 2025-05-09 13:37:13 -0500 |
|---|---|---|
| committer | adamdottv <[email protected]> | 2025-05-09 13:37:13 -0500 |
| commit | f1007771997bd0401516eda87a7e0ac92f269680 (patch) | |
| tree | d26198d031516eaebcc885870b470925492d8775 /internal/db/sql | |
| parent | f41b7bbd0a0cc731fd7c471b7ee8b26f14a21755 (diff) | |
| download | opencode-f1007771997bd0401516eda87a7e0ac92f269680.tar.gz opencode-f1007771997bd0401516eda87a7e0ac92f269680.zip | |
wip: logging improvements
Diffstat (limited to 'internal/db/sql')
| -rw-r--r-- | internal/db/sql/logs.sql | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/internal/db/sql/logs.sql b/internal/db/sql/logs.sql new file mode 100644 index 000000000..1a0655f7e --- /dev/null +++ b/internal/db/sql/logs.sql @@ -0,0 +1,28 @@ +-- name: CreateLog :exec +INSERT INTO logs ( + id, + session_id, + timestamp, + level, + message, + attributes, + created_at +) VALUES ( + ?, + ?, + ?, + ?, + ?, + ?, + ? +); + +-- name: ListLogsBySession :many +SELECT * FROM logs +WHERE session_id = ? +ORDER BY timestamp ASC; + +-- name: ListAllLogs :many +SELECT * FROM logs +ORDER BY timestamp DESC +LIMIT ?;
\ No newline at end of file |