dbpar.py

isql for acess,sqlite , mysql etc

# sql examples default database parameter

# you can create a local_dbpar.py module with definitons
# of your own parameters to overrule these defaults

#DB_DRIVER = "sqlite3"
DB_DRIVER = "access"
#DB_DRIVER = "QMYSQL3"
# list of servers
DB_HOSTNAMES = ["localhost"]
# list of databases
DB_DATABASES = ["testdb"]
# database user id
DB_USERNAME = "postgres"
# database password
DB_PASSWORD = ""
##db=None
##if DB_DRIVER=="sqlite3":
##    from isql2 import Sisql
##    db=Sisql()
##elif DB_DRIVER=="access":
##    from isql2 import AcessIsql
##    db=AcessIsql()
def getdb(f):
    from os.path import splitext
    ext=splitext(f)[1]
    if ext==".db":
        from isql2 import Sisql
        db=Sisql()
        db.dbConnect(f)
    else:
        from isql2 import AcessIsql
        db=AcessIsql()
        db.dbConnect(f)
    return(db)