On Fri, 2009-04-10 at 10:24 -0700, MS wrote: > Hi Malcolm! > > > > then is there any good (built-in) way > > > to write custom SQL queries wich would return dicts instead of tuples? > > > > You know the order the values will be returned in and you know the names > > of the columns. So you can create an iterator that returns the > > dictionary results: > > > > def dict_iterator(cursor, col_names): > > for row in cursor.fetchall(): > > yield dict(zip(col_names, row)) > > > > > Yes, of course I can write it. But isn't a framework supposed to > relieve us from such a boilerplate code? > Especially that it was in the framework already. Strange...
It was removed because it wasn't particularly useful and added quite a bit of usage and implementation overhead. Django is not, and never has been intended to be, a complete replacement for everything. Using dictfetchall() requires some overhead to retrieve the column names and ordering each time from the database and so on. Since you already have the column names, if you want to create a dictionary, it's actually faster in almost all cases (except for database wrappers that for some reason *always* retrieve the column names) to simply incorporate the above two line function. In a way, Django is doing you a favour here: less maintenance for everybody, meaning we can focus on the important stuff, and a faster path to your goal if you need. If there's some truly compelling use-case that requires something like dictfetchall() (and "I want it" isn't a compelling use-case, since the above solution is of equivalent difficulty and has the advantages I've mentioned), then explain it on django-dev and we would consider it. But we don't add things just because somebody, somewhere might want it some day. It has to be something that isn't otherwise easily possible. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
