logs.sql.go 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  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 :one
  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. ) RETURNING id, session_id, timestamp, level, message, attributes, created_at
  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) (Log, error) {
  39. row := q.queryRow(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. var i Log
  49. err := row.Scan(
  50. &i.ID,
  51. &i.SessionID,
  52. &i.Timestamp,
  53. &i.Level,
  54. &i.Message,
  55. &i.Attributes,
  56. &i.CreatedAt,
  57. )
  58. return i, err
  59. }
  60. const listAllLogs = `-- name: ListAllLogs :many
  61. SELECT id, session_id, timestamp, level, message, attributes, created_at FROM logs
  62. ORDER BY timestamp DESC
  63. LIMIT ?
  64. `
  65. func (q *Queries) ListAllLogs(ctx context.Context, limit int64) ([]Log, error) {
  66. rows, err := q.query(ctx, q.listAllLogsStmt, listAllLogs, limit)
  67. if err != nil {
  68. return nil, err
  69. }
  70. defer rows.Close()
  71. items := []Log{}
  72. for rows.Next() {
  73. var i Log
  74. if err := rows.Scan(
  75. &i.ID,
  76. &i.SessionID,
  77. &i.Timestamp,
  78. &i.Level,
  79. &i.Message,
  80. &i.Attributes,
  81. &i.CreatedAt,
  82. ); err != nil {
  83. return nil, err
  84. }
  85. items = append(items, i)
  86. }
  87. if err := rows.Close(); err != nil {
  88. return nil, err
  89. }
  90. if err := rows.Err(); err != nil {
  91. return nil, err
  92. }
  93. return items, nil
  94. }
  95. const listLogsBySession = `-- name: ListLogsBySession :many
  96. SELECT id, session_id, timestamp, level, message, attributes, created_at FROM logs
  97. WHERE session_id = ?
  98. ORDER BY timestamp ASC
  99. `
  100. func (q *Queries) ListLogsBySession(ctx context.Context, sessionID sql.NullString) ([]Log, error) {
  101. rows, err := q.query(ctx, q.listLogsBySessionStmt, listLogsBySession, sessionID)
  102. if err != nil {
  103. return nil, err
  104. }
  105. defer rows.Close()
  106. items := []Log{}
  107. for rows.Next() {
  108. var i Log
  109. if err := rows.Scan(
  110. &i.ID,
  111. &i.SessionID,
  112. &i.Timestamp,
  113. &i.Level,
  114. &i.Message,
  115. &i.Attributes,
  116. &i.CreatedAt,
  117. ); err != nil {
  118. return nil, err
  119. }
  120. items = append(items, i)
  121. }
  122. if err := rows.Close(); err != nil {
  123. return nil, err
  124. }
  125. if err := rows.Err(); err != nil {
  126. return nil, err
  127. }
  128. return items, nil
  129. }