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))

👍

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.