Ignore:
Timestamp:
04/11/19 15:34:52 (6 years ago)
Author:
Daniela Dorner
Message:
added values for new periods
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/DataCheck/Tools/fill_r750.sh

    r19424 r19495  
    55dbname=factdata
    66# fill only corrected R750
    7 short="yes" # comment line to fill also reference values
     7#short="yes" # comment line to fill also reference values
    88
    99# setup for zd- and th-correction:
     
    121121       254.6 #87
    122122       251.5 #88
    123        249.0 #89
     123       249.4 #89
     124       251.9 #90
     125       249.4 #91
     126       240.0 #92 (current period)
    124127       )
    125128
     
    129132for (( i=0; i < ${#rates[@]} ; i++))
    130133do
     134   echo "Filling P"$i
    131135   if [ "${rates[$i]}" = "0.0" ]
    132136   then
     
    136140   fi
    137141   query="UPDATE RunInfo SET fR750Ref="$rate" WHERE fPeriod="$i
    138    #echo $query
    139    mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query"
     142   echo "  "$query
     143   mysql --defaults-file=$sqlpw -s -e "$query"
    140144done
    141145
     146echo "Filling split periods..."
    142147# several periods are split:
    143148#   update the values for those
    144149# 71b
    145150query="UPDATE RunInfo SET fR750Ref=250.0 WHERE fPeriod=71 AND fNight>20170726"
     151   echo "  "$query
    146152mysql --defaults-file=$sqlpw -s -e "$query"
    147153# 69b
    148154query="UPDATE RunInfo SET fR750Ref=253.0 WHERE fPeriod=69 AND fNight>20170524"
     155   echo "  "$query
    149156mysql --defaults-file=$sqlpw -s -e "$query"
    150157# 60a
    151158query="UPDATE RunInfo SET fR750Ref=239.3 WHERE fPeriod=60 AND fNight<20170901"
     159   echo "  "$query
    152160mysql --defaults-file=$sqlpw -s -e "$query"
    153161# 46a
    154162query="UPDATE RunInfo SET fR750Ref=271 WHERE fPeriod=46 AND fNight<20150716"
     163   echo "  "$query
    155164mysql --defaults-file=$sqlpw -s -e "$query"
    156165# 24b
    157166query="UPDATE RunInfo SET fR750Ref=286.2 WHERE fPeriod=24 AND fNight>20131003"
     167   echo "  "$query
    158168mysql --defaults-file=$sqlpw -s -e "$query"
    159169
Note: See TracChangeset for help on using the changeset viewer.