dbsource.py

python web programming 部分

#
# $Workfile: dbsource.py $ $Revision: 3 $
# $Date: 10/07/01 1:37p $ $Author: Sholden $
#
from Params import DBSOURCE
class dbsource:
    def __init__(self, source=DBSOURCE, type='mx'):
        self.source = source
        if type == 'mx':
            import MySQLdb as odbc
            self.conn = odbc.connect(db="test", user="sholden", passwd=".iwict0anp,")
        elif type == 'odbc':
            import dbi, odbc
            self.conn = odbc.odbc(source)
        elif type == 'gf':
            import gadfly
            self.conn = gadfly.gadfly(source, "gadfly")
        else:
            raise ValueError, "Illegal data source type %s" % type
        self.cursor = self.conn.cursor()

    def close(self):
        self.cursor.close()
        self.conn.close()