diff options
| author | Ants Aasma <ants.aasma@gmail.com> | 2008-04-03 14:08:22 +0000 |
|---|---|---|
| committer | Ants Aasma <ants.aasma@gmail.com> | 2008-04-03 14:08:22 +0000 |
| commit | 921efb250c284ee121e9fc9d0f12eb2612047645 (patch) | |
| tree | 2d578af6447a11eec9008f8540eb63b6d2eb5616 /lib/sqlalchemy/sql/expression.py | |
| parent | f899d7900509cbfdffdf8c48a93e908ed2249b77 (diff) | |
| download | sqlalchemy-921efb250c284ee121e9fc9d0f12eb2612047645.tar.gz | |
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.
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: |