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

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