diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-09-08 20:13:54 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-09-08 20:13:54 +0000 |
| commit | 5ba8a25afe9c4b84b74d5e51a641992b5d44097a (patch) | |
| tree | 4f40ef575384e5e7fa1fe905283f69b8e01728cc /test/sql/select.py | |
| parent | 0ebccb4abd0eb39e6d8ecc9a9445cfcba0e10f9a (diff) | |
| download | sqlalchemy-5ba8a25afe9c4b84b74d5e51a641992b5d44097a.tar.gz | |
added assertion case for [ticket:764]
Diffstat (limited to 'test/sql/select.py')
| -rw-r--r-- | test/sql/select.py | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/test/sql/select.py b/test/sql/select.py index f0af7e238..6a8131046 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -945,6 +945,9 @@ EXISTS (select yay from foo where boo = lar)", self.assert_compile(select([table1], table1.c.myid.in_('a')), "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.myid = :mytable_myid") + self.assert_compile(select([table1], ~table1.c.myid.in_('a')), + "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.myid != :mytable_myid") + self.assert_compile(select([table1], table1.c.myid.in_('a', 'b')), "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.myid IN (:mytable_myid, :mytable_myid_1)") |