Changeset 9147 for trunk/MagicSoft/Mars/datacenter/scripts/mcsequences

Timestamp:

11/11/08 10:38:56 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/scripts/mcsequences (modified) (7 diffs)

trunk/MagicSoft/Mars/datacenter/scripts/mcsequences

@@ -19 +19 @@
 #
 #   Author(s): Daniela Dorner  12/2005 <mailto:dorner@astro.uni-wuerzburg.de>
-#   Author(s): Daniela Dorner  06/2008 <mailto:hoehne@astro.uni-wuerzburg.de>
+#   Author(s): Daniel Hoehne  06/2008 <mailto:hoehne@astro.uni-wuerzburg.de>
 #
 #   Copyright: MAGIC Software Development, 2000-2008
@@ -103 +103 @@
             do
                trainupdate=" update MCRunData set fSequenceFirst=\"$firstruntrain\" where fRunNumber=\"$trainrun\" "
-               mysql -ss -u $user --password=$pw --host=vela $db -e " $trainupdate "
+               mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainupdate "
             done   
 
             trainquery1=" select fSpectrumKEY, fPSFKEY, fAmplFadcKEY, fAtmosphericModelKEY, fObservationModeKEY, fMCParticleKEY, fReflectorVersionKEY, fCorsikaVersionKEY, fCameraVersionKEY, fViewConeAngleOKEY, fAddSpotSizeKEY from MCRunData where fRunNumber=\"$firstruntrain\" "
             trainquery2=" select sum(fNumEvents), sum(fNumtriggers) from MCRunData where fRunNumber in ($trainruns2) "
-            trainvalues=`mysql -ss -u $user --password=$pw --host=vela $db -e " $trainquery1 "`
-            trainvalues2=`mysql -ss -u $user --password=$pw --host=vela $db -e " $trainquery2 "`
+            trainvalues=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainquery1 "`
+            trainvalues2=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainquery2 "`
             trainspec=`echo $trainvalues | cut -d" " -f1`
             trainpsf=`echo $trainvalues | cut -d" " -f2`
@@ -125 +125 @@
             trainquery3=" select fSequenceFirst from MCSequenceProcessStatus where fSequenceFirst=\"$firstruntrain\" "
             trainquery4=" select fSequenceFirst from MCSequences where fSequenceFirst=\"$firstruntrain\" "
-            traincheck3=`mysql -ss -u $user --password=$pw --host=vela $db -e " $trainquery3 "`
-            traincheck4=`mysql -ss -u $user --password=$pw --host=vela $db -e " $trainquery4 "`
+            traincheck3=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainquery3 "`
+            traincheck4=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainquery4 "`
             traininsert1=" insert MCSequenceProcessStatus set fSequenceFirst=\"$firstruntrain\", fSequenceFileWritten=Now() "
             traininsert2=" insert MCSequences set fSequenceFirst=\"$firstruntrain\", fRunStart=\"$date\", fNumEvents=\"$trainevents\", fNumTriggers=\"$traintriggers\", fZBin=\"$zbin\", fSpectrumKEY=\"$trainspec\", fPSFKEY=\"$trainpsf\", fAddSpotSizeKEY=\"$trainass\", fAmplFadcKEY=\"$trainamplfadc\", fAtmosphericModelKEY=\"$trainatmo\", fObservationModeKEY=\"$trainobs\", fMCParticleKEY=\"$trainpart\", fReflectorVersionKEY=\"$trainrefl\", fCorsikaVersionKEY=\"$traincors\", fCameraVersionKEY=\"$traincam\", fViewConeAngleOKEY=\"$trainview\", fTestTrainKEY=2 "
@@ -132 +132 @@
             if [ "$traincheck3" == "" ]
             then
-               mysql -ss -u $user --password=$pw --host=vela $db -e " $traininsert1 "
+               mysql -ss -u $user --password=$pw --host=$ho $db -e " $traininsert1 "
             fi
             if [ "$traincheck4" == "" ]
             then
-               mysql -ss -u $user --password=$pw --host=vela $db -e " $traininsert2 "
+               mysql -ss -u $user --password=$pw --host=$ho $db -e " $traininsert2 "
             else
-               mysql -ss -u $user --password=$pw --host=vela $db -e " $trainupdate2 "
+               mysql -ss -u $user --password=$pw --host=$ho $db -e " $trainupdate2 "
             fi
             
@@ -166 +166 @@
             do
                testupdate=" update MCRunData set fSequenceFirst=\"$firstruntest\" where fRunNumber=\"$testrun\" "
-               mysql -ss -u $user --password=$pw --host=vela $db -e " $testupdate "
+               mysql -ss -u $user --password=$pw --host=$ho $db -e " $testupdate "
             done   
 
             testquery1=" select fSpectrumKEY, fPSFKEY, fAmplFadcKEY, fAtmosphericModelKEY, fObservationModeKEY, fMCParticleKEY, fReflectorVersionKEY, fCorsikaVersionKEY, fCameraVersionKEY, fViewConeAngleOKEY, fAddSpotSizeKEY from MCRunData where fRunNumber=\"$firstruntest\" "
             testquery2=" select sum(fNumEvents), sum(fNumtriggers) from MCRunData where fRunNumber in ($testruns2) "
-            testvalues=`mysql -ss -u $user --password=$pw --host=vela $db -e " $testquery1 "`
-            testvalues2=`mysql -ss -u $user --password=$pw --host=vela $db -e " $testquery2 "`
+            testvalues=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $testquery1 "`
+            testvalues2=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $testquery2 "`
             testspec=`echo $testvalues | cut -d" " -f1`
             testpsf=`echo $testvalues | cut -d" " -f2`
@@ -188 +188 @@
             testquery3=" select fSequenceFirst from MCSequenceProcessStatus where fSequenceFirst=\"$firstruntest\" "
             testquery4=" select fSequenceFirst from MCSequences where fSequenceFirst=\"$firstruntest\" "
-            testcheck3=`mysql -ss -u $user --password=$pw --host=vela $db -e " $testquery3 "`
-            testcheck4=`mysql -ss -u $user --password=$pw --host=vela $db -e " $testquery4 "`
+            testcheck3=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $testquery3 "`
+            testcheck4=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $testquery4 "`
             testinsert1=" insert MCSequenceProcessStatus set fSequenceFirst=\"$firstruntest\", fSequenceFileWritten=Now() "
             testinsert2=" insert MCSequences set fSequenceFirst=\"$firstruntest\", fRunStart=\"$date\", fNumEvents=\"$testevents\", fNumTriggers=\"$testtriggers\", fZBin=\"$zbin\", fSpectrumKEY=\"$testspec\", fPSFKEY=\"$testpsf\", fAddSpotSizeKEY=\"$testass\", fAmplFadcKEY=\"$testamplfadc\", fAtmosphericModelKEY=\"$testatmo\", fObservationModeKEY=\"$testobs\", fMCParticleKEY=\"$testpart\", fReflectorVersionKEY=\"$testrefl\", fCorsikaVersionKEY=\"$testcors\", fCameraVersionKEY=\"$testcam\", fViewConeAngleOKEY=\"$testview\", fTestTrainKEY=3 "
@@ -195 +195 @@
             if [ "$testcheck3" == "" ]
             then
-               mysql -ss -u $user --password=$pw --host=vela $db -e " $testinsert1 "
+               mysql -ss -u $user --password=$pw --host=$ho $db -e " $testinsert1 "
             fi
             if [ "$testcheck4" == "" ]
             then
-               mysql -ss -u $user --password=$pw --host=vela $db -e " $testinsert2 "
+               mysql -ss -u $user --password=$pw --host=$ho $db -e " $testinsert2 "
             else
-               mysql -ss -u $user --password=$pw --host=vela $db -e " $testupdate2 "
+               mysql -ss -u $user --password=$pw --host=$ho $db -e " $testupdate2 "
             fi