Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SIMS API - Ensure duplicate files are not persisted #4280

Open
3 tasks
andrewsignori-aot opened this issue Jan 22, 2025 · 0 comments
Open
3 tasks

SIMS API - Ensure duplicate files are not persisted #4280

andrewsignori-aot opened this issue Jan 22, 2025 · 0 comments
Labels
Dev & Architecture Development and Architecture Student Student Features Web portal

Comments

@andrewsignori-aot
Copy link
Collaborator

andrewsignori-aot commented Jan 22, 2025 •
edited
Loading

While uploading files, ensure there will be checks to avoid the same file (unique file name) persisting twice in the DB.

  • Add validation to the API endpoint POST student/files to ensure a file with the same unique name is not already persisted.
  • Crate a unique constraint on column sims.student_files.unique_file_name.
    • Prior to DB migration execution, ensure there are no duplicated "unique file names" already on DB.
@andrewsignori-aot andrewsignori-aot added Dev & Architecture Development and Architecture Student Student Features Web portal labels Jan 22, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Dev & Architecture Development and Architecture Student Student Features Web portal
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@andrewsignori-aot