import tg
import sqlalchemy.engine.url
import MySQLdb

def get_oid_connection(config=None):
    if config is None:
        config = tg.config
    backupuri = config.get('sqlalchemy.url')
    uri = config.get('openid.store', backupuri)
    u = sqlalchemy.engine.url.make_url(uri)
    pw = u.password or ''
    conn = MySQLdb.connect (host = u.host,
                            user = u.username,
                            passwd = pw,
                            db = u.database)
    return conn