Add table for Duo workflow session files
What does this MR do and why?
Adds a new duo_workflows_session_files table and Ai::DuoWorkflows::SessionFile model to allow for persistent user file uploads to Duo Chat. This MR is limited to DB logic and further MRs will follow to build on the functionality.
References
Parent work item: #632837
Epic: gitlab-org#20481
PoC with future work that will be broken down into individual MRs: !261487 (closed)
Database
New queries: N/A ee/app/models/ai/duo_workflows/session_file.rb adds query logic, but nothing calls them so far.
Migrations: !261463 (comment 3997499586)
New table development/database_review/#preparation-when-adding-tables answers:
anticipated growth for the new table over the next 3 months, 6 months, 1 year
TBC
reads and writes per hour would you expect this table to have in 3 months, 6 months, 1 year
TBC
Based on the anticipated data volume and access patterns, does the new table pose an availability risk to GitLab.com or GitLab Self-Managed instances? Does the proposed design scale to support the needs of GitLab.com and GitLab Self-Managed customers?
TBC
Screenshots or screen recordings
N/A
How to set up and validate locally
Currently there is nothing to validate locally apart from the specs, however, !261487 (closed) (Includes testing instructions) has a rough plan of the rest of the feature in a working (but PoC) state. If you apply the changes from that MR and gitlab-org/modelops/applied-ml/code-suggestions/ai-assist!6949 (closed) the user facing side of the feature is testable.
MR acceptance checklist
Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.