idDealer::idDealer Class Reference

List of all members.

Public Member Functions
def	__init__
def	generateNextIDForTable
def	getIDColumnDefinition
def	getIDforTable
Private Attributes
	__idTableColumnName
	__idTableColumnType
	__schema

---

Detailed Description

Manages the autoincremental ID values.\n
Input: coral.schema object

Definition at line 3 of file idDealer.py.

---

Constructor & Destructor Documentation

def idDealer::idDealer::__init__	(		self,
			schema
	)

Definition at line 7 of file idDealer.py.

00008                                   :
00009         self.__schema = schema
00010         self.__idTableColumnName = nameDealer.idTableColumnDefinition()[0]
00011         self.__idTableColumnType = nameDealer.idTableColumnDefinition()[1]
        

---

Member Function Documentation

def idDealer::idDealer::generateNextIDForTable	(		self,
			tableName
	)

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

Definition at line 33 of file idDealer.py.

                                                 :
        """
        Set the nextID in the IDTableName to current id value + 1 .\n
        Input: ID table name.
        """
        try:
            idtableName = nameDealer.idTableName(tableName)
            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()
            dataEditor = tableHandle.dataEditor()
            inputData = coral.AttributeList()
            dataEditor.updateRows('NEXTID = NEXTID+1','',inputData)
            del query            
            return result+1
        except Exception, e:
            raise Exception, str(e)

def idDealer::idDealer::getIDColumnDefinition

(

self

)

Definition at line 12 of file idDealer.py.

00013                                      :
00014         return (self.__idTableColumnName, self.__idTableColumnType)
    

def idDealer::idDealer::getIDforTable	(		self,
			tableName
	)

get the new id value to use for the given table

Definition at line 15 of file idDealer.py.

                                        :
        """
        get the new id value to use for the given table
        """
        try:
            idtableName = nameDealer.idTableName(tableName)
            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)

---

Member Data Documentation

idDealer::idDealer::__idTableColumnName [private]

Definition at line 7 of file idDealer.py.

idDealer::idDealer::__idTableColumnType [private]

Definition at line 7 of file idDealer.py.

idDealer::idDealer::__schema [private]

Definition at line 7 of file idDealer.py.