Changeset 8520 for trunk/MagicSoft/Mars/datacenter/tools/resetdataset

Timestamp:

05/16/07 15:56:17 (17 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/tools/resetdataset (modified) (3 diffs)

trunk/MagicSoft/Mars/datacenter/tools/resetdataset

@@ -30 +30 @@
 
 datasetpath=/magic/datasets
-datasetpath=/test/bu.2006.10.05/datasets
+#datasetpath=/test/bu.2006.10.05/datasets
 
 function usage()
@@ -93 +93 @@
 
 
-alias mymysql='mysql -u $user --password=$ps --host=vela $db -s -e'
+alias mymysql='mysql -u $user --password=$pw --host=vela $db -s -e'
 
-whereclause1=" WHERE fDataSetNumer=$dataset"
+whereclause1=" WHERE fDataSetNumber=$dataset"
 statusreset=", fStartTime=NULL, fFailedTime=NULL, fFailedCode=NULL, fFailedCodeAdd=NULL, fReturnCode=NULL"
 query1="UPDATE DataSetProcessStatus SET fStarFilesAvail=NULL, fGanymed=NULL, fFillGanymed=NULL"
 query1=$query1$statusreset$whereclause1
 
-query2="DELETE FROM GANYMED "$whereclause1
+query2="DELETE FROM Ganymed "$whereclause1
 
 no=`printf %08d $dataset`
@@ -118 +118 @@
 echo " Found the following off sequences: $seqoff"
 
-whereclause2=" WHERE fSequenceFirst IN ($seqon,$seqoff)"
-query3="UPDATE SequenceProcessStatus SET fAllFilesAvail=NULL, fCallisto=NULL, fStar=NULL "
-query3=$query3$setstatusreseet$whereclause2
+if [ "$seqoff" = "" ]
+then
+   whereclause2=" WHERE fSequenceFirst IN ($seqon)"
+else
+   whereclause2=" WHERE fSequenceFirst IN ($seqon,$seqoff)"
+fi
+query3="UPDATE SequenceProcessStatus SET fCallisto=NULL, fStar=NULL "
+query3=$query3$statusreset$whereclause2
 
 query4="DELETE FROM Calibration"$whereclause2