print raw sql for peewee

gistfile1.py

from peewee import *
from models import News, database

compiler = database.get_compiler()
print(News.select().where(News.url == 'test').sql(compiler))

In recent version of peewee:

compiler = database.compiler()

In the most recent version, no compiler param is needed. The result is a tuple though. Any way to get a SQL query with parameters filled in it?

Yeah I ran in to this same problem, is there any way to print the sql with the parameters filled in?

bump

Me too

👍

peewee2.10.2 can use SelectQuery.sql() to print the sql

This works:

query = News.select().where(News.url == 'test')
sql, param = query.sql()
print sql.replace("?","{}").format(*param)

As per peewee 3.13 you can print SQL queries by first getting the cursor, then calling the mogrify() method for your query.

query = <YOUR PEEWEE QUERY>

cur = database.cursor()
print(cur.mogrify(*query.sql()))

Where database is the Peewee Database object representing the connection to your database.