Changeset 18757

Timestamp:

02/11/17 21:44:39 (8 years ago)

Author:

Daniela Dorner

Message:

added queries to update new columns in DB

File:

• trunk/DataCheck/Processing/BuildSequences.sh (modified) (1 diff)

trunk/DataCheck/Processing/BuildSequences.sh

@@ -30 +30 @@
 esac
 
+# update run counts in SequenceInfo table
+# runs in sequence
+query="UPDATE SequenceInfo LEFT JOIN RunInfo USING(fNight, fSequenceID) "
+query=$query"SET fNumRuns=(SELECT COUNT(*) FROM RunInfo "
+query=$query"WHERE fSequenceID=SequenceInfo.fSequenceID AND fNight=SequenceInfo.fNight) "
+printprocesslog "INFO Updating SequenceInfo with number of runs."
+sendquery
+# raw files avail ISDC
+query="UPDATE SequenceInfo LEFT JOIN RunInfo USING(fNight, fSequenceID) "
+query=$query"SET fNumRawfilesAvailISDC=(SELECT COUNT(*) FROM RunInfo "
+query=$query"LEFT JOIN RawFileAvailISDCStatus USING(fNight, fRunID) "
+query=$query"WHERE fSequenceID=SequenceInfo.fSequenceID AND fNight=SequenceInfo.fNight "
+query=$query"AND NOT ISNULL(RawFileAvailISDCStatus.fStartTime) "
+query=$query"AND NOT ISNULL(RawFileAvailISDCStatus.fStopTime) "
+query=$query"AND ISNULL(RawFileAvailISDCStatus.fReturnCode)) "
+printprocesslog "INFO Updating SequenceInfo with number of available files."
+sendquery
+
 finish