Changeset 9100 for trunk/MagicSoft/Mars/datacenter/scripts/dbchk

Timestamp:

08/05/08 17:33:16 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/scripts/dbchk (modified) (3 diffs)

trunk/MagicSoft/Mars/datacenter/scripts/dbchk

@@ -163 +163 @@
 
 # CHECK 3
-echo "Checking if all sequences from Sequences exists RunData" >> $scriptlog 2>&1
+echo "Checking if all sequences from Sequences exist RunData" >> $scriptlog 2>&1
 sequences=`echo SELECT fSequenceFirst FROM Sequences GROUP BY fSequenceFirst | mymysql`
 for sequence in $sequences
@@ -177 +177 @@
 
 # CHECK 4
-echo "Checking if all sequences from RunData exists in Sequences" >> $scriptlog 2>&1
+echo "Checking if all sequences from RunData exist in Sequences" >> $scriptlog 2>&1
 sequences=`echo SELECT fSequenceFirst FROM RunData WHERE not fSequenceFirst=0 GROUP BY fSequenceFirst | mymysql`
 for sequence in $sequences
@@ -190 +190 @@
 done
 
+# CHECK 5
+echo "Checking if all sequences from RunData exist in SequenceProcessStatus" >> $scriptlog 2>&1
+sequences=`echo SELECT fSequenceFirst FROM RunData WHERE not fSequenceFirst=0 GROUP BY fSequenceFirst | mymysql`
+for sequence in $sequences
+do
+   var=`echo SELECT fSequenceFirst FROM SequenceProcessStatus WHERE fSequenceFirst=$sequence | mymysql`
+   if ! [ "$sequence" = "$var" ]
+   then
+      echo "Sequence $sequence exists in RunData but not in SequenceProcessStatus." >> $scriptlog 2>&1
+      printprocesslog "Sequence $sequence exists in RunData but not in SequenceProcessStatus (DB)." 
+      continue
+   fi
+done
+
 finish >> $scriptlog 2>&1