db.go 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428
  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.listSessionReadFilesStmt, err = db.PrepareContext(ctx, listSessionReadFiles); err != nil {
  107. return nil, fmt.Errorf("error preparing query ListSessionReadFiles: %w", err)
  108. }
  109. if q.listSessionsStmt, err = db.PrepareContext(ctx, listSessions); err != nil {
  110. return nil, fmt.Errorf("error preparing query ListSessions: %w", err)
  111. }
  112. if q.listUserMessagesBySessionStmt, err = db.PrepareContext(ctx, listUserMessagesBySession); err != nil {
  113. return nil, fmt.Errorf("error preparing query ListUserMessagesBySession: %w", err)
  114. }
  115. if q.recordFileReadStmt, err = db.PrepareContext(ctx, recordFileRead); err != nil {
  116. return nil, fmt.Errorf("error preparing query RecordFileRead: %w", err)
  117. }
  118. if q.updateMessageStmt, err = db.PrepareContext(ctx, updateMessage); err != nil {
  119. return nil, fmt.Errorf("error preparing query UpdateMessage: %w", err)
  120. }
  121. if q.updateSessionStmt, err = db.PrepareContext(ctx, updateSession); err != nil {
  122. return nil, fmt.Errorf("error preparing query UpdateSession: %w", err)
  123. }
  124. if q.updateSessionTitleAndUsageStmt, err = db.PrepareContext(ctx, updateSessionTitleAndUsage); err != nil {
  125. return nil, fmt.Errorf("error preparing query UpdateSessionTitleAndUsage: %w", err)
  126. }
  127. return &q, nil
  128. }
  129. func (q *Queries) Close() error {
  130. var err error
  131. if q.createFileStmt != nil {
  132. if cerr := q.createFileStmt.Close(); cerr != nil {
  133. err = fmt.Errorf("error closing createFileStmt: %w", cerr)
  134. }
  135. }
  136. if q.createMessageStmt != nil {
  137. if cerr := q.createMessageStmt.Close(); cerr != nil {
  138. err = fmt.Errorf("error closing createMessageStmt: %w", cerr)
  139. }
  140. }
  141. if q.createSessionStmt != nil {
  142. if cerr := q.createSessionStmt.Close(); cerr != nil {
  143. err = fmt.Errorf("error closing createSessionStmt: %w", cerr)
  144. }
  145. }
  146. if q.deleteFileStmt != nil {
  147. if cerr := q.deleteFileStmt.Close(); cerr != nil {
  148. err = fmt.Errorf("error closing deleteFileStmt: %w", cerr)
  149. }
  150. }
  151. if q.deleteMessageStmt != nil {
  152. if cerr := q.deleteMessageStmt.Close(); cerr != nil {
  153. err = fmt.Errorf("error closing deleteMessageStmt: %w", cerr)
  154. }
  155. }
  156. if q.deleteSessionStmt != nil {
  157. if cerr := q.deleteSessionStmt.Close(); cerr != nil {
  158. err = fmt.Errorf("error closing deleteSessionStmt: %w", cerr)
  159. }
  160. }
  161. if q.deleteSessionFilesStmt != nil {
  162. if cerr := q.deleteSessionFilesStmt.Close(); cerr != nil {
  163. err = fmt.Errorf("error closing deleteSessionFilesStmt: %w", cerr)
  164. }
  165. }
  166. if q.deleteSessionMessagesStmt != nil {
  167. if cerr := q.deleteSessionMessagesStmt.Close(); cerr != nil {
  168. err = fmt.Errorf("error closing deleteSessionMessagesStmt: %w", cerr)
  169. }
  170. }
  171. if q.getAverageResponseTimeStmt != nil {
  172. if cerr := q.getAverageResponseTimeStmt.Close(); cerr != nil {
  173. err = fmt.Errorf("error closing getAverageResponseTimeStmt: %w", cerr)
  174. }
  175. }
  176. if q.getFileStmt != nil {
  177. if cerr := q.getFileStmt.Close(); cerr != nil {
  178. err = fmt.Errorf("error closing getFileStmt: %w", cerr)
  179. }
  180. }
  181. if q.getFileByPathAndSessionStmt != nil {
  182. if cerr := q.getFileByPathAndSessionStmt.Close(); cerr != nil {
  183. err = fmt.Errorf("error closing getFileByPathAndSessionStmt: %w", cerr)
  184. }
  185. }
  186. if q.getFileReadStmt != nil {
  187. if cerr := q.getFileReadStmt.Close(); cerr != nil {
  188. err = fmt.Errorf("error closing getFileReadStmt: %w", cerr)
  189. }
  190. }
  191. if q.getHourDayHeatmapStmt != nil {
  192. if cerr := q.getHourDayHeatmapStmt.Close(); cerr != nil {
  193. err = fmt.Errorf("error closing getHourDayHeatmapStmt: %w", cerr)
  194. }
  195. }
  196. if q.getMessageStmt != nil {
  197. if cerr := q.getMessageStmt.Close(); cerr != nil {
  198. err = fmt.Errorf("error closing getMessageStmt: %w", cerr)
  199. }
  200. }
  201. if q.getRecentActivityStmt != nil {
  202. if cerr := q.getRecentActivityStmt.Close(); cerr != nil {
  203. err = fmt.Errorf("error closing getRecentActivityStmt: %w", cerr)
  204. }
  205. }
  206. if q.getSessionByIDStmt != nil {
  207. if cerr := q.getSessionByIDStmt.Close(); cerr != nil {
  208. err = fmt.Errorf("error closing getSessionByIDStmt: %w", cerr)
  209. }
  210. }
  211. if q.getToolUsageStmt != nil {
  212. if cerr := q.getToolUsageStmt.Close(); cerr != nil {
  213. err = fmt.Errorf("error closing getToolUsageStmt: %w", cerr)
  214. }
  215. }
  216. if q.getTotalStatsStmt != nil {
  217. if cerr := q.getTotalStatsStmt.Close(); cerr != nil {
  218. err = fmt.Errorf("error closing getTotalStatsStmt: %w", cerr)
  219. }
  220. }
  221. if q.getUsageByDayStmt != nil {
  222. if cerr := q.getUsageByDayStmt.Close(); cerr != nil {
  223. err = fmt.Errorf("error closing getUsageByDayStmt: %w", cerr)
  224. }
  225. }
  226. if q.getUsageByDayOfWeekStmt != nil {
  227. if cerr := q.getUsageByDayOfWeekStmt.Close(); cerr != nil {
  228. err = fmt.Errorf("error closing getUsageByDayOfWeekStmt: %w", cerr)
  229. }
  230. }
  231. if q.getUsageByHourStmt != nil {
  232. if cerr := q.getUsageByHourStmt.Close(); cerr != nil {
  233. err = fmt.Errorf("error closing getUsageByHourStmt: %w", cerr)
  234. }
  235. }
  236. if q.getUsageByModelStmt != nil {
  237. if cerr := q.getUsageByModelStmt.Close(); cerr != nil {
  238. err = fmt.Errorf("error closing getUsageByModelStmt: %w", cerr)
  239. }
  240. }
  241. if q.listAllUserMessagesStmt != nil {
  242. if cerr := q.listAllUserMessagesStmt.Close(); cerr != nil {
  243. err = fmt.Errorf("error closing listAllUserMessagesStmt: %w", cerr)
  244. }
  245. }
  246. if q.listFilesByPathStmt != nil {
  247. if cerr := q.listFilesByPathStmt.Close(); cerr != nil {
  248. err = fmt.Errorf("error closing listFilesByPathStmt: %w", cerr)
  249. }
  250. }
  251. if q.listFilesBySessionStmt != nil {
  252. if cerr := q.listFilesBySessionStmt.Close(); cerr != nil {
  253. err = fmt.Errorf("error closing listFilesBySessionStmt: %w", cerr)
  254. }
  255. }
  256. if q.listLatestSessionFilesStmt != nil {
  257. if cerr := q.listLatestSessionFilesStmt.Close(); cerr != nil {
  258. err = fmt.Errorf("error closing listLatestSessionFilesStmt: %w", cerr)
  259. }
  260. }
  261. if q.listMessagesBySessionStmt != nil {
  262. if cerr := q.listMessagesBySessionStmt.Close(); cerr != nil {
  263. err = fmt.Errorf("error closing listMessagesBySessionStmt: %w", cerr)
  264. }
  265. }
  266. if q.listNewFilesStmt != nil {
  267. if cerr := q.listNewFilesStmt.Close(); cerr != nil {
  268. err = fmt.Errorf("error closing listNewFilesStmt: %w", cerr)
  269. }
  270. }
  271. if q.listSessionReadFilesStmt != nil {
  272. if cerr := q.listSessionReadFilesStmt.Close(); cerr != nil {
  273. err = fmt.Errorf("error closing listSessionReadFilesStmt: %w", cerr)
  274. }
  275. }
  276. if q.listSessionsStmt != nil {
  277. if cerr := q.listSessionsStmt.Close(); cerr != nil {
  278. err = fmt.Errorf("error closing listSessionsStmt: %w", cerr)
  279. }
  280. }
  281. if q.listUserMessagesBySessionStmt != nil {
  282. if cerr := q.listUserMessagesBySessionStmt.Close(); cerr != nil {
  283. err = fmt.Errorf("error closing listUserMessagesBySessionStmt: %w", cerr)
  284. }
  285. }
  286. if q.recordFileReadStmt != nil {
  287. if cerr := q.recordFileReadStmt.Close(); cerr != nil {
  288. err = fmt.Errorf("error closing recordFileReadStmt: %w", cerr)
  289. }
  290. }
  291. if q.updateMessageStmt != nil {
  292. if cerr := q.updateMessageStmt.Close(); cerr != nil {
  293. err = fmt.Errorf("error closing updateMessageStmt: %w", cerr)
  294. }
  295. }
  296. if q.updateSessionStmt != nil {
  297. if cerr := q.updateSessionStmt.Close(); cerr != nil {
  298. err = fmt.Errorf("error closing updateSessionStmt: %w", cerr)
  299. }
  300. }
  301. if q.updateSessionTitleAndUsageStmt != nil {
  302. if cerr := q.updateSessionTitleAndUsageStmt.Close(); cerr != nil {
  303. err = fmt.Errorf("error closing updateSessionTitleAndUsageStmt: %w", cerr)
  304. }
  305. }
  306. return err
  307. }
  308. func (q *Queries) exec(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) (sql.Result, error) {
  309. switch {
  310. case stmt != nil && q.tx != nil:
  311. return q.tx.StmtContext(ctx, stmt).ExecContext(ctx, args...)
  312. case stmt != nil:
  313. return stmt.ExecContext(ctx, args...)
  314. default:
  315. return q.db.ExecContext(ctx, query, args...)
  316. }
  317. }
  318. func (q *Queries) query(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) (*sql.Rows, error) {
  319. switch {
  320. case stmt != nil && q.tx != nil:
  321. return q.tx.StmtContext(ctx, stmt).QueryContext(ctx, args...)
  322. case stmt != nil:
  323. return stmt.QueryContext(ctx, args...)
  324. default:
  325. return q.db.QueryContext(ctx, query, args...)
  326. }
  327. }
  328. func (q *Queries) queryRow(ctx context.Context, stmt *sql.Stmt, query string, args ...interface{}) *sql.Row {
  329. switch {
  330. case stmt != nil && q.tx != nil:
  331. return q.tx.StmtContext(ctx, stmt).QueryRowContext(ctx, args...)
  332. case stmt != nil:
  333. return stmt.QueryRowContext(ctx, args...)
  334. default:
  335. return q.db.QueryRowContext(ctx, query, args...)
  336. }
  337. }
  338. type Queries struct {
  339. db DBTX
  340. tx *sql.Tx
  341. createFileStmt *sql.Stmt
  342. createMessageStmt *sql.Stmt
  343. createSessionStmt *sql.Stmt
  344. deleteFileStmt *sql.Stmt
  345. deleteMessageStmt *sql.Stmt
  346. deleteSessionStmt *sql.Stmt
  347. deleteSessionFilesStmt *sql.Stmt
  348. deleteSessionMessagesStmt *sql.Stmt
  349. getAverageResponseTimeStmt *sql.Stmt
  350. getFileStmt *sql.Stmt
  351. getFileByPathAndSessionStmt *sql.Stmt
  352. getFileReadStmt *sql.Stmt
  353. getHourDayHeatmapStmt *sql.Stmt
  354. getMessageStmt *sql.Stmt
  355. getRecentActivityStmt *sql.Stmt
  356. getSessionByIDStmt *sql.Stmt
  357. getToolUsageStmt *sql.Stmt
  358. getTotalStatsStmt *sql.Stmt
  359. getUsageByDayStmt *sql.Stmt
  360. getUsageByDayOfWeekStmt *sql.Stmt
  361. getUsageByHourStmt *sql.Stmt
  362. getUsageByModelStmt *sql.Stmt
  363. listAllUserMessagesStmt *sql.Stmt
  364. listFilesByPathStmt *sql.Stmt
  365. listFilesBySessionStmt *sql.Stmt
  366. listLatestSessionFilesStmt *sql.Stmt
  367. listMessagesBySessionStmt *sql.Stmt
  368. listNewFilesStmt *sql.Stmt
  369. listSessionReadFilesStmt *sql.Stmt
  370. listSessionsStmt *sql.Stmt
  371. listUserMessagesBySessionStmt *sql.Stmt
  372. recordFileReadStmt *sql.Stmt
  373. updateMessageStmt *sql.Stmt
  374. updateSessionStmt *sql.Stmt
  375. updateSessionTitleAndUsageStmt *sql.Stmt
  376. }
  377. func (q *Queries) WithTx(tx *sql.Tx) *Queries {
  378. return &Queries{
  379. db: tx,
  380. tx: tx,
  381. createFileStmt: q.createFileStmt,
  382. createMessageStmt: q.createMessageStmt,
  383. createSessionStmt: q.createSessionStmt,
  384. deleteFileStmt: q.deleteFileStmt,
  385. deleteMessageStmt: q.deleteMessageStmt,
  386. deleteSessionStmt: q.deleteSessionStmt,
  387. deleteSessionFilesStmt: q.deleteSessionFilesStmt,
  388. deleteSessionMessagesStmt: q.deleteSessionMessagesStmt,
  389. getAverageResponseTimeStmt: q.getAverageResponseTimeStmt,
  390. getFileStmt: q.getFileStmt,
  391. getFileByPathAndSessionStmt: q.getFileByPathAndSessionStmt,
  392. getFileReadStmt: q.getFileReadStmt,
  393. getHourDayHeatmapStmt: q.getHourDayHeatmapStmt,
  394. getMessageStmt: q.getMessageStmt,
  395. getRecentActivityStmt: q.getRecentActivityStmt,
  396. getSessionByIDStmt: q.getSessionByIDStmt,
  397. getToolUsageStmt: q.getToolUsageStmt,
  398. getTotalStatsStmt: q.getTotalStatsStmt,
  399. getUsageByDayStmt: q.getUsageByDayStmt,
  400. getUsageByDayOfWeekStmt: q.getUsageByDayOfWeekStmt,
  401. getUsageByHourStmt: q.getUsageByHourStmt,
  402. getUsageByModelStmt: q.getUsageByModelStmt,
  403. listAllUserMessagesStmt: q.listAllUserMessagesStmt,
  404. listFilesByPathStmt: q.listFilesByPathStmt,
  405. listFilesBySessionStmt: q.listFilesBySessionStmt,
  406. listLatestSessionFilesStmt: q.listLatestSessionFilesStmt,
  407. listMessagesBySessionStmt: q.listMessagesBySessionStmt,
  408. listNewFilesStmt: q.listNewFilesStmt,
  409. listSessionReadFilesStmt: q.listSessionReadFilesStmt,
  410. listSessionsStmt: q.listSessionsStmt,
  411. listUserMessagesBySessionStmt: q.listUserMessagesBySessionStmt,
  412. recordFileReadStmt: q.recordFileReadStmt,
  413. updateMessageStmt: q.updateMessageStmt,
  414. updateSessionStmt: q.updateSessionStmt,
  415. updateSessionTitleAndUsageStmt: q.updateSessionTitleAndUsageStmt,
  416. }
  417. }