I have a database (MS SQL) where each record has a field which points to the location of an image.
I want to check if the image file, in each record, exists on disk . If it doesn’t, I want to STOP Processing the record and generate a log file of all missing images.
The goal here is to only validate my datamapper, generate a log file of all records with missing images.and notify an external application which will pick the images and process if they are all present or alert an admin with the log of all missing images.
Can this be achieved with the datamapper?