Package logilab-common-0 :: Package 39 :: Package 0 :: Module db
[frames] | no frames]

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

Classes
  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)
Functions
 
set_prefered_driver(database, module, _drivers=PREFERED_DRIVERS)
sets the prefered driver module for database...
source code
 
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
Function Details

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