tools/BackPopulateSNRAndAcquisitionOrder.pl

[cmadjar]

• run perl BackPopulateSNRAndAcquisitionOrder.pl -h and ensure the help of the script is up to date
• 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.