|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
# A script to run as a cron job to execute O2O for EcalPedestals
# Prerequisites: 1. A PL/SQL procedure to execute payload
# transformation
# 2. A bootstrapped CMSSW project to set your
# environment to use the programs setup_pool_database and
# cmscond_build_iov
# 3. The mapping xml files for the object to do o2o on
# Warning: O2O needs to have been executed once before, or remove
# the -a option on cmscond_build_iov for the first execution
# TODO: CORAL_AUTH_* shouldn't need to be set! Should use authentication XML
# Basic paths and variables
O2ODIR=/home/egeland/O2O
CMSSW_VER=CMSSW_0_5_0
SCRAM_PATH=/afs/cern.ch/cms/utils
SCRAM_ARCH=slc3_ia32_gcc323
CMSSW_DIR=${O2ODIR}/${CMSSW_VER}
LOG=$O2ODIR/o2o-log.txt
# Info about the object to be o2o'd
MAPPING_PATH=${CMSSW_DIR}/src/CondTools/Ecal/src
MAPPING_FILE=${MAPPING_PATH}/EcalPedestals-mapping-custom_1.0.xml
OBJECT_LIBRARY=CondFormatsEcalObjects
OBJECT_NAME=EcalPedestals
OBJECT_TABLE=ECALPEDESTALS
TAG=from_online
# Online DB info
ONLINE_DB=ecalh4db
ONLINE_DB_USER=cond01
ONLINE_DB_PASSWORD=******
# Offline DB info
OFFLINE_DB=devdb10
OFFLINE_DB_USER=cms_ecal
OFFLINE_DB_PASSWORD=******
OFFLINE_CONNECT=oracle://${OFFLINE_DB}/${OFFLINE_DB_USER}
# POOL catalog info
#MY_CATALOG=xmlcatalog_file:${O2ODIR}/ecal-offline-catalog.xml
MY_CATALOG=relationalcatalog_oracle://${OFFLINE_DB}/${OFFLINE_DB_USER}
# Log the date
echo -n [`date "+%Y-%m-%d %H:%M:%S"`] >> $LOG;
T_START=`date +%s`
# Set the environment
echo -n " Setting env..." >> $LOG;
PATH=$PATH:$SCRAM_PATH
cd $CMSSW_DIR;
eval `scramv1 runtime -sh`;
cd $O20DIR;
COND_UTIL_PATH=${LOCALRT}/src/CondTools/Utilities/bin
PATH=$PATH:$COND_UTIL_PATH
export POOL_CATALOG=${MY_CATALOG}
echo $POOL_CATALOG
export CORAL_AUTH_USER=$OFFLINE_DB_USER
export CORAL_AUTH_PASSWORD=$OFFLINE_DB_PASSWORD
#export POOL_AUTH_PATH=${O2ODIR}
###
### O2O happens here
###
# Transfer payload data
echo -n "Transfering payload data..." >> $LOG;
echo "call payload_o2o();" | sqlplus -S ${ONLINE_DB_USER}/${ONLINE_DB_PASSWORD}@${ONLINE_DB} 2>> $LOG
# Poolify offline objects
echo -n "Registering to POOL..." >> $LOG;
setup_pool_database $OBJECT_NAME \
$OBJECT_LIBRARY \
$OFFLINE_CONNECT \
$MAPPING_FILE -o $O2ODIR 2>>$LOG
# Assign iov
echo -n "Assigning IOV..." >> $LOG;
cmscond_build_iov -c $OFFLINE_CONNECT \
-d $OBJECT_LIBRARY \
-t $OBJECT_TABLE \
-o $OBJECT_NAME \
-a $TAG 2>>$LOG
# Log the duration of the O2O
T_FINISH=`date +%s`;
T_JOB=$(($T_FINISH-$T_START))
echo "Done ($T_JOB s)." >> $LOG;
|