[x] run perl BackPopulateSNRAndAcquisitionOrder.pl -h and ensure the help of the script is up to date
[x] pick a tarchive ID and delete SNR parameter_file entries and set AcqOrderPerModality field of the files table to NULL. Example for tarchive ID 27:
UPDATE files SET AcqOrderPerModality=NULL WHERE TarchiveSource=27;
UPDATE parameter_file SET Value=NULL WHERE FileID IN (SELECT FileID FROM files WHERE TarchiveSource=27) AND ParameterTypeID=(SELECT ParameterTypeID FROM parameter_type WHERE Name='SNR');
mysql> SELECT TarchiveSource, SessionID, AcqOrderPerModality, Value FROM files JOIN parameter_file USING (FileID) JOIN parameter_type USING (ParameterTypeID) WHERE Name='SNR' AND TarchiveSource=27;
+----------------+-----------+---------------------+-------+
| TarchiveSource | SessionID | AcqOrderPerModality | Value |
+----------------+-----------+---------------------+-------+
| 27 | 1053 | NULL | NULL |
| 27 | 1053 | NULL | NULL |
+----------------+-----------+---------------------+-------+
[ ] run perl BackPopulateSNRAndAcquisitionOrder.pl -profile prod -tarchive_id 27 and check that the AcqOrderPerModality and SNR value have been repopulated.
perl BackPopulateSNRAndAcquisitionOrder.pl -h
and ensure the help of the script is up to date[x] pick a tarchive ID and delete SNR parameter_file entries and set AcqOrderPerModality field of the files table to NULL. Example for tarchive ID 27:
perl BackPopulateSNRAndAcquisitionOrder.pl -profile prod -tarchive_id 27
and check that theAcqOrderPerModality
andSNR
value have been repopulated.