django-devserver icon indicating copy to clipboard operation
django-devserver copied to clipboard

DatabaseStatTracker - ValueError: None is not in list

Open airamjimenez opened this issue 11 years ago • 0 comments

A exception is thrown (ValueError: None is not in list) if you have a text param that contains a sql keyword, module/sql line 76: message = sqlparse.format(message, reindent=True, keyword_case='upper')

because the formatted_sql doesn't quote text param and sqlparse assumed that is a keyword not a regular text

i.e.: sql = """INSERT INTO example ("name", "address") VALUES (%s, %s)""" params = ("where", "other") formatted_sql = sql % (params if isinstance(params, dict) else tuple(params)) message = sqlparse.format(message, reindent=True, keyword_case='upper')

airamjimenez avatar Jul 07 '14 22:07 airamjimenez