How do I print the query that Python uses to call the database? [duplicate]

Question

How do I print to the terminal the query used by a specific line of python code? see below

notifications = user.get_notifications(max_id=max_id, types=types).order_by('-created')[:count]

Welcome back to Stack Overflow. As a refresher, please read How to Ask and note well that this is not a discussion forum. Please try to look for existing answers before asking - finding the linked duplicate was as easy as putting [django] print query into the site search - and please do not make "thanks" comments - instead, see the advice at stackoverflow.com/help/someone-answers. — Karl Knechtel
– Karl Knechtel, Commented Aug 27, 2022 at 11:36

nigel239 · Accepted Answer · 2022-08-27 11:31:49Z

2

You can print the query by adding:

.query

after your call.

It'll look like this:

user.get_notifications(max_id=max_id, types=types).order_by('-created')[:count].query

If you're doing this in the py manage.py shell, don't forget to print() it out. Otherwise it will show a memory address.

answered Aug 27, 2022 at 11:31

nigel239

1,9252 gold badges6 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1