Friday, December 26, 2014

Re: Database queries location


That should all be possible.

from django.db import models

class MyManager(models.Manager):
def complex_query_with_multiple_tables(self, mutiple, post, values):
# put your query here.


On Tuesday, December 23, 2014 12:49:49 PM UTC-6, pythonista wrote:
Can this be used with a complex query in which multiple tables (classes) are being joined? 

I also have to pass multiple post values to the query.

Thanks for the example

On Monday, December 22, 2014 8:52:04 PM UTC-5, Collin Anderson wrote:

There's a good example of creating a custom manager here:


On Saturday, December 20, 2014 8:28:57 AM UTC-6, pythonista wrote:
Thank you for your response.  

Most of my data is complex raw sql.
I had placed it in the views and it is working as expected

I would like to migrate the raw sql to managers, 
Can you point me to one or more good examples of how the manager is coded and how the sql interacts with the views.


On Friday, December 19, 2014 7:06:54 AM UTC-5, aRkadeFR wrote:
Depend exactly on what to compute for your post data.

I would almost write no logic code in the views.

I split every application as follow:
- All the logic as a table level (raw SQL, complex queries)
- All logic as a row level / object level (python computing data)
- All logic as forms data / processing / validation for
request data

Have a good one,


On 12/18/2014 10:12 PM, pythonista wrote:
> I understand that functions can be placed in the models fille
> However if I have complex queries that receive post input does the
> Query live in the model  the views or an external module

You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To post to this group, send email to
Visit this group at
To view this discussion on the web visit
For more options, visit

No comments:

Post a Comment