sessions.sql 727 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950
  1. -- name: CreateSession :one
  2. INSERT INTO sessions (
  3. id,
  4. parent_session_id,
  5. title,
  6. message_count,
  7. prompt_tokens,
  8. completion_tokens,
  9. cost,
  10. summary,
  11. summarized_at
  12. ) VALUES (
  13. ?,
  14. ?,
  15. ?,
  16. ?,
  17. ?,
  18. ?,
  19. ?,
  20. ?,
  21. ?
  22. ) RETURNING *;
  23. -- name: GetSessionByID :one
  24. SELECT *
  25. FROM sessions
  26. WHERE id = ? LIMIT 1;
  27. -- name: ListSessions :many
  28. SELECT *
  29. FROM sessions
  30. WHERE parent_session_id is NULL
  31. ORDER BY created_at DESC;
  32. -- name: UpdateSession :one
  33. UPDATE sessions
  34. SET
  35. title = ?,
  36. prompt_tokens = ?,
  37. completion_tokens = ?,
  38. cost = ?,
  39. summary = ?,
  40. summarized_at = ?
  41. WHERE id = ?
  42. RETURNING *;
  43. -- name: DeleteSession :exec
  44. DELETE FROM sessions
  45. WHERE id = ?;