id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
243	lack of ordering the get_list() params	maurycy	Adrian Holovaty	"The next ticket with only IRC discussion. Feel free to post the comment, before closing, jackob. :-)

{{{
08:16 < maurycypw> btw. one question. do kwargs support ordering params? let's
                   say i'd like to write: SELECT * FROM table WHERE a = 'b' AND
                   = c = 'd' with the exactly the same order
08:16 < maurycypw> is it possible?
08:16 < rmunn> I don't think so. kwargs just shove everything into a standard
               dict.
08:17 < maurycypw> if i understand correctly, get_list() based on kwargs with
                   get_list(a__exact='b', c__default='d') would generate where
                   in the random manner
08:17 < rmunn> You could do tricks with naming your params like
               _01__a__exact='b', _02__c__exact='d', but that's hideous. :-)
08:17 < maurycypw> ugh
08:17 < rmunn> Right -- standard dicts make no guarantees about what order
               their keys will be in.
08:17 < maurycypw> it's quite ineffective, because sometimes the order of where
                   params could save the database time and short the query
                   execution time
08:18 -!- paolo [~wazzawazz@194-185-91-251.f5.ngi.it] has joined #django
08:18 < rmunn> People have written classes that inherit from dict and guarantee
               key order, but I don't know of any way to make Python's kwargs
               use anything but the standard dict class.
08:18 < maurycypw> in other hand, currently it's impossible to create efficient
                   complicated get_list() queries.
08:19 < maurycypw> what about you talking is a ugly hack, it should be bult-in
                   and supported by django by default
08:19 < rmunn> Perhaps you could add a keyword parameter
               clause_order=['a__exact', 'b__exact']
08:19 -!- rmunn [~rmunn@patk.mylinuxisp.com] has quit [Remote closed the
          connection]
08:20 < maurycypw> :)
08:20 < maurycypw> looks more reasonable. i'll fill the ticket.
}}}"	defect	closed	Metasystem		normal	invalid			Unreviewed	0	0	0	0	0	0