Rings Remediation Scripts

This is a set of scripts that "correct" previous processing errors and failed transitions. The scripts are run from the host of the Rings applicaton and need access to the AFS directories that contain both the input files and the files that have been ingested into the Rings application.

---

ring-set-new

This script reads the pictures_information table selecting records that have no corresponding entries in the picture_rings table. An entry is created in the picture_rings table with a UID of 'new';

---

ring-set-input

This script reads the Ring input directory and creates entries in the picture_input_index table. Signature, ahash, dhash, and phash values are calculated and stored. If the entry exists in the picture_input_index table they will not be overwritten unless the --force switch is specified.

---

ring-set-db

Update signature and hashes in the Rings database from the raw files store in the Rings application.

---

ring-set-link

For each entry in the pictures_information table that does not have a link to an entry in the picture_input_index table use the hash values of the raw image in the Rings gallery to the hash values in the Rings input directory. When a match is found display, or optionally update, the source_file, file_name fields in the pictures_information table and the pid field in the picture_input_index table.

This assumes that the hashs have been calculated and stored in the pictures_information and picture_input_tables. Historically the calculations to generate the hash values were not performed. The values can be set using the ring-set-input and ring-set-db scripts.