From ca1ad4cbb9af8a45da550ba07c476f8cac17cd7a Mon Sep 17 00:00:00 2001
From: Ants Aasma <ants.aasma@gmail.com>
Date: Thu, 3 Apr 2008 16:54:26 +0000
Subject: [PATCH] A couple of usage examples for the case statement

---
 lib/sqlalchemy/sql/expression.py | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/lib/sqlalchemy/sql/expression.py b/lib/sqlalchemy/sql/expression.py
index 39a2ae3eb9..9272e6d82c 100644
--- a/lib/sqlalchemy/sql/expression.py
+++ b/lib/sqlalchemy/sql/expression.py
@@ -440,6 +440,15 @@ def case(whens, value=None, else_=None):
     or literal(<string>) constructs must be used to 
     interpret raw string values.
       
+    Usage examples::
+
+      case([(orderline.c.qty > 100, item.c.specialprice),
+            (orderline.c.qty > 10, item.c.bulkprice)
+          ], else_=item.c.regularprice)
+      case(value=emp.c.type, whens={
+              'engineer': emp.c.salary * 1.1,
+              'manager':  emp.c.salary * 3,
+          })
     """
     try:
         whens = util.dictlike_iteritems(whens)
-- 
2.47.3