parseValue, parseMysqlURL

parsemysqlurl.py

from ast import literal_eval
import urlparse

def parseValue(value):
    try:
        return literal_eval(value)
    except:
        pass
    try:
        return literal_eval('"%s"' % value)
    except:
        pass
    return value


def parseMySQLUrl(url):
    url = urlparse.urlparse(url)
    database = url.path.strip('/')

    config = {
        'user': url.username,
        'passwd': url.password,
        'host': url.hostname or 'localhost',
        'port': url.port or 3306,
        'database': database,
        }

    query = urlparse.parse_qs(url.query)
    for name, value in query.iteritems():
        config[name] = parseValue(value[0])

    return config