source: trunk/DataCheck/Tools/fill_cu.sh @ 19445

Last change on this file since 19445 was 19445, checked in by dorner, 5 months ago
updated CU (incl zd/th correction)
  • Property svn:executable set to *
File size: 2.3 KB
Line 
1#!/bin/bash
2
3sqlpw=/home/$USER/.mysql.pw.op
4dbname=factdata
5#sqlpw=/home/$USER/.mysql.pw.local
6#dbname=factdata20190212
7
8function fill_cu()
9{
10   query="UPDATE "$1" SET fCU="$2" WHERE fNight between "$3" AND "$4
11   mysql --defaults-file=$sqlpw -s -e "$query" 
12}
13
14# analysis tables
15lc=AnalysisResultsRunCutsLC
16isdc=AnalysisResultsRunISDC
17qla=AnalysisResultsRunLP
18
19
20# CU for ISDC analysis
21# A [20111115-20120619]:
22#determined w/o DCh (reference values missing)
23fill_cu $isdc 23.3 20111115 20120619 
24# B [20120620-20130124]:
25fill_cu $isdc 27.0 20120620 20130124 
26# C [20130125-20131003]:
27fill_cu $isdc 27.3 20130125 20131003 
28# D [20131004-20140520]:
29fill_cu $isdc 32.6 20131004 20140520 
30# E [20140520-20150715]:
31fill_cu $isdc 38.4 20140520 20150715 
32# F [20150716-20160218]:
33fill_cu $isdc 36.4 20150716 20160218 
34# G [20160218-20160831]:
35fill_cu $isdc 29.7 20160218 20160831 
36# H [20160901-20170430]:
37fill_cu $isdc 32.2 20160901 20170430 
38# I [20170501-20201231]:
39fill_cu $isdc 31.7 20170501 20201231 
40
41# CU for LC-Cuts
42# A [20111115-20120619]:
43#determined w/o DCh (reference values missing)
44fill_cu $lc 43.1 20111115 20120619 
45# B [20120620-20130124]:
46fill_cu $lc 53.8 20120620 20130124 
47# C [20130125-20131003]:
48fill_cu $lc 64.6 20130125 20131003 
49# D [20131004-20140520]:
50fill_cu $lc 64.7 20131004 20140520 
51# E [20140520-20150715]:
52fill_cu $lc 71.4 20140520 20150715 
53# F [20150716-20160218]:
54fill_cu $lc 65.4 20150716 20160218 
55# G [20160218-20160831]:
56fill_cu $lc 53.0 20160218 20160831 
57# H [20160901-20170430]:
58fill_cu $lc 59.7 20160901 20170430 
59# I [20170501-20201231]:
60fill_cu $lc 60.7 20170501 20201231 
61
62# CU values for QLA
63# see https://www.fact-project.org/logbook/showthread.php?tid=6343&pid=27272#pid27272
64# determined w/o zd/th-correction
65# A [20111115-20120619]:
66#determined w/o DCh (reference values missing)
67fill_cu $qla 18.1 20111115 20120619 
68# B [20120620-20130124]:
69fill_cu $qla 19.9 20120620 20130124 
70# C [20130125-20131003]:
71fill_cu $qla 20.8 20130125 20131003 
72# D [20131004-20140520]:
73fill_cu $qla 17.3 20131004 20140520 
74# E [20140520-20150715]:
75fill_cu $qla 23.0 20140520 20150715 
76# F [20150716-20160218]:
77fill_cu $qla 21.7 20150716 20160218 
78# G [20160218-20160831]:
79fill_cu $qla 16.1 20160218 20160831 
80# H [20160901-20170430]:
81fill_cu $qla 33.4 20160901 20170430 
82# I [20170501-20201231]:
83fill_cu $qla 15.3 20170501 20201231 
84
Note: See TracBrowser for help on using the repository browser.