Django raw sql query

Question

I have a this model:

class Document(models.Model): 
    data = models.TextField() 
    users = models.ManyToManyField(User)

How would you convert the following query for the model above to raw sql?

Document.objects.annotate(num_users=Count(users))

I need to switch this to raw sql because there is a bug in django when using MySql that makes annotate very slow.

But I'm not sure how to handle the many to many field in raw sql..

Document.objects.raw('SELECT ...')

kdt · Accepted Answer · 2012-02-26 15:08:23Z

2

The easiest way to translate your Django query to SQL is to simply look at the SQL that Django generates: How can I see the raw SQL queries Django is running?

answered Feb 26, 2012 at 15:08

kdt

28.6k34 gold badges97 silver badges143 bronze badges

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

1 Comment

marianobianchi Over a year ago

Be careful! Maybe the bug he is talking about is how django translate that query to mysql syntax (although i hardly believe this query is treated differently in different DBMSs like postgre or mysql). If @9-bits feels that the raw query continues working slowly, he should add here the raw sql that django throws...

Naveen Jain · Accepted Answer · 2019-10-04 22:25:09Z

0

you can get corresponding query the way mentioned below:

queryset = Document.objects.annotate(num_users=Count(users))  
sql_query = queryset.query
print(sql_query)

answered Oct 4, 2019 at 22:25

Naveen Jain

1,0827 silver badges26 bronze badges

Collectives™ on Stack Overflow

Django raw sql query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related