From 921efb250c284ee121e9fc9d0f12eb2612047645 Mon Sep 17 00:00:00 2001 From: Ants Aasma Date: Thu, 3 Apr 2008 14:08:22 +0000 Subject: The case() function now also takes a dictionary as its whens parameter. But beware that it doesn't escape literals, use the literal construct for that. --- lib/sqlalchemy/sql/expression.py | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy/sql') diff --git a/lib/sqlalchemy/sql/expression.py b/lib/sqlalchemy/sql/expression.py index c487ee173..cc97227a7 100644 --- a/lib/sqlalchemy/sql/expression.py +++ b/lib/sqlalchemy/sql/expression.py @@ -416,7 +416,7 @@ def case(whens, value=None, else_=None): """Produce a ``CASE`` statement. whens - A sequence of pairs to be translated into "when / then" clauses. + A sequence of pairs or a dict to be translated into "when / then" clauses. value Optional for simple case statements. @@ -425,6 +425,11 @@ def case(whens, value=None, else_=None): Optional as well, for case defaults. """ + try: + whens = util.dictlike_iteritems(whens) + except TypeError: + pass + whenlist = [ClauseList('WHEN', c, 'THEN', r, operator=None) for (c,r) in whens] if not else_ is None: -- cgit v1.2.1