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 - -- 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.
