Home       Trees       Indices       Help   
pysql
Package pysql :: Module pysqloraobjects :: Class OraTabular
[hide private]
[frames] | no frames]

Class OraTabular

source code

Father of tables, partitioned tables, views, materialized views. All objects that have rows and lines. The name is not very sexy. Anybody has a better choice?

Instance Methods [hide private]
 
__init__(self, objectOwner="", objectName="")
Tabular object creation		 source code
 
getRowCount(self, db)
Returns: row count (select count(*) from ...)		 source code
 
getComment(self, db)
Returns: db comment of the object		 source code
 
getTableColumns(self, db, sort=False)
Gets table or view columns		 source code
 
getNumberOfColumns(self, db)
Returns: the number (int) of columns of the table/view		 source code

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

Method Details [hide private]

__init__(self, objectOwner="", objectName="")
(Constructor)

source code 

Tabular object creation

Overrides: OraObject.__init__

getRowCount(self, db)

source code 
Returns:
row count (select count(*) from ...)

getComment(self, db)

source code 
Returns:
db comment of the object

getTableColumns(self, db, sort=False)

source code 

Gets table or view columns

Parameters:
  • sort (bool) - sort column in alphabetic order instead of Oracle order. Default is false
Returns:
array of column_name, columns_type, comments

getNumberOfColumns(self, db)

source code 
Returns:
the number (int) of columns of the table/view

   Home       Trees       Indices       Help   
pysql
Generated by Epydoc 3.0.1 on Sun Jun 13 18:35:51 2010 http://epydoc.sourceforge.net