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
