# Changeset 9593

Ignore:
Timestamp:
Jun 24, 2010, 12:03:34 PM (10 years ago)
Message:
*** empty log message ***
Location:
trunk/MagicSoft/Mars
Files:
4 edited

Unmodified
Removed
• ## trunk/MagicSoft/Mars/Changelog

 r9592 -*-*- END OF LINE -*-*- 2010/06/24 Daniela Dorner * datacenter/scripts/runceres: - added (script to run telescope simulation of file basis) * datacenter/scripts/sourcefile, resources/steps_fact.rc: - bugfixes: changed joins to get correct queries for all cases * datacenter/scripts/setup.wue.fact.mc: - changed path for setup files - added runceres to jobmanager settings 2010/06/22 Daniela Dorner
• ## trunk/MagicSoft/Mars/datacenter/scripts/setup.wue.fact.mc

 r9590 logpath=/magic/datacenter/fact/autologs lockpath=/magic/datacenter/fact/locks setuppath=/magic/datacenter/fact/setup setuppath=/magic/simulated/setup ## paths of data #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" 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

 r9592 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 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
• ## trunk/MagicSoft/Mars/resources/steps_fact.rc

 r9591 Corsika.Primaries: fRunNumber, fFileNumber Corsika.SpecialJoin: LEFT JOIN CeresInfo USING(fRunNumber, fFileNumber) Corsika.Join: LEFT JOIN CorsikaStatus USING(fRunNumber, fFileNumber) Ceres.Primaries: fRunNumber, fFileNumber, fCeresSetupKEY Ceres.SpecialJoin: LEFT JOIN CeresInfo USING(fRunNumber, fFileNumber) Ceres.SpecialJoin: LEFT JOIN CeresInfo USING(fRunNumber, fFileNumber, fCeresSetupKEY) Ceres.Join: LEFT JOIN CeresStatus USING(fRunNumber, fFileNumber) LEFT JOIN CeresInfo USING(fRunNumber, fFileNumber, fCeresSetupKEY) Ceres.Needs: Corsika
Note: See TracChangeset for help on using the changeset viewer.