Hey Tim, Tim Chase wrote: > For reporting purposes, we're hoping to summarize a variety of > fields across volumes of data. I know recordsets currently have > a count() method that returns the number of rows. However, I'm > trying to find a good way of obtaining max/min/sum/avg results > for all the items in the recordset. I can hand-roll the SQL as > necessary, but would prefer to be able to reuse the queries I've > already built up in standard Django-ese if possible.
I've had success 'hand-rolling' complex SQl into a VIEW (let's assume your DB has views). To Django your views look and behave like any other table (for reading data and possibly for writing data (depending on your view)). Create a Django model that uses the view like they normally use a table. You can then create Django model objects that return the results of your view, including Django's yummie filter stuff. I've found there is a threshold at which hand-rolling complex SQL is easier on my brain than trying to bend Django's ORM to my will. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
