Getting a raw SQL query from QuerySet

Question

I have simple model like this:

class Something(models.Model):
    data = models.CharField(max_length=200)

And when Im performing this:

Something.objects.all().query

I get this:

<django.db.models.sql.query.Query object at 0xa57b9ec>

What is it mean? Im using newest version of Django (1.5.2). In older versions .query was returned a string with the SQL query. How can I get it in new version?

what happens when you print your Query object? print(Something.objects.all().query), What version of django are you on? What environment are you inspecting .query? github.com/django/django/blob/master/django/db/models/sql/… — dm03514
– dm03514, Commented May 29, 2013 at 19:31
@Alp yep, str() is helped. Everything appeared out to be not so hard :) — Gill Bates
– Gill Bates, Commented May 29, 2013 at 19:40

Alp · Accepted Answer · 2013-05-29 19:53:15Z

5

As we found out in the comments, that's your answer:

str(Something.objects.all().query)

answered May 29, 2013 at 19:53

Alp

29.8k29 gold badges123 silver badges204 bronze badges

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

Collectives™ on Stack Overflow

Getting a raw SQL query from QuerySet

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related