def dropTables(schema,tablelist): try: db=dbUtil.dbUtil(schema) for tablename in tablelist: if tablename in [nameDealer.luminormTableName(),nameDealer.lumidataTableName(),nameDealer.trgdataTableName(),nameDealer.hltdataTableName()]: db.dropTable( nameDealer.idTableName(tablename) ) db.dropTable( nameDealer.entryTableName(tablename) ) db.dropTable( nameDealer.revmapTableName(tablename) ) if tablename in [nameDealer.trgTableName(),nameDealer.lumisummaryTableName(),nameDealer.lumisummaryv2TableName(),nameDealer.lumidetailTableName(),nameDealer.hltTableName()]: db.dropTable( nameDealer.idTableName(tablename) ) db.dropTable( tablename ) except : raise
def createIDTable(self, tableName, deleteOld=True): """ Create ID table for the given table.\n Input: name of the table which needs new associated id table Output: name of the id table created """ try: idtableName = nameDealer.idTableName(tableName) if deleteOld is True: self.__schema.dropIfExistsTable(idtableName) else: if self.__schema.existsTable(idtableName): print('table ' + idtableName + ' exists, do nothing') return description = coral.TableDescription() description.setName(idtableName) description.setPrimaryKey(nameDealer.idTableColumnDefinition()[0]) description.insertColumn(nameDealer.idTableColumnDefinition()[0], nameDealer.idTableColumnDefinition()[1]) idtableHandle = self.__schema.createTable(description) idtableHandle.privilegeManager().grantToPublic( coral.privilege_Select) inputData = coral.AttributeList() editor = idtableHandle.dataEditor() editor.rowBuffer(inputData) inputData[nameDealer.idTableColumnDefinition()[0]].setData(0) editor.insertRow(inputData) except Exception as e: raise RuntimeError('dbUtil.createIDTable' + str(e))
def createIDTable( self, tableName, deleteOld=True ): """ Create ID table for the given table.\n Input: name of the table which needs new associated id table Output: name of the id table created """ try: idtableName=nameDealer.idTableName(tableName) if deleteOld is True: self.__schema.dropIfExistsTable(idtableName) else: if self.__schema.existsTable(idtableName): print 'table '+idtableName+' exists, do nothing' return description = coral.TableDescription() description.setName( idtableName ) description.setPrimaryKey( nameDealer.idTableColumnDefinition()[0] ) description.insertColumn( nameDealer.idTableColumnDefinition()[0], nameDealer.idTableColumnDefinition()[1]) idtableHandle=self.__schema.createTable( description ) idtableHandle.privilegeManager().grantToPublic( coral.privilege_Select ) inputData = coral.AttributeList() editor = idtableHandle.dataEditor() editor.rowBuffer( inputData ) inputData[ nameDealer.idTableColumnDefinition()[0] ].setData(0) editor.insertRow( inputData ) except Exception, e: raise RuntimeError('dbUtil.createIDTable'+str(e))
def dropTable(self, tableName): """ Drop specified table.If associated Id table exists, drop also Id table """ try: self.__schema.dropIfExistsTable(tableName) self.__schema.dropIfExistsTable(nameDealer.idTableName(tableName)) except Exception as e: raise Exception(str(e))
def dropTable( self, tableName ): """ Drop specified table.If associated Id table exists, drop also Id table """ try: self.__schema.dropIfExistsTable( tableName ) self.__schema.dropIfExistsTable( nameDealer.idTableName(tableName) ) except Exception, e: raise Exception, str(e)
def dropTables(schema, tablelist): try: db = dbUtil.dbUtil(schema) for tablename in tablelist: if tablename in [ nameDealer.luminormTableName(), nameDealer.lumidataTableName(), nameDealer.trgdataTableName(), nameDealer.hltdataTableName() ]: db.dropTable(nameDealer.idTableName(tablename)) db.dropTable(nameDealer.entryTableName(tablename)) db.dropTable(nameDealer.revmapTableName(tablename)) if tablename in [ nameDealer.trgTableName(), nameDealer.lumisummaryTableName(), nameDealer.lumisummaryv2TableName(), nameDealer.lumidetailTableName(), nameDealer.hltTableName() ]: db.dropTable(nameDealer.idTableName(tablename)) db.dropTable(tablename) except: raise