Take a look at the aggregation docs at http://django.me/aggregation for sum, group by, etc.
Cheers, AT On Tue, Sep 13, 2011 at 7:44 PM, Robert <rclonin...@gmail.com> wrote: > > I apologize for using AT rather than your name, Andre. > > On Sep 13, 6:42 pm, Robert <rclonin...@gmail.com> wrote: > > Thanks, AT. Actually this is the article where I learned how to do > > raw SQL in Django. It made life easy for complex queries. > > Unfortunately it does not specify how to dynamically set the database > > for the RawQuerySet. I am hoping there is an easy way to do it so I > > can avoid a complete rewrite. The alternative is to figure out how to > > do what I think are complex queries (includes subqueries, group by, > > having, sum commands) using the ORM QuerySet. > > > > On Sep 13, 5:01 pm, Andre Terra <andrete...@gmail.com> wrote: > > > > > > > > > Not exactly what you want, buthttps:// > docs.djangoproject.com/en/dev/topics/db/sql/#executing-custom... > > > > > Cheers, > > > AT > > > > > On Tue, Sep 13, 2011 at 5:51 PM, Robert <rclonin...@gmail.com> wrote: > > > > > > I have inherited the support of a Django application and am new to > the > > > > language so I would appreciate some advice. The application requires > > > > getting data from different databases depending on the client. > > > > > > The existing code uses the syntax: <model > > > > table>.objects.using(self.CLIENT_DB).get to connect to the correct > > > > databse. > > > > > > However, I have some queries that are so complex I have had to use > the > > > > rawqueryset with SQL commands such as "for record in <model > > > > table>.objects.raw(<my sql command>) . . .". Apparently "using" is > > > > not an available attribute of the rawqueryset. What is the best way > > > > to dynamically change databases when using a rawqueryset? > > > > > > Thanks for your guidance. > > > > > > -- > > > > 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 > > > > django-users+unsubscr...@googlegroups.com. > > > > For more options, visit this group at > > > >http://groups.google.com/group/django-users?hl=en.-Hide quoted text - > > > > > - Show quoted text -- Hide quoted text - > > > > - Show quoted text - > > -- > 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 > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > > -- 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 django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
