diff options
Diffstat (limited to 'lib/sqlalchemy/sql/expression.py')
| -rw-r--r-- | lib/sqlalchemy/sql/expression.py | 7 |
1 files changed, 6 insertions, 1 deletions
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: |