lemon.db

Package lemon :: Package db

[show private | hide private]

Package lemon.db

DILL - Cross-database interface layer compatible with MySQL, ODBC, Gadfly.

For more information view the README.txt, USERGUIDE.txt, and DEVELOPERGUIDE.txt files in the module directory or visit http://lemon.xecos.com/docs/ for HTML versions of the same files.

Points to note:

Results aren't automatically committed.

You can alter the fetch and execute modes.

Seconds must be whole seconds.

Should be able to call the ColTypes table something else and block the use of the name ColTypes.

Important to commit() changes before and after creating/altering/dropping code.

Submodules

Submodules
`builder`: DBBuilder - Typed SQL Abstraction Layer. `drivers`: Drivers for the DB Builder module. `db` `date`: Date and time classes. `drivers`: Database drivers. `base`: Wraps DB-2.0 API cursors and extends functionality. `gc`: Lemon DB interface to the gadfly cursor. `mysql`: Lemon DB interface to the MySQLdb cursor. `odbc`: Lemon DB interface to the odbc cursor. `errors`

builder: DBBuilder - Typed SQL Abstraction Layer.
- drivers: Drivers for the DB Builder module.
  - db
date: Date and time classes.
drivers: Database drivers.
- base: Wraps DB-2.0 API cursors and extends functionality.
- gc: Lemon DB interface to the gadfly cursor.
- mysql: Lemon DB interface to the MySQLdb cursor.
- odbc: Lemon DB interface to the odbc cursor.
errors

Function Summary
	`connect(type, database, dir, startup, user, password, host, socket, port)` Connects to the appropriate database and returns a lemon.db cursor (which is derived from a normal cursor).

Variable Summary
`str`	`__author__` = `'James Gardner [email: james at xecos.com]'...`
`str`	`__credits__` = `'Guido van Rossum, for an excellent progra...`
`str`	`__date__` = `'02 July 2003'`
`str`	`__version__` = `'0.2'`
`int`	`MAXYEAR` = 9999
`int`	`MINYEAR` = 1

Function Details

connect(type, database, dir='', startup='', user='', password='', host='', socket='', port='')

Connects to the appropriate database and returns a lemon.db cursor (which is derived from a normal cursor). Options available are: type, syntax, user, password, protocol, host, socket, port, database

Specifying no options or setting defaults=True loads the default settings.

Variable Details

author

Type:: str
Value:: 'James Gardner [email: james at xecos.com]'

credits

Type:: str
Value:: 'Guido van Rossum, for an excellent programming language.'

date

Type:: str
Value:: '02 July 2003'

version

Type:: str
Value:: '0.2'

MAXYEAR

Type:: int
Value:: 9999

MINYEAR

Type:: int
Value:: 1

Generated by Epydoc 2.0 on Mon Nov 10 15:07:41 2003

http://epydoc.sf.net

Package lemon.db

connect(type, database, dir='', startup='', user='', password='', host='', socket='', port='')

__author__

__credits__