Package gavo :: Package base :: Module sqlsupport :: Class AdhocQuerier
[frames] | no frames]

Class AdhocQuerier

source code

        object --+        
                 |        
PostgresQueryMixin --+    
                     |    
        object --+   |    
                 |   |    
StandardQueryMixin --+    
                     |    
          QuerierMixin --+
                         |
                        AdhocQuerier

A simple interface to querying the database through pooled connections.

These are constructed using the connection getters (getTableConn (default), getAdminConn) and then serve as context managers, handing back the connection as you exit the controlled block.

Since they operate through pooled connections, no transaction management takes place. These are typically for read-only things.

You can use the query method and everything that's in the QuerierMixin.

Instance Methods
 
__init__(self, connectionManager=None)
x.__init__(...) initializes x; see help(type(x)) for signature
source code
 
__enter__(self) source code
 
__exit__(self, *args) source code

Inherited from QuerierMixin: abort, configureConnection, enableAutocommit, finish, query, queryDicts, queryToDicts

Inherited from PostgresQueryMixin: dropTable, foreignKeyExists, getACLFromRes, getColumnsFromDB, getForeignKeyName, getOIDForTable, getPrimaryIndexName, getRowEstimate, getSchemaPrivileges, getServerVersion, getTablePrivileges, getTableType, hasIndex, parsePGACL, roleExists, schemaExists

Inherited from StandardQueryMixin: getTimeout, setSchemaPrivileges, setTablePrivileges, setTimeout

Inherited from object: __delattr__, __format__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __sizeof__, __str__, __subclasshook__

Class Variables

Inherited from QuerierMixin: defaultProfile

Properties

Inherited from object: __class__

Method Details

__init__(self, connectionManager=None)
(Constructor)

source code 

x.__init__(...) initializes x; see help(type(x)) for signature

Overrides: object.__init__
(inherited documentation)