Thanks, actually i have been baulking a little cos i have not yet studied writing custom sql in django. I'll get on with it and check on you with more specific issues as they appear.
On Nov 26, 12:13 pm, jj <[EMAIL PROTECTED]> wrote: > I solved a similar issue using custom SQL. It's a little tedious to > write, but the boost is significant. > > The way I've structured this: > 1. create a manager for the main class > 2. for each related object (either foreignKey or many2many), create a > method fieldname_in_bulk() > 3. create a method select_related_ex(), which uses the results of 2. > > More concretely: > 2. fetches all related objects (irrespective of the object(s) to which > it is attached) > 3. associates objects and their related objects > > If your DB and model won't change too often, you can write pretty > clear and concise SQL/SQL processing code. > > JJ. > > On Nov 26, 11:56 am, lispingng <[EMAIL PROTECTED]> wrote: > > > Hi, > > I am working on a large project that requires i export applications to > > csv. > > the problem is the Application model has about six foreignkey fields > > including one to the Profiles model. also there are two backward > > relations to the Application models as well > > in other words the model structure is a little complex. > > now i want to export the data (its a school management app) with their > > relationships > > > class Application(models.Model): > > profile = models.ForeignKey(Profiles, editable=False) > > ... > > ... > > class School(models.Model): > > '''the schools attended by the applicant''' > > application = models.ForeignKey(Application) > > > class WorkExperience(models.Model): > > '''the jobs doen by the applicant''' > > application = models.ForeignKey(Application) > > > and so on. > > right now i am looking for an alternative to picking each Aplication > > object, one by one, and using select_related() to get related data > > also thought about using custom sql but am not sure it is the right > > thing to do...(maybe i'm just being lazy) > > Any thoughts on how i can get around this? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---