Home | Trees | Index | Help |
|
---|
Package pydo :: Module dbi :: Class DBIBase |
|
object
--+
|
DBIBase
MssqlDBI
,
MysqlDBI
,
OracleDBI
,
PsycopgDBI
,
SqliteDBI
Method Summary | |
---|---|
constructor. | |
_connect(self)
| |
internal function that turns a result set into a list of dictionaries. (Static method) | |
_initExceptions(self)
| |
commits a transaction | |
returns a database cursor for direct access to the db connection | |
for the given table, returns a 2-tuple: a dict of Field objects keyed by name, and list of multi-column unique constraints (sets of Fields)). | |
disassociate from the current connection, which may be deleted or returned to a pool. | |
Executes the statement with the values and does conversion of the return result as necessary. | |
If db uses auto increment, should obtain the value of the auto-incremented field named 'name' | |
returns a converter instance. | |
If db has sequences, this should return the next value of the sequence named 'name' | |
list the tables in the database schema | |
orderByString(order,
limit,
offset)
(Static method) | |
rolls back a transaction | |
switch the connection in use for the current thread with another one. | |
Inherited from object | |
x.__delattr__('name') <==> del x.name | |
x.__getattribute__('name') <==> x.name | |
x.__hash__() <==> hash(x) | |
T.__new__(S, ...) -> a new object with type S, a subtype of T | |
helper for pickle | |
helper for pickle | |
x.__repr__() <==> repr(x) | |
x.__setattr__('name', value) <==> x.name = value | |
x.__str__() <==> str(x) |
Property Summary | |
---|---|
conn : the underlying db connection |
Class Variable Summary | |
---|---|
bool |
auto_increment = False
|
bool |
has_sane_rowcount = True
|
str |
paramstyle = 'format'
|
Instance Method Details |
---|
__init__(self,
connectArgs,
connectFunc,
dbapiModule,
pool=None,
verbose=False,
initFunc=None)
|
commit(self)commits a transaction |
cursor(self)returns a database cursor for direct access to the db connection |
describeTable(self, table, schema=None)for the given table, returns a 2-tuple: a dict of Field objects keyed by name, and list of multi-column unique constraints (sets of Fields)). The Field instances should contain information about whether they are unique or sequenced. |
endConnection(self)disassociate from the current connection, which may be deleted or returned to a pool. |
execute(self, sql, values=(), qualified=False)Executes the statement with the values and does conversion of the return result as necessary. result is list of dictionaries, or number of rows affected |
getAutoIncrement(self, name)If db uses auto increment, should obtain the value of the auto-incremented field named 'name' |
getConverter(self)returns a converter instance. |
getSequence(self, name, field, table)If db has sequences, this should return the next value of the sequence named 'name' |
listTables(self, schema=None)list the tables in the database schema |
rollback(self)rolls back a transaction |
swapConnection(self, connection)switch the connection in use for the current thread with another one. |
Static Method Details |
---|
_convertResultSet(description, resultset, qualified=False)internal function that turns a result set into a list of dictionaries. |
Property Details |
---|
connthe underlying db connection
|
Class Variable Details |
---|
auto_increment
|
has_sane_rowcount
|
paramstyle
|
Home | Trees | Index | Help |
|
---|
Generated by Epydoc 2.1 on Thu Nov 17 15:02:47 2005 | http://epydoc.sf.net |