A service should be created that allows selecting and finding rows in the mediamoderation_scan table. This service should have a descriptive name and could be called MediaModerationDatabaseLookup.

This service will be used by T350864: [M] Create a service to manage rows in the mediamoderation_scan table to determine whether a SHA-1 already exists in the table. To prioritise the writing of rows to the DB, this task will be limited to creating a service that checks if a file (found by it's SHA-1) exists in the mediamoderation_scan table. This service will be expanded in future tasks once the exact requirements for it are known.

Acceptance criteria

• A service is created that allows checking if a SHA-1 exists in the mediamoderation_scan
• This service should be fully tested to ensure reliability.