logs.sql.go 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128
  1. // Code generated by sqlc. DO NOT EDIT.
  2. // versions:
  3. // sqlc v1.29.0
  4. // source: logs.sql
  5. package db
  6. import (
  7. "context"
  8. "database/sql"
  9. )
  10. const createLog = `-- name: CreateLog :exec
  11. INSERT INTO logs (
  12. id,
  13. session_id,
  14. timestamp,
  15. level,
  16. message,
  17. attributes,
  18. created_at
  19. ) VALUES (
  20. ?,
  21. ?,
  22. ?,
  23. ?,
  24. ?,
  25. ?,
  26. ?
  27. )
  28. `
  29. type CreateLogParams struct {
  30. ID string `json:"id"`
  31. SessionID sql.NullString `json:"session_id"`
  32. Timestamp int64 `json:"timestamp"`
  33. Level string `json:"level"`
  34. Message string `json:"message"`
  35. Attributes sql.NullString `json:"attributes"`
  36. CreatedAt int64 `json:"created_at"`
  37. }
  38. func (q *Queries) CreateLog(ctx context.Context, arg CreateLogParams) error {
  39. _, err := q.exec(ctx, q.createLogStmt, createLog,
  40. arg.ID,
  41. arg.SessionID,
  42. arg.Timestamp,
  43. arg.Level,
  44. arg.Message,
  45. arg.Attributes,
  46. arg.CreatedAt,
  47. )
  48. return err
  49. }
  50. const listAllLogs = `-- name: ListAllLogs :many
  51. SELECT id, session_id, timestamp, level, message, attributes, created_at FROM logs
  52. ORDER BY timestamp DESC
  53. LIMIT ?
  54. `
  55. func (q *Queries) ListAllLogs(ctx context.Context, limit int64) ([]Log, error) {
  56. rows, err := q.query(ctx, q.listAllLogsStmt, listAllLogs, limit)
  57. if err != nil {
  58. return nil, err
  59. }
  60. defer rows.Close()
  61. items := []Log{}
  62. for rows.Next() {
  63. var i Log
  64. if err := rows.Scan(
  65. &i.ID,
  66. &i.SessionID,
  67. &i.Timestamp,
  68. &i.Level,
  69. &i.Message,
  70. &i.Attributes,
  71. &i.CreatedAt,
  72. ); err != nil {
  73. return nil, err
  74. }
  75. items = append(items, i)
  76. }
  77. if err := rows.Close(); err != nil {
  78. return nil, err
  79. }
  80. if err := rows.Err(); err != nil {
  81. return nil, err
  82. }
  83. return items, nil
  84. }
  85. const listLogsBySession = `-- name: ListLogsBySession :many
  86. SELECT id, session_id, timestamp, level, message, attributes, created_at FROM logs
  87. WHERE session_id = ?
  88. ORDER BY timestamp ASC
  89. `
  90. func (q *Queries) ListLogsBySession(ctx context.Context, sessionID sql.NullString) ([]Log, error) {
  91. rows, err := q.query(ctx, q.listLogsBySessionStmt, listLogsBySession, sessionID)
  92. if err != nil {
  93. return nil, err
  94. }
  95. defer rows.Close()
  96. items := []Log{}
  97. for rows.Next() {
  98. var i Log
  99. if err := rows.Scan(
  100. &i.ID,
  101. &i.SessionID,
  102. &i.Timestamp,
  103. &i.Level,
  104. &i.Message,
  105. &i.Attributes,
  106. &i.CreatedAt,
  107. ); err != nil {
  108. return nil, err
  109. }
  110. items = append(items, i)
  111. }
  112. if err := rows.Close(); err != nil {
  113. return nil, err
  114. }
  115. if err := rows.Err(); err != nil {
  116. return nil, err
  117. }
  118. return items, nil
  119. }