Package pysql :: Module pysqloraobjects :: Class OraTable
[hide private]
[frames] | no frames]

Class OraTable

source code


Oracle table

Instance Methods [hide private]
 
__init__(self, tableOwner="", tableName="")
Table creation
source code
 
getIndexedColumns(self, db)
Gets all table's indexed columns
source code
 
getPrimaryKeys(self, db)
Gets table primary key column name
source code
 
getLastAnalyzed(self, db)
Gets date of last statistics computation
source code
 
getNumRows(self, db)
Gets number of rows from table's statistics
source code
 
getAvgRowLength(self, db)
Gets average length of a single row from table's statistics
source code
 
getUsedBlocks(self, db)
Gets number of used blocks from table's statistics
source code
 
getNeededBlocks(self, db)
Gets number of really used blocks from rowids
source code
 
isPartitioned(self, db)
Gets True if the table is partitioned
source code

Inherited from OraTabular: getComment, getNumberOfColumns, getRowCount, getTableColumns

Inherited from OraObject: __eq__, __hash__, __str__, getCopy, getCreated, getDDL, getFullName, getLastDDL, getName, getOwner, getStatus, getType, guessInfos, guessStatus, setName, setOwner, setStatus, setType

Inherited from OraSegment: getTablespace

Method Details [hide private]

__init__(self, tableOwner="", tableName="")
(Constructor)

source code 

Table creation

Overrides: OraObject.__init__

getIndexedColumns(self, db)

source code 

Gets all table's indexed columns

Returns:
array with column_name, index_name and index_position

getPrimaryKeys(self, db)

source code 

Gets table primary key column name

Returns:
list of columns used in primary key. Empty list if not PK found

isPartitioned(self, db)

source code 

Gets True if the table is partitioned

Returns:
true if table is partitioned, false otherwise