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.

Edited by Kaveh Nejad

Merge request reports

Loading
Loading