db.go 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418
  1. // Code generated by sqlc. DO NOT EDIT.
  2. // versions:
  3. // sqlc v1.30.0
  4. package db
  5. import (
  6. "context"
  7. "database/sql"
  8. "fmt"
  9. )
  10. type DBTX interface {
  11. ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
  12. PrepareContext(context.Context, string) (*sql.Stmt, error)
  13. QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
  14. QueryRowContext(context.Context, string, ...interface{}) *sql.Row
  15. }
  16. func New(db DBTX) *Queries {
  17. return &Queries{db: db}
  18. }
  19. func Prepare(ctx context.Context, db DBTX) (*Queries, error) {
  20. q := Queries{db: db}
  21. var err error
  22. if q.createFileStmt, err = db.PrepareContext(ctx, createFile); err != nil {
  23. return nil, fmt.Errorf("error preparing query CreateFile: %w", err)
  24. }
  25. if q.createMessageStmt, err = db.PrepareContext(ctx, createMessage); err != nil {
  26. return nil, fmt.Errorf("error preparing query CreateMessage: %w", err)
  27. }
  28. if q.createSessionStmt, err = db.PrepareContext(ctx, createSession); err != nil {
  29. return nil, fmt.Errorf("error preparing query CreateSession: %w", err)
  30. }
  31. if q.deleteFileStmt, err = db.PrepareContext(ctx, deleteFile); err != nil {
  32. return nil, fmt.Errorf("error preparing query DeleteFile: %w", err)
  33. }
  34. if q.deleteMessageStmt, err = db.PrepareContext(ctx, deleteMessage); err != nil {
  35. return nil, fmt.Errorf("error preparing query DeleteMessage: %w", err)
  36. }
  37. if q.deleteSessionStmt, err = db.PrepareContext(ctx, deleteSession); err != nil {
  38. return nil, fmt.Errorf("error preparing query DeleteSession: %w", err)
  39. }
  40. if q.deleteSessionFilesStmt, err = db.PrepareContext(ctx, deleteSessionFiles); err != nil {
  41. return nil, fmt.Errorf("error preparing query DeleteSessionFiles: %w", err)
  42. }
  43. if q.deleteSessionMessagesStmt, err = db.PrepareContext(ctx, deleteSessionMessages); err != nil {
  44. return nil, fmt.Errorf("error preparing query DeleteSessionMessages: %w", err)
  45. }
  46. if q.getAverageResponseTimeStmt, err = db.PrepareContext(ctx, getAverageResponseTime); err != nil {
  47. return nil, fmt.Errorf("error preparing query GetAverageResponseTime: %w", err)
  48. }
  49. if q.getFileStmt, err = db.PrepareContext(ctx, getFile); err != nil {
  50. return nil, fmt.Errorf("error preparing query GetFile: %w", err)
  51. }
  52. if q.getFileByPathAndSessionStmt, err = db.PrepareContext(ctx, getFileByPathAndSession); err != nil {
  53. return nil, fmt.Errorf("error preparing query GetFileByPathAndSession: %w", err)
  54. }
  55. if q.getFileReadStmt, err = db.PrepareContext(ctx, getFileRead); err != nil {
  56. return nil, fmt.Errorf("error preparing query GetFileRead: %w", err)
  57. }
  58. if q.getHourDayHeatmapStmt, err = db.PrepareContext(ctx, getHourDayHeatmap); err != nil {
  59. return nil, fmt.Errorf("error preparing query GetHourDayHeatmap: %w", err)
  60. }
  61. if q.getMessageStmt, err = db.PrepareContext(ctx, getMessage); err != nil {
  62. return nil, fmt.Errorf("error preparing query GetMessage: %w", err)
  63. }
  64. if q.getRecentActivityStmt, err = db.PrepareContext(ctx, getRecentActivity); err != nil {
  65. return nil, fmt.Errorf("error preparing query GetRecentActivity: %w", err)
  66. }
  67. if q.getSessionByIDStmt, err = db.PrepareContext(ctx, getSessionByID); err != nil {
  68. return nil, fmt.Errorf("error preparing query GetSessionByID: %w", err)
  69. }
  70. if q.getToolUsageStmt, err = db.PrepareContext(ctx, getToolUsage); err != nil {
  71. return nil, fmt.Errorf("error preparing query GetToolUsage: %w", err)
  72. }
  73. if q.getTotalStatsStmt, err = db.PrepareContext(ctx, getTotalStats); err != nil {
  74. return nil, fmt.Errorf("error preparing query GetTotalStats: %w", err)
  75. }
  76. if q.getUsageByDayStmt, err = db.PrepareContext(ctx, getUsageByDay); err != nil {
  77. return nil, fmt.Errorf("error preparing query GetUsageByDay: %w", err)
  78. }
  79. if q.getUsageByDayOfWeekStmt, err = db.PrepareContext(ctx, getUsageByDayOfWeek); err != nil {
  80. return nil, fmt.Errorf("error preparing query GetUsageByDayOfWeek: %w", err)
  81. }
  82. if q.getUsageByHourStmt, err = db.PrepareContext(ctx, getUsageByHour); err != nil {
  83. return nil, fmt.Errorf("error preparing query GetUsageByHour: %w", err)
  84. }
  85. if q.getUsageByModelStmt, err = db.PrepareContext(ctx, getUsageByModel); err != nil {
  86. return nil, fmt.Errorf("error preparing query GetUsageByModel: %w", err)
  87. }
  88. if q.listAllUserMessagesStmt, err = db.PrepareContext(ctx, listAllUserMessages); err != nil {
  89. return nil, fmt.Errorf("error preparing query ListAllUserMessages: %w", err)
  90. }
  91. if q.listFilesByPathStmt, err = db.PrepareContext(ctx, listFilesByPath); err != nil {
  92. return nil, fmt.Errorf("error preparing query ListFilesByPath: %w", err)
  93. }
  94. if q.listFilesBySessionStmt, err = db.PrepareContext(ctx, listFilesBySession); err != nil {
  95. return nil, fmt.Errorf("error preparing query ListFilesBySession: %w", err)
  96. }
  97. if q.listLatestSessionFilesStmt, err = db.PrepareContext(ctx, listLatestSessionFiles); err != nil {
  98. return nil, fmt.Errorf("error preparing query ListLatestSessionFiles: %w", err)
  99. }
  100. if q.listMessagesBySessionStmt, err = db.PrepareContext(ctx, listMessagesBySession); err != nil {
  101. return nil, fmt.Errorf("error preparing query ListMessagesBySession: %w", err)
  102. }
  103. if q.listNewFilesStmt, err = db.PrepareContext(ctx, listNewFiles); err != nil {
  104. return nil, fmt.Errorf("error preparing query ListNewFiles: %w", err)
  105. }
  106. if q.listSessionsStmt, err = db.PrepareContext(ctx, listSessions); err != nil {
  107. return nil, fmt.Errorf("error preparing query ListSessions: %w", err)
  108. }
  109. if q.listUserMessagesBySessionStmt, err = db.PrepareContext(ctx, listUserMessagesBySession); err != nil {
  110. return nil, fmt.Errorf("error preparing query ListUserMessagesBySession: %w", err)
  111. }
  112. if q.recordFileReadStmt, err = db.PrepareContext(ctx, recordFileRead); err != nil {
  113. return nil, fmt.Errorf("error preparing query RecordFileRead: %w", err)
  114. }
  115. if q.updateMessageStmt, err = db.PrepareContext(ctx, updateMessage); err != nil {
  116. return nil, fmt.Errorf("error preparing query UpdateMessage: %w", err)
  117. }
  118. if q.updateSessionStmt, err = db.PrepareContext(ctx, updateSession); err != nil {
  119. return nil, fmt.Errorf("error preparing query UpdateSession: %w", err)
  120. }
  121. if q.updateSessionTitleAndUsageStmt, err = db.PrepareContext(ctx, updateSessionTitleAndUsage); err != nil {
  122. return nil, fmt.Errorf("error preparing query UpdateSessionTitleAndUsage: %w", err)
  123. }
  124. return &q, nil
  125. }
  126. func (q *Queries) Close() error {
  127. var err error
  128. if q.createFileStmt != nil {
  129. if cerr := q.createFileStmt.Close(); cerr != nil {
  130. err = fmt.Errorf("error closing createFileStmt: %w", cerr)
  131. }
  132. }
  133. if q.createMessageStmt != nil {
  134. if cerr := q.createMessageStmt.Close(); cerr != nil {
  135. err = fmt.Errorf("error closing createMessageStmt: %w", cerr)
  136. }
  137. }
  138. if q.createSessionStmt != nil {
  139. if cerr := q.createSessionStmt.Close(); cerr != nil {
  140. err = fmt.Errorf("error closing createSessionStmt: %w", cerr)
  141. }
  142. }
  143. if q.deleteFileStmt != nil {
  144. if cerr := q.deleteFileStmt.Close(); cerr != nil {
  145. err = fmt.Errorf("error closing deleteFileStmt: %w", cerr)
  146. }
  147. }
  148. if q.deleteMessageStmt != nil {
  149. if cerr := q.deleteMessageStmt.Close(); cerr != nil {
  150. err = fmt.Errorf("error closing deleteMessageStmt: %w", cerr)
  151. }
  152. }
  153. if q.deleteSessionStmt != nil {
  154. if cerr := q.deleteSessionStmt.Close(); cerr != nil {
  155. err = fmt.Errorf("error closing deleteSessionStmt: %w", cerr)
  156. }
  157. }
  158. if q.deleteSessionFilesStmt != nil {
  159. if cerr := q.deleteSessionFilesStmt.Close(); cerr != nil {
  160. err = fmt.Errorf("error closing deleteSessionFilesStmt: %w", cerr)
  161. }
  162. }
  163. if q.deleteSessionMessagesStmt != nil {
  164. if cerr := q.deleteSessionMessagesStmt.Close(); cerr != nil {
  165. err = fmt.Errorf("error closing deleteSessionMessagesStmt: %w", cerr)
  166. }
  167. }
  168. if q.getAverageResponseTimeStmt != nil {
  169. if cerr := q.getAverageResponseTimeStmt.Close(); cerr != nil {
  170. err = fmt.Errorf("error closing getAverageResponseTimeStmt: %w", cerr)
  171. }
  172. }
  173. if q.getFileStmt != nil {
  174. if cerr := q.getFileStmt.Close(); cerr != nil {
  175. err = fmt.Errorf("error closing getFileStmt: %w", cerr)
  176. }
  177. }
  178. if q.getFileByPathAndSessionStmt != nil {
  179. if cerr := q.getFileByPathAndSessionStmt.Close(); cerr != nil {
  180. err = fmt.Errorf("error closing getFileByPathAndSessionStmt: %w", cerr)
  181. }
  182. }
  183. if q.getFileReadStmt != nil {
  184. if cerr := q.getFileReadStmt.Close(); cerr != nil {
  185. err = fmt.Errorf("error closing getFileReadStmt: %w", cerr)
  186. }
  187. }
  188. if q.getHourDayHeatmapStmt != nil {
  189. if cerr := q.getHourDayHeatmapStmt.Close(); cerr != nil {
  190. err = fmt.Errorf("error closing getHourDayHeatmapStmt: %w", cerr)
  191. }
  192. }
  193. if q.getMessageStmt != nil {
  194. if cerr := q.getMessageStmt.Close(); cerr != nil {
  195. err = fmt.Errorf("error closing getMessageStmt: %w", cerr)
  196. }
  197. }
  198. if q.getRecentActivityStmt != nil {
  199. if cerr := q.getRecentActivityStmt.Close(); cerr != nil {
  200. err = fmt.Errorf("error closing getRecentActivityStmt: %w", cerr)
  201. }
  202. }
  203. if q.getSessionByIDStmt != nil {
  204. if cerr := q.getSessionByIDStmt.Close(); cerr != nil {
  205. err = fmt.Errorf("error closing getSessionByIDStmt: %w", cerr)
  206. }
  207. }
  208. if q.getToolUsageStmt != nil {
  209. if cerr := q.getToolUsageStmt.Close(); cerr != nil {
  210. err = fmt.Errorf("error closing getToolUsageStmt: %w", cerr)
  211. }
  212. }
  213. if q.getTotalStatsStmt != nil {
  214. if cerr := q.getTotalStatsStmt.Close(); cerr != nil {
  215. err = fmt.Errorf("error closing getTotalStatsStmt: %w", cerr)
  216. }
  217. }
  218. if q.getUsageByDayStmt != nil {
  219. if cerr := q.getUsageByDayStmt.Close(); cerr != nil {
  220. err = fmt.Errorf("error closing getUsageByDayStmt: %w", cerr)
  221. }
  222. }
  223. if q.getUsageByDayOfWeekStmt != nil {
  224. if cerr := q.getUsageByDayOfWeekStmt.Close(); cerr != nil {
  225. err = fmt.Errorf("error closing getUsageByDayOfWeekStmt: %w", cerr)
  226. }
  227. }
  228. if q.getUsageByHourStmt != nil {
  229. if cerr := q.getUsageByHourStmt.Close(); cerr != nil {
  230. err = fmt.Errorf("error closing getUsageByHourStmt: %w", cerr)
  231. }
  232. }
  233. if q.getUsageByModelStmt != nil {
  234. if cerr := q.getUsageByModelStmt.Close(); cerr != nil {
  235. err = fmt.Errorf("error closing getUsageByModelStmt: %w", cerr)
  236. }
  237. }
  238. if q.listAllUserMessagesStmt != nil {
  239. if cerr := q.listAllUserMessagesStmt.Close(); cerr != nil {
  240. err = fmt.Errorf("error closing listAllUserMessagesStmt: %w", cerr)
  241. }
  242. }
  243. if q.listFilesByPathStmt != nil {
  244. if cerr := q.listFilesByPathStmt.Close(); cerr != nil {
  245. err = fmt.Errorf("error closing listFilesByPathStmt: %w", cerr)
  246. }
  247. }
  248. if q.listFilesBySessionStmt != nil {
  249. if cerr := q.listFilesBySessionStmt.Close(); cerr != nil {
  250. err = fmt.Errorf("error closing listFilesBySessionStmt: %w", cerr)
  251. }
  252. }
  253. if q.listLatestSessionFilesStmt != nil {
  254. if cerr := q.listLatestSessionFilesStmt.Close(); cerr != nil {
  255. err = fmt.Errorf("error closing listLatestSessionFilesStmt: %w", cerr)
  256. }
  257. }
  258. if q.listMessagesBySessionStmt != nil {
  259. if cerr := q.listMessagesBySessionStmt.Close(); cerr != nil {
  260. err = fmt.Errorf("error closing listMessagesBySessionStmt: %w", cerr)
  261. }
  262. }
  263. if q.listNewFilesStmt != nil {
  264. if cerr := q.listNewFilesStmt.Close(); cerr != nil {
  265. err = fmt.Errorf("error closing listNewFilesStmt: %w", cerr)
  266. }
  267. }
  268. if q.listSessionsStmt != nil {
  269. if cerr := q.listSessionsStmt.Close(); cerr != nil {
  270. err = fmt.Errorf("error closing listSessionsStmt: %w", cerr)
  271. }
  272. }
  273. if q.listUserMessagesBySessionStmt != nil {
  274. if cerr := q.listUserMessagesBySessionStmt.Close(); cerr != nil {
  275. err = fmt.Errorf("error closing listUserMessagesBySessionStmt: %w", cerr)
  276. }
  277. }
  278. if q.recordFileReadStmt != nil {
  279. if cerr := q.recordFileReadStmt.Close(); cerr != nil {
  280. err = fmt.Errorf("error closing recordFileReadStmt: %w", cerr)
  281. }
  282. }
  283. if q.updateMessageStmt != nil {
  284. if cerr := q.updateMessageStmt.Close(); cerr != nil {
  285. err = fmt.Errorf("error closing updateMessageStmt: %w", cerr)
  286. }
  287. }
  288. if q.updateSessionStmt != nil {
  289. if cerr := q.updateSessionStmt.Close(); cerr != nil {
  290. err = fmt.Errorf("error closing updateSessionStmt: %w", cerr)
  291. }
  292. }
  293. if q.updateSessionTitleAndUsageStmt != nil {
  294. if cerr := q.updateSessionTitleAndUsageStmt.Close(); cerr != nil {
  295. err = fmt.Errorf("error closing updateSessionTitleAndUsageStmt: %w", cerr)
  296. }
  297. }
  298. return err
  299. }
  300. func (q *Queries) exec(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) (sql.Result, error) {
  301. switch {
  302. case stmt != nil && q.tx != nil:
  303. return q.tx.StmtContext(ctx, stmt).ExecContext(ctx, args...)
  304. case stmt != nil:
  305. return stmt.ExecContext(ctx, args...)
  306. default:
  307. return q.db.ExecContext(ctx, query, args...)
  308. }
  309. }
  310. func (q *Queries) query(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) (*sql.Rows, error) {
  311. switch {
  312. case stmt != nil && q.tx != nil:
  313. return q.tx.StmtContext(ctx, stmt).QueryContext(ctx, args...)
  314. case stmt != nil:
  315. return stmt.QueryContext(ctx, args...)
  316. default:
  317. return q.db.QueryContext(ctx, query, args...)
  318. }
  319. }
  320. func (q *Queries) queryRow(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) *sql.Row {
  321. switch {
  322. case stmt != nil && q.tx != nil:
  323. return q.tx.StmtContext(ctx, stmt).QueryRowContext(ctx, args...)
  324. case stmt != nil:
  325. return stmt.QueryRowContext(ctx, args...)
  326. default:
  327. return q.db.QueryRowContext(ctx, query, args...)
  328. }
  329. }
  330. type Queries struct {
  331. db DBTX
  332. tx *sql.Tx
  333. createFileStmt *sql.Stmt
  334. createMessageStmt *sql.Stmt
  335. createSessionStmt *sql.Stmt
  336. deleteFileStmt *sql.Stmt
  337. deleteMessageStmt *sql.Stmt
  338. deleteSessionStmt *sql.Stmt
  339. deleteSessionFilesStmt *sql.Stmt
  340. deleteSessionMessagesStmt *sql.Stmt
  341. getAverageResponseTimeStmt *sql.Stmt
  342. getFileStmt *sql.Stmt
  343. getFileByPathAndSessionStmt *sql.Stmt
  344. getFileReadStmt *sql.Stmt
  345. getHourDayHeatmapStmt *sql.Stmt
  346. getMessageStmt *sql.Stmt
  347. getRecentActivityStmt *sql.Stmt
  348. getSessionByIDStmt *sql.Stmt
  349. getToolUsageStmt *sql.Stmt
  350. getTotalStatsStmt *sql.Stmt
  351. getUsageByDayStmt *sql.Stmt
  352. getUsageByDayOfWeekStmt *sql.Stmt
  353. getUsageByHourStmt *sql.Stmt
  354. getUsageByModelStmt *sql.Stmt
  355. listAllUserMessagesStmt *sql.Stmt
  356. listFilesByPathStmt *sql.Stmt
  357. listFilesBySessionStmt *sql.Stmt
  358. listLatestSessionFilesStmt *sql.Stmt
  359. listMessagesBySessionStmt *sql.Stmt
  360. listNewFilesStmt *sql.Stmt
  361. listSessionsStmt *sql.Stmt
  362. listUserMessagesBySessionStmt *sql.Stmt
  363. recordFileReadStmt *sql.Stmt
  364. updateMessageStmt *sql.Stmt
  365. updateSessionStmt *sql.Stmt
  366. updateSessionTitleAndUsageStmt *sql.Stmt
  367. }
  368. func (q *Queries) WithTx(tx *sql.Tx) *Queries {
  369. return &Queries{
  370. db: tx,
  371. tx: tx,
  372. createFileStmt: q.createFileStmt,
  373. createMessageStmt: q.createMessageStmt,
  374. createSessionStmt: q.createSessionStmt,
  375. deleteFileStmt: q.deleteFileStmt,
  376. deleteMessageStmt: q.deleteMessageStmt,
  377. deleteSessionStmt: q.deleteSessionStmt,
  378. deleteSessionFilesStmt: q.deleteSessionFilesStmt,
  379. deleteSessionMessagesStmt: q.deleteSessionMessagesStmt,
  380. getAverageResponseTimeStmt: q.getAverageResponseTimeStmt,
  381. getFileStmt: q.getFileStmt,
  382. getFileByPathAndSessionStmt: q.getFileByPathAndSessionStmt,
  383. getFileReadStmt: q.getFileReadStmt,
  384. getHourDayHeatmapStmt: q.getHourDayHeatmapStmt,
  385. getMessageStmt: q.getMessageStmt,
  386. getRecentActivityStmt: q.getRecentActivityStmt,
  387. getSessionByIDStmt: q.getSessionByIDStmt,
  388. getToolUsageStmt: q.getToolUsageStmt,
  389. getTotalStatsStmt: q.getTotalStatsStmt,
  390. getUsageByDayStmt: q.getUsageByDayStmt,
  391. getUsageByDayOfWeekStmt: q.getUsageByDayOfWeekStmt,
  392. getUsageByHourStmt: q.getUsageByHourStmt,
  393. getUsageByModelStmt: q.getUsageByModelStmt,
  394. listAllUserMessagesStmt: q.listAllUserMessagesStmt,
  395. listFilesByPathStmt: q.listFilesByPathStmt,
  396. listFilesBySessionStmt: q.listFilesBySessionStmt,
  397. listLatestSessionFilesStmt: q.listLatestSessionFilesStmt,
  398. listMessagesBySessionStmt: q.listMessagesBySessionStmt,
  399. listNewFilesStmt: q.listNewFilesStmt,
  400. listSessionsStmt: q.listSessionsStmt,
  401. listUserMessagesBySessionStmt: q.listUserMessagesBySessionStmt,
  402. recordFileReadStmt: q.recordFileReadStmt,
  403. updateMessageStmt: q.updateMessageStmt,
  404. updateSessionStmt: q.updateSessionStmt,
  405. updateSessionTitleAndUsageStmt: q.updateSessionTitleAndUsageStmt,
  406. }
  407. }