Changeset 9217 for trunk/MagicSoft/Mars/datacenter/scripts/fillcamera

Timestamp:

01/09/09 22:34:21 (16 years ago)

Author:

hoehne

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/scripts/fillcamera (modified) (4 diffs)

trunk/MagicSoft/Mars/datacenter/scripts/fillcamera

@@ -42 +42 @@
 checklock  >> $scriptlog 2>&1
 
+getdbsetup
+
 #mccampath=$mcpath/camera
 mccampath=/magic/montecarlo/camera
 #workaround
 cameradirs=`find /magic/montecarlo/camera -maxdepth 4 -mindepth 2 -type d ! -name Gamma ! -name Muon ! -name Proton ! -name Spot_?.?`
-#cameradirs=`find /magic/montecarlo/camera -maxdepth 3 -mindepth 2 -type d ! -name Gamma ! -name Muon ! -name Proton`
-#cameradirs=`find $mccampath -maxdepth 1 -mindepth 1 -type d`
 echo "camera dirs: "${cameradirs[@]}  >> $scriptlog 2>&1
 echo "" >> $scriptlog 2>&1
@@ -115 +115 @@
       
       
-      #   user="test"
-      #   db="TestMonteCarlo"
-      #   pw="Ics+eaTD"
-      user="operator"
-      db="MyMagicMonteCarlo"
-      pw="Ics+eMM!"
       cquery=" select fRunNumber from MCRunProcessStatus where fFileName=\"$calfile\" "
       pquery=" select fRunNumber from MCRunProcessStatus where fFileName=\"$pedfile\" "
       
-      crun=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $cquery "`
-      prun=`mysql -ss -u $user --password=$pw --host=$ho $db -e " $pquery "`
+      crun=`mysql -ss -u $us --password=$pw --host=$ho $db -e " $cquery "`
+      prun=`mysql -ss -u $us --password=$pw --host=$ho $db -e " $pquery "`
       cnum=`printf %08d $crun`
       pnum=`printf %08d $prun`
@@ -150 +144 @@
             echo "P run already there, do mysql update" >> $scriptlog 2>&1
    #         continue
-            mysql -ss -u $user --password=$pw --host=$ho $db -e " $pupdate "
+            mysql -ss -u $us --password=$pw --host=$ho $db -e " $pupdate "
          else 
             echo "linking P run for epoch $epo" >> $scriptlog 2>&1
             ln -sv $pedfile $newpedfile >> $scriptlog 2>&1
-            mysql -ss -u $user --password=$pw --host=$ho $db -e " $pupdate "
+            mysql -ss -u $us --password=$pw --host=$ho $db -e " $pupdate "
          fi
          
@@ -161 +155 @@
             echo "C run already there, do mysql update" >> $scriptlog 2>&1
    #         continue
-            mysql -ss -u $user --password=$pw --host=$ho $db -e " $cupdate "
+            mysql -ss -u $us --password=$pw --host=$ho $db -e " $cupdate "
          else 
             echo "linking C run for epoch $epo" >> $scriptlog 2>&1
             ln -sv $calfile $newcalfile >> $scriptlog 2>&1
-            mysql -ss -u $user --password=$pw --host=$ho $db -e " $cupdate "
+            mysql -ss -u $us --password=$pw --host=$ho $db -e " $cupdate "
          fi