convert paramstyle format for MySQL to SQLite...

gistfile1.py

# -*- coding: utf-8 -*-
import re

PYFORMAT_REGEX = re.compile(r'%\((.*?)\)s')


def paramstyle_to_format(sql, params):
    u""" paramstyle: pyformat -> format
    """
    param_keys = PYFORMAT_REGEX.findall(sql)
    sql = PYFORMAT_REGEX.sub('%s', sql)
    new_params = [v for k, v in params.items() if k in param_keys]
    return sql, new_params