From f48efe8948da795a0e4a9ef630696e5ce4c97c1e Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 11 Nov 2009 03:45:55 +0000 Subject: [PATCH] document NOT IN, IN with query as subq --- doc/build/ormtutorial.rst | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/doc/build/ormtutorial.rst b/doc/build/ormtutorial.rst index c10d457f14..e1d833cb82 100644 --- a/doc/build/ormtutorial.rst +++ b/doc/build/ormtutorial.rst @@ -447,10 +447,22 @@ Here's a rundown of some of the most common operators used in ``filter()``: query.filter(User.name.in_(['ed', 'wendy', 'jack'])) + # works with query objects too: + + query.filter(User.name.in_(session.query(User.name).filter(User.name.like('%ed%')))) + +* NOT IN:: + + query.filter(~User.name.in_(['ed', 'wendy', 'jack'])) + * IS NULL:: filter(User.name == None) +* IS NOT NULL:: + + filter(User.name != None) + * AND:: from sqlalchemy import and_ -- 2.47.3