diff options
| -rw-r--r-- | doc/build/ormtutorial.rst | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/build/ormtutorial.rst b/doc/build/ormtutorial.rst index 855f95140..b1f647e51 100644 --- a/doc/build/ormtutorial.rst +++ b/doc/build/ormtutorial.rst @@ -449,10 +449,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_ |