def __init__(self):
self.Records = []
self.__ecalCondDB = EcalCondDB.EcalCondDB()
self.__condDB_Utils = CondDB_Utils.CondDB_Utils()
self.__payloadUserDB = payloadUserDB.payloadUserDB(db_file=config.db_data.users_db_conn_str)
self.tablePath = config.folders.table_dir
self.iovTablePath = config.folders.iov_table_dir
self.masker = dm.Masker()
self.iov_table_name = config.folders.iov_table_name
self.tag_table_name = config.folders.tag_table_name
self.__plotsdir = config.folders.plots_dir
self.__trendplotsdir = config.folders.trend_plots_dir
self.__histodir = config.folders.histo_dir
self.__xmldir = config.folders.xml_dir
self.__tmpdir = config.folders.tmp_dir
def __init__(self):
self.Records = []
self.__ecalCondDB = EcalCondDB.EcalCondDB()
self.__condDB_Utils = CondDB_Utils.CondDB_Utils()
self.__payloadUserDB = payloadUserDB.payloadUserDB(
db_file=config.db_data.users_db_conn_str)
self.tablePath = config.folders.table_dir
self.iovTablePath = config.folders.iov_table_dir
self.masker = dm.Masker()
self.iov_table_name = config.folders.iov_table_name
self.tag_table_name = config.folders.tag_table_name
self.__plotsdir = config.folders.plots_dir
self.__trendplotsdir = config.folders.trend_plots_dir
self.__histodir = config.folders.histo_dir
self.__xmldir = config.folders.xml_dir
self.__tmpdir = config.folders.tmp_dir
result += "</tr>\n"
result += '</tbody>'
result += '</table>'
result += result_js+"</script>"
self.db.commitTransaction()
return result
if __name__ == "__main__":
l = LastIOVSince()
#last = l("runinfo_start_31X_hlt")
#print last
connection_list =['CMS_COND_31X_ALIGNMENT','CMS_COND_31X_RUN_INFO','CMS_COND_34X_ECAL','CMS_COND_34X_DQM']#,'CMS_COND_30X_STRIP','CMS_COND_30X_HCAL','CMS_COND_30X_BTAU']
connection_list =['CMS_COND_34X_ECAL']#,'CMS_COND_30X_STRIP','CMS_COND_30X_HCAL','CMS_COND_30X_BTAU']
#connection_list = ['CMS_COND_31X_RUN_INFO']
#connection_list = ['CMS_COND_31X_ECAL']
__payloadUserDB = payloadUserDB.payloadUserDB(db_file='sqlite:///Users.db')
db_list = __payloadUserDB.getDBs()
for db in db_list:
db = str(db.values()[0])
schema = __payloadUserDB.getSchemas(dbNameSearch=db)
for schema_val in schema:
print schema_val
for connection in connection_list:
connection_string = 'oracle://cms_orcoff_prep/'+connection
print connection_string
l.initDB(dbName = connection_string)
#print l.buildTable()
print l.writeTable()
#last = l("EcalPedestals_v5_online")
#print last
return result
if __name__ == "__main__":
l = LastIOVSince()
#last = l("runinfo_start_31X_hlt")
#print last
connection_list = [
'CMS_COND_31X_ALIGNMENT', 'CMS_COND_31X_RUN_INFO', 'CMS_COND_34X_ECAL',
'CMS_COND_34X_DQM'
] #,'CMS_COND_30X_STRIP','CMS_COND_30X_HCAL','CMS_COND_30X_BTAU']
connection_list = [
'CMS_COND_34X_ECAL'
] #,'CMS_COND_30X_STRIP','CMS_COND_30X_HCAL','CMS_COND_30X_BTAU']
#connection_list = ['CMS_COND_31X_RUN_INFO']
#connection_list = ['CMS_COND_31X_ECAL']
__payloadUserDB = payloadUserDB.payloadUserDB(db_file='sqlite:///Users.db')
db_list = __payloadUserDB.getDBs()
for db in db_list:
db = str(db.values()[0])
schema = __payloadUserDB.getSchemas(dbNameSearch=db)
for schema_val in schema:
print schema_val
for connection in connection_list:
connection_string = 'oracle://cms_orcoff_prep/' + connection
print connection_string
l.initDB(dbName=connection_string)
#print l.buildTable()
print l.writeTable()
#last = l("EcalPedestals_v5_online")
#print last
