Module database

source code

AIS database utilities.

Author: Kurt Schwehr

Version: 8175

Copyright: 2008

Status: under development

Since: 2008 Jan 09

License: GPL v2

To Do:

Date: 2008-01-09

Functions

stdCmdlineOptions(parser, dbType='postgres', verbose=False)
Standard command line options source code

createTables(cx, dbType='sqlite', includeList=None, excludeList=None, verbose=False) source code

dropTables(cx, dbType='sqlite', includeList=None, excludeList=None, verbose=False)
Kiss your data goodbye source code

connect(options, dbType=None)
options must include the above standard options

source code

Variables

dbTypes = ('postgres', 'sqlite')
The choices of databases that are supported.

Function Details

Standard command line options

Parameters:

Parameters:

cx (db API 2.0 object) - database connection
dbType (str) - postgres or sqlite
includeList (list of integers) - If a list of message numbers is passed, only these are created
excludeList (list of integers) - If a list of message numbers is passed, all but these are created

Kiss your data goodbye

Parameters:

cx (db API 2.0 object) - database connection
dbType (str) - postgres or sqlite
includeList (list of integers) - If a list of message numbers is passed, only these are created
excludeList (list of integers) - If a list of message numbers is passed, all but these are created