Function query_to_sql

selenium/shannon_spider/db.py:93–98

(query)

def query_to_sql(query):
    if not isinstance(query, Query):
        raise ValueError('query: %s, must be instance of %s' % (type(query).__name__, scrapy.Request.__name__))
    dialect = query.session.get_bind().dialect
    compiled = query.statement.compile(dialect=dialect, compile_kwargs={'literal_binds': True})
    return sqlparse.format(str(compiled), reindent=True, keyword_case='upper')