Django Models Create a Coustom Query

Question

I am trying to get all the post in a thread before or on a certain time. So how do I get Django to allow me the privilege to enter my own queries?

This is the closest I could come using Django's model functions.

# need to get all the post from Thread post_set that were created before Thread post_set 9
posts = Thread.post_set.filter(created <= Thread.post_set.all()[9].created)

Stefano Sanfilippo · Answer 1 · 2013-05-11T00:12:47.070

2

If post_set is a foreign key, then use:

posts = Thread.objects.filter( post_set__created__lt=datetime.date(2013, 5, 10))

If you still want to go with a raw SQL query, as detailed here, please be careful, as no escaping is automatically performed.

edited May 11 '13 at 00:12

answered May 10 '13 at 23:58

Stefano Sanfilippo

30,653
7
76
79

score 2 · Accepted Answer · answered May 11 '13 at 00:01

2

You can use raw sql like so:

Thread.objects.raw('SELECT ... FROM myapp_thread WHERE ...')

answered May 11 '13 at 00:01

Ngenator

10,479
4
39
45

Thanks `raw` was what I was looking for. Also is there a way to look at the queries the filter uses? Or a site that translates what the filter does. i.e. `created_lt`, `id__exact` – Brandon Nadeau May 11 '13 at 00:08
Just `print post.query`, replace `post` with the name of your query object. – Stefano Sanfilippo May 11 '13 at 00:14
@Crispy See this answer for information on it: http://stackoverflow.com/a/1074224/1888559 – Ngenator May 11 '13 at 00:15

Django Models Create a Coustom Query

2 Answers2