Package logilab-common-0 ::
Package 36 ::
Package 1 ::
Module db
|
|
Module db
source code
Wrappers to get actually replaceable DBAPI2 compliant modules and
database connection whatever the database and client lib used.
Currently support:
- postgresql (pgdb, psycopg, psycopg2, pyPgSQL)
- mysql (MySQLdb)
- sqlite (pysqlite2, sqlite, sqlite3)
just use the `get_connection` function from this module to get a
wrapped connection. If multiple drivers for a database are available,
you can control which one you want to use using the
`set_prefered_driver` function.
Additional helpers are also provided for advanced functionalities such
as listing existing users or databases, creating database... Get the
helper for your database using the `get_adv_func_helper` function.
:copyright: 2002-2008 LOGILAB S.A. (Paris, FRANCE), all rights reserved.
:contact: http://www.logilab.fr/ -- mailto:contact@logilab.fr
:license: General Public License version 2 - http://www.gnu.org/licenses
|
UnknownDriver
raised when a unknown driver is given to get connexion
|
|
NoAdapterFound
Raised when no Adpater to DBAPI was found
|
|
PyConnection
A simple connection wrapper in python, generating wrapper for cursors as...
|
|
PyCursor
A simple cursor wrapper in python (useful for profiling)
|
|
|
|
get_dbapi_compliant_module(driver,
prefered_drivers=None,
quiet=False,
pywrap=False)
returns a fully dbapi compliant module |
source code
|
|
|
get_connection(driver='postgres',
host='',
database='',
user='',
password='',
port='',
quiet=False,
drivers=PREFERED_DRIVERS,
pywrap=False)
return a db connexion according to given arguments |
source code
|
|
set_prefered_driver(database,
module,
_drivers=PREFERED_DRIVERS)
| source code
|
sets the prefered driver module for database
database is the name of the db engine (postgresql, mysql...)
module is the name of the module providing the connect function
syntax is (params_func, post_process_func_or_None)
_drivers is a optionnal dictionnary of drivers
|