diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2009-11-11 03:46:45 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2009-11-11 03:46:45 +0000 |
| commit | 4f74e231ba7db4ad2cd6587bf2d1923d9eb7687b (patch) | |
| tree | 27a03d59c01a2372b3e4a2238e77082bba61586f | |
| parent | b0833b66a02a77a8b962f6b020243ae79dc2939b (diff) | |
| download | sqlalchemy-4f74e231ba7db4ad2cd6587bf2d1923d9eb7687b.tar.gz | |
merge r6497 of 0.5 branch
| -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_ |