- Added support for literal rendering of boolean values, e.g.

"true" / "false" or "1" / "0".
- added Boolean tests to the test suite

1 files changed, 9 insertions, 0 deletions

diff --git a/lib/sqlalchemy/sql/sqltypes.py b/lib/sqlalchemy/sql/sqltypes.py
index ec1d66459..f3468ebc2 100644
--- a/lib/sqlalchemy/sql/sqltypes.py
+++ b/lib/sqlalchemy/sql/sqltypes.py
@@ -1274,6 +1274,15 @@ class Boolean(TypeEngine, SchemaType):
     def python_type(self):
         return bool
 
+    def literal_processor(self, dialect):
+        if dialect.supports_native_boolean:
+            def process(value):
+                return "true" if value else "false"
+        else:
+            def process(value):
+                return str(1 if value else 0)
+        return process
+
     def bind_processor(self, dialect):
         if dialect.supports_native_boolean:
             return None