| 1 | #!/bin/bash
|
|---|
| 2 |
|
|---|
| 3 | sqlpw=/home/$USER/.mysql.pw.op
|
|---|
| 4 | dbname=factdata
|
|---|
| 5 | sqlpw=/users/fact/.mysql.pw
|
|---|
| 6 | #sqlpw=/home/$USER/.mysql.pw.local
|
|---|
| 7 | #dbname=factdata20190212
|
|---|
| 8 |
|
|---|
| 9 | function 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
|
|---|
| 16 | lc=AnalysisResultsRunCutsLC
|
|---|
| 17 | isdc=AnalysisResultsRunISDC
|
|---|
| 18 | qla=AnalysisResultsRunLP
|
|---|
| 19 |
|
|---|
| 20 |
|
|---|
| 21 | # CU for ISDC analysis
|
|---|
| 22 | # A [20111115-20120619]:
|
|---|
| 23 | #determined w/o DCh (reference values missing)
|
|---|
| 24 | fill_cu $isdc 23.3 20111115 20120619
|
|---|
| 25 | # B [20120620-20130124]:
|
|---|
| 26 | fill_cu $isdc 27.0 20120620 20130124
|
|---|
| 27 | # C [20130125-20131003]:
|
|---|
| 28 | fill_cu $isdc 27.3 20130125 20131003
|
|---|
| 29 | # D [20131004-20140520]:
|
|---|
| 30 | fill_cu $isdc 32.6 20131004 20140520
|
|---|
| 31 | # E [20140520-20150715]:
|
|---|
| 32 | fill_cu $isdc 38.4 20140520 20150715
|
|---|
| 33 | # F [20150716-20160218]:
|
|---|
| 34 | fill_cu $isdc 36.4 20150716 20160218
|
|---|
| 35 | # G [20160218-20160831]:
|
|---|
| 36 | fill_cu $isdc 29.7 20160218 20160831
|
|---|
| 37 | # H [20160901-20170430]:
|
|---|
| 38 | fill_cu $isdc 32.2 20160901 20170430
|
|---|
| 39 | # I [20170501-20201231]:
|
|---|
| 40 | fill_cu $isdc 31.7 20170501 20201231
|
|---|
| 41 |
|
|---|
| 42 | # CU for LC-Cuts
|
|---|
| 43 | # A [20111115-20120619]:
|
|---|
| 44 | #determined w/o DCh (reference values missing)
|
|---|
| 45 | fill_cu $lc 43.1 20111115 20120619
|
|---|
| 46 | # B [20120620-20130124]:
|
|---|
| 47 | fill_cu $lc 53.8 20120620 20130124
|
|---|
| 48 | # C [20130125-20131003]:
|
|---|
| 49 | fill_cu $lc 64.6 20130125 20131003
|
|---|
| 50 | # D [20131004-20140520]:
|
|---|
| 51 | fill_cu $lc 64.7 20131004 20140520
|
|---|
| 52 | # E [20140520-20150715]:
|
|---|
| 53 | fill_cu $lc 71.4 20140520 20150715
|
|---|
| 54 | # F [20150716-20160218]:
|
|---|
| 55 | fill_cu $lc 65.4 20150716 20160218
|
|---|
| 56 | # G [20160218-20160831]:
|
|---|
| 57 | fill_cu $lc 53.0 20160218 20160831
|
|---|
| 58 | # H [20160901-20170430]:
|
|---|
| 59 | fill_cu $lc 59.7 20160901 20170430
|
|---|
| 60 | # I [20170501-20201231]:
|
|---|
| 61 | fill_cu $lc 60.7 20170501 20201231
|
|---|
| 62 |
|
|---|
| 63 | # CU values for QLA
|
|---|
| 64 | # see https://www.fact-project.org/logbook/showthread.php?tid=6343&pid=27272#pid27272
|
|---|
| 65 | # determined w/o zd/th-correction
|
|---|
| 66 | # A [20111115-20120619]:
|
|---|
| 67 | #determined w/o DCh (reference values missing)
|
|---|
| 68 | fill_cu $qla 18.1 20111115 20120619
|
|---|
| 69 | # B [20120620-20130124]:
|
|---|
| 70 | fill_cu $qla 19.9 20120620 20130124
|
|---|
| 71 | # C [20130125-20131003]:
|
|---|
| 72 | fill_cu $qla 20.8 20130125 20131003
|
|---|
| 73 | # D [20131004-20140520]:
|
|---|
| 74 | fill_cu $qla 17.3 20131004 20140520
|
|---|
| 75 | # E [20140520-20150715]:
|
|---|
| 76 | fill_cu $qla 23.0 20140520 20150715
|
|---|
| 77 | # F [20150716-20160218]:
|
|---|
| 78 | fill_cu $qla 21.7 20150716 20160218
|
|---|
| 79 | # G [20160218-20160831]:
|
|---|
| 80 | fill_cu $qla 16.1 20160218 20160831
|
|---|
| 81 | # H [20160901-20170430]:
|
|---|
| 82 | fill_cu $qla 33.4 20160901 20170430
|
|---|
| 83 | # I [20170501-20201231]:
|
|---|
| 84 | fill_cu $qla 15.3 20170501 20201231
|
|---|
| 85 |
|
|---|
