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