Changeset 9593 for trunk/MagicSoft/Mars/datacenter

Timestamp:

06/24/10 12:03:34 (14 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/scripts

Files:

• setup.wue.fact.mc (modified) (3 diffs)
• sourcefile (modified) (2 diffs)

trunk/MagicSoft/Mars/datacenter/scripts/setup.wue.fact.mc

@@ -43 +43 @@
 logpath=/magic/datacenter/fact/autologs
 lockpath=/magic/datacenter/fact/locks
-setuppath=/magic/datacenter/fact/setup
+setuppath=/magic/simulated/setup
 
 ## paths of data
@@ -73 +73 @@
 
 #addresses to which the errors are sent
-erradrs="daniela.dorner@unige.ch" 
+erradrs="dorner@astro.uni-wuerzburg.de" 
 #addresses to which the changes are sent
-adrs="daniela.dorner@unige.ch" 
+adrs="dorner@astro.uni-wuerzburg.de" 
 
 
@@ -97 +97 @@
 pnototalwe=(     42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42 )
 
-pnocorsika=(     30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 )
-pnoceres=(       12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 )
-pnocprun=(       12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 )
-pnocallisto=(    32 32 32 32 32 20 20 18 18 12 12 12 12 12 12 12 12 12 12 18 18 20 20 32 )
+pnocorsika=(     20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 )
+pnoceres=(       15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 )
+pnocprun=(       15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 )
+pnocallisto=(    32 32 32 32 32 20 20 18 18 15 15 15 15 15 15 15 15 15 15 18 18 20 20 32 )
 pnostar=(        10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 )
 
-pnocorsikawe=(   30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 30 )
-pnocereswe=(     12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 )
-pnocprunwe=(     12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 )
+pnocorsikawe=(   20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 )
+pnocereswe=(     15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 )
+pnocprunwe=(     15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 )
 pnocallistowe=(  32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 )
 pnostarwe=(      10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 )
 
 # set variables for jobmanager 
-scripts=( "runcorsika" ) 
-scriptscolname=( "Corsika" ) 
-pnosweek=( ${pnocorsika[@]} ) 
-pnoswe=( ${pnocorsikawe[@]} ) 
+scripts=( "runcorsika" "runceres" ) 
+scriptscolname=( "Corsika" "Ceres" ) 
+pnosweek=( ${pnocorsika[@]} ${pnoceres[@]} ) 
+pnoswe=( ${pnocorsikawe[@]} ${pnocereswe[@]} ) 
 

trunk/MagicSoft/Mars/datacenter/scripts/sourcefile

@@ -500 +500 @@
    query=" UPDATE "$step"Status "
    # add joins to the influenced tables
+   stepspecialjoin=""
    for influence in $influences
    do
-      # make sure that the right join is done 
-      #   in case the is a 'Join' given for the 
-      #   influenced step, this is added
-      # otherwise it is checked whether the executed step
-      #   itself needs a 'Join' (i.e. has different primaries)
-      #   if yes, the tables are joined with the primaries of the influenced step
-      #   else with the primaries of the executed step itself
-      stdjoin=`getjoin $influence`
-      if ! [ "$stdjoin" = "" ]
+      inflprims=( `getprimary $influence` )
+      # make sure that the correct joins are used
+      # in case the primaries of the step and the influence are 
+      #   the same, the tables are join with these primaries
+      # otherwise they are joined with the primaries of the influence
+      if [ "`echo ${inflprims[@]}`" == "`echo ${prims[@]}`" ]
       then 
-         query=$query" "$stdjoin" "
-      else
-         stdjoin2=`getjoin $step`
-         if [ "$stdjoin2" == "" ]
+         query=$query" LEFT JOIN "$influence"Status USING (${prims[@]}) "
+      else 
+         prims2=`getprimary $step | sed -e "s/\ //g"`
+         primstest=`echo ${inflprims[@]} | sed -e "s/\ //g" | sed -e "s/$prims2//g"`
+         if [ "$primstest" == "`echo ${inflprims[@]} | sed -e "s/\ //g"`" ]
          then
-            query=$query" LEFT JOIN "$influence"Status USING("`getprimary $influence`") "
+            if [ "$stepspecialjoin" == "" ]
+            then
+               stepspecialjoin=`getspecialjoin $step`
+               query=$query" "$stepspecialjoin" "
+            fi
+            query=$query" LEFT JOIN "$influence"Status USING (${inflprims[@]}) "
          else
-            query=$query" LEFT JOIN "$influence"Status USING("`getprimary $step`") "
+            infljoin=`getjoin $influence`
+            if [ "$infljoin" = "" ]
+            then
+               query=$query" LEFT JOIN "$influence"Status USING (${prims[@]}) "
+            else
+               query=$query" "$infljoin
+               # warning: this is a workaround
+               #  it has to be checked whether it works for all steps
+               stepspecialjoin="not empty"
+            fi
          fi
       fi
@@ -543 +556 @@
       s=0
    fi
-   query=$query" "`echo ${prims[0]} | sed -e 's/,//g'`"='${primaries[$s*${#prims[@]}]}'"
+   query=$query" "$step"Status."`echo ${prims[0]} | sed -e 's/,//g'`"='${primaries[$s*${#prims[@]}]}'"
    for (( j=1 ; j < ${#prims[@]} ; j++ ))
    do
-      query=$query" AND "`echo ${prims[$j]} | sed -e 's/,//g'`"='${primaries[$s*${#prims[@]}+$j]}' "
+      query=$query" AND "$step"Status."`echo ${prims[$j]} | sed -e 's/,//g'`"='${primaries[$s*${#prims[@]}+$j]}' "
    done   
    # print query