Reference Manual

def python.IdGenerator.IdGenerator.createIDTable	(	self,
		idtableName,
		deleteOld = `True`
	)

Create ID table 'tableName_ID' for the given table.\n
Input: name of the table which needs new associated id table
Output: name of the id table created

Definition at line 55 of file IdGenerator.py.

References python.IdGenerator.IdGenerator.__idTableColumnName, python.IdGenerator.IdGenerator.__idTableColumnType, python.IdGenerator.IdGenerator.__schema, and python.DBImpl.DBImpl.__schema.

Referenced by dbUtil.dbUtil.createTable().

 
     def createIDTable( self, idtableName, deleteOld=True ):
         """Create ID table 'tableName_ID' for the given table.\n
         Input: name of the table which needs new associated id table
         Output: name of the id table created
         """
         dbop=DBImpl.DBImpl(self.__schema)
         try:
             if dbop.tableExists(idtableName) is True:
                 if deleteOld is True:
                     dbop.dropTable(idtableName)
                 else:
                     return
             description = coral.TableDescription();
             description.setName(idtableName)
             description.insertColumn(self.__idTableColumnName, self.__idTableColumnType)
             idtableHandle=self.__schema.createTable( description )
             idtableHandle.privilegeManager().grantToPublic( coral.privilege_Select )
             inputData = coral.AttributeList()
             editor = idtableHandle.dataEditor()
             editor.rowBuffer( inputData )
             inputData[self.__idTableColumnName].setData(1)
             editor.insertRow( inputData )
         except Exception, e:
raise Exception, str(e)

python.IdGenerator.IdGenerator.createIDTable

def createIDTable

Definition: IdGenerator.py:55

python.IdGenerator.IdGenerator.__idTableColumnType

__idTableColumnType

Definition: IdGenerator.py:10

python.IdGenerator.IdGenerator.__schema

__schema

Definition: IdGenerator.py:8

python.DBImpl.DBImpl

Definition: DBImpl.py:4

python.IdGenerator.IdGenerator.__idTableColumnName

__idTableColumnName

Definition: IdGenerator.py:9

def python.IdGenerator.IdGenerator.getNewID	(	self,
		IDtableName
	)

Return the ID value in the specified ID table.\n
Input: ID table name

Definition at line 11 of file IdGenerator.py.

References python.IdGenerator.IdGenerator.__idTableColumnName, and data.

 
     def getNewID( self, IDtableName):
         """Return the ID value in the specified ID table.\n
         Input: ID table name
         """
         try:
             query = self.__schema.tableHandle(IDtableName).newQuery()
             query.addToOutputList(self.__idTableColumnName)
             query.setForUpdate() #lock it
             cursor = query.execute()
             result = 0
             while ( cursor.next() ):
                 result = cursor.currentRow()[self.__idTableColumnName].data()
             del query
             return result
         except Exception, e:
raise Exception, str(e)

python.IdGenerator.IdGenerator.getNewID

def getNewID

Definition: IdGenerator.py:11

data

char data[epos_bytes_allocation]

Definition: EPOS_Wrapper.h:82

python.IdGenerator.IdGenerator.__idTableColumnName

__idTableColumnName

Definition: IdGenerator.py:9

def python.IdGenerator.IdGenerator.incrementNextID	(	self,
		IDtableName
	)

Set the nextID in the IDTableName to current id value + 1 .\n
Input: ID table name.

Definition at line 27 of file IdGenerator.py.

References python.IdGenerator.IdGenerator.__idTableColumnName, python.IdGenerator.IdGenerator.__idTableColumnType, and data.

 
     def incrementNextID( self, IDtableName ):
         """Set the nextID in the IDTableName to current id value + 1 .\n
         Input: ID table name.
         """
         try:
             tableHandle = self.__schema.tableHandle(IDtableName)
             query = tableHandle.newQuery()
             query.addToOutputList(self.__idTableColumnName)
             query.setForUpdate() #lock it
             cursor = query.execute()
             result = 0
             while ( cursor.next() ):
                 result = cursor.currentRow()[0].data()
             del query
             dataEditor = tableHandle.dataEditor()
             inputData = coral.AttributeList()
             inputData.extend( 'newid', self.__idTableColumnType )
             inputData['newid'].setData(result+1)
             dataEditor.updateRows('nextID = :newid','',inputData)
         except Exception, e:
raise Exception, str(e)