SIMS icon indicating copy to clipboard operation
SIMS copied to clipboard

SIMS Object Storage for Files - Remove DB Data

Open andrewsignori-aot opened this issue 1 year ago • 0 comments

As a Ministry, I want to ensure student files are properly stored.

Technical

  • [ ] Adjust the temporary download code introduced during #3604, keeping the S3 source as the only possible way to have the file downloaded (lines 141 to 148).
  • [ ] Adjust the temporary upload code introduced during #3604. The S3 put operation must be moved inside the uploadFile service method. The createFile should be invoked only if the S3 put operation was successful.
  • [ ] Ensure the Student and the Ministry endpoints save the file to S3 storage (currently only the Student client saves it).
  • [ ] Delete the columns file_content and mime_type from sims.student_files. The current data should be removed and the operation does not need a rollback planned.
  • [ ] Change the virus scan method to retrieve the file from S3 storage.
  • [ ] Add the S3_* env variables to queue-consumers following the same from the API deploy yaml.
  • [ ] Adjust virus-scan.processor.e2e-spec.ts queue-consumers E2E tests to mock the file bytes to be returned.

andrewsignori-aot avatar Aug 06 '24 17:08 andrewsignori-aot