Restrict MIME types for image table

[ewan-escience]

Restrict MIME types for image table

Changes proposed in this pull request:

• Restrict the allowed MIME types in the image table
• Adapt the frontend to show, by default, only allowed files when choosing an image
• Adapt the data generation script
• Remove an unused function from the data generation script

How to test:

• docker compose down --volumes && docker compose build --parallel && docker compose up --scale data-generation=1
• Sign in as admin
• Upload some images in various places
• By default, the upload window will only show accepted files
• If you try to upload a non-accepted file, it should fail with an error

Note: you might have the non-existing MIME type image/jpg in the database. Before applying this in production, you should run the following SQL query:

UPDATE IMAGE SET mime_type = 'image/jpeg' WHERE mime_type = 'image/jpg';

Closes #1241

PR Checklist:

• [ ] Increase version numbers in docker-compose.yml
• [x] Link to a GitHub issue
• [ ] Update documentation
• [ ] Tests

[sonarcloud[bot]]

Quality Gate passed for 'rsd-database'

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud

[sonarcloud[bot]]

Quality Gate failed for 'rsd-frontend'

Failed conditions
6.1% Duplication on New Code (required ≤ 3%)

See analysis details on SonarCloud