In This Package:

writerTest2.py

Go to the documentation of this file.

#!/usr/bin/env python
## To run:
## nuwa.py writerTest.py
import os
os.environ.setdefault('DBCONF',"testdb")
assert os.environ.get('DBCONF',None) != "offline_db", "writing to offline_db is prohibited" 

#os.environ['DBCONF'] = "testdb"
#os.environ['DBCONF'] = "offline_db"

# environments used by DBI
#os.environ['ENV_TSQL_URL'] = 'mysql://dybdb1.ihep.ac.cn/testdb;'
#os.environ['ENV_TSQL_USER'] = user
#os.environ['ENV_TSQL_PSWD'] = passwd

# environments used by DatabaseSvc
#os.environ['DYB_DB_HOST'] = host 
#os.environ['DYB_DB_NAME'] = db
#os.environ['DYB_DB_USER'] = user
#os.environ['DYB_DB_PSWD'] = passwd


from DBWriter.DBWriterConf import DBWriterAlg
DBWA = DBWriterAlg()
#DBWA.runNumber = 1643 
#DBWA.runNumber = 5180 
#DBWA.runNumber = 5514 
DBWA.runNumber = 5647
#DBWA.runNumber = 6872

#DBWA.inputFileName = '/publicfs/dyb/user/anfp/DBIW/DBWriter/share/pmtCalib/pmtCalibTable.run1643.txt'
#DBWA.inputFileName = '/publicfs/dyb/user/anfp/DBIW/DBWriter/share/pmtCalib/pmtCalibTable.run5180.txt'
#DBWA.inputFileName = '/publicfs/dyb/user/anfp/DBIW/DBWriter/share/pmtCalib/pmtCalibTable.run5514.txt'
DBWA.inputFileName = 'DYB_SAB_AD1.txt'
DBWA.timeWindow = 100000000 #second
DBWA.isSim = False
DBWA.subSite = 2
DBWA.siteMask = 32
#if want to write pmt calibrate data to database
DBWA.category = 'pmt'
#if want to write fee calibrate data to database
#DBWA.category = 'fee'
print "*****************************" 
print DBWA.runNumber 
print DBWA.inputFileName
print DBWA.timeWindow
print DBWA.category

import DBWriter
DBWriter.configure()

---