Changeset 8520

Timestamp:

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

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• datacenter/tools/resetdataset (modified) (3 diffs)

trunk/MagicSoft/Mars/Changelog

@@ -18 +18 @@
 
                                                  -*-*- END OF LINE -*-*-
+ 2007/05/16 Daniel Hoehne
+
+   * datacenter/tools/resetdataset:
+     - several bugfixes (mainly typos, for wobble datasets there was one 
+       colon too much due to no off sequences)
+
+
+
  2007/05/16 Thomas Bretz
 

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