Re: Raw SQL and model instances

2008-11-28 Thread [EMAIL PROTECTED]
Malcolm, I believe that should be params = dict(zip(fields, row)) On Nov 28, 8:34 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Fri, 2008-11-28 at 19:54 +0900, Russell Keith-Magee wrote: > > [...] > > > >>> cursor.execute('SELECT ...') > > >>> row = cursor.fetchone() > > >>> a = Author(*

Re: Raw SQL and model instances

2008-11-28 Thread Malcolm Tredinnick
On Fri, 2008-11-28 at 19:54 +0900, Russell Keith-Magee wrote: [...] > >>> cursor.execute('SELECT ...') > >>> row = cursor.fetchone() > >>> a = Author(*row) > > At this point, a will be a fully populated Author instance, > indistinguishable from one retrieved using a queryset. > > The caveat on

Re: Raw SQL and model instances

2008-11-28 Thread Georg Göttlich
Hello Russ, thank you very much. This is exactly what I wanted to know. Best regards, Georg Göttlich --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-

Re: Raw SQL and model instances

2008-11-28 Thread Russell Keith-Magee
On Fri, Nov 28, 2008 at 6:42 PM, Georg Göttlich <[EMAIL PROTECTED]> wrote: > > Hello everybody, > > this question has probably been ask quite often already, but I > couldn't find anything proper on it. So here it is: > > Is there a way to feed the result cursor of a custom sql query back > into th

Re: Raw SQL and model instances

2008-11-28 Thread Daniel Roseman
On Nov 28, 9:42 am, Georg Göttlich <[EMAIL PROTECTED]> wrote: > Hello everybody, > > this question has probably been ask quite often already, but I > couldn't find anything proper on it. So here it is: > > Is there a way to feed the result cursor of a custom sql query back > into the ORM, thus rec

Raw SQL and model instances

2008-11-28 Thread Georg Göttlich
Hello everybody, this question has probably been ask quite often already, but I couldn't find anything proper on it. So here it is: Is there a way to feed the result cursor of a custom sql query back into the ORM, thus recieving model instances, as if you'd use a queryset? Thanks a lot, Georg G