From 91065e84c43b89320a5c604af4484c28df065187 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 12 May 2006 17:11:46 +0000 Subject: [PATCH] added != support for None -> foo IS NOT NULL --- lib/sqlalchemy/sql.py | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/lib/sqlalchemy/sql.py b/lib/sqlalchemy/sql.py index 8c10a44d94..5edfe6f1fa 100644 --- a/lib/sqlalchemy/sql.py +++ b/lib/sqlalchemy/sql.py @@ -540,8 +540,12 @@ class CompareMixin(object): def _compare(self, operator, obj): if _is_literal(obj): if obj is None: - if operator != '=': - raise ArgumentError("Only '=' operator can be used with NULL") + if operator == '=': + return BooleanExpression(self._compare_self(), null(), 'IS') + elif operator == '!=': + return BooleanExpression(self._compare_self(), null(), 'IS NOT') + else: + raise exceptions.ArgumentError("Only '='/'!=' operators can be used with NULL") return BooleanExpression(self._compare_self(), null(), 'IS') else: obj = self._bind_param(obj) -- 2.47.2