logs.sql 389 B

12345678910111213141516171819202122232425262728
  1. -- name: CreateLog :one
  2. INSERT INTO logs (
  3. id,
  4. session_id,
  5. timestamp,
  6. level,
  7. message,
  8. attributes,
  9. created_at
  10. ) VALUES (
  11. ?,
  12. ?,
  13. ?,
  14. ?,
  15. ?,
  16. ?,
  17. ?
  18. ) RETURNING *;
  19. -- name: ListLogsBySession :many
  20. SELECT * FROM logs
  21. WHERE session_id = ?
  22. ORDER BY timestamp ASC;
  23. -- name: ListAllLogs :many
  24. SELECT * FROM logs
  25. ORDER BY timestamp DESC
  26. LIMIT ?;