Change Details

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} 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.

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} 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 * [x] A service is created that allows checking if a SHA-1 exists in the `mediamoderation_scan` * [x] This service should be fully tested to ensure reliability.

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} 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 * [x] A service is created that allows checking if a SHA-1 exists in the `mediamoderation_scan` * [x] This service should be fully tested to ensure reliability.