summaryrefslogtreecommitdiff
path: root/test
diff options
context:
space:
mode:
Diffstat (limited to 'test')
-rw-r--r--test/orm/test_query.py15
1 files changed, 15 insertions, 0 deletions
diff --git a/test/orm/test_query.py b/test/orm/test_query.py
index ac9c95f41..3882ec4b5 100644
--- a/test/orm/test_query.py
+++ b/test/orm/test_query.py
@@ -1620,6 +1620,21 @@ class AggregateTest(QueryTest):
assert [User(name=u'jack',id=7), User(name=u'fred',id=9)] == sess.query(User).order_by(User.id).group_by(User).join('addresses').having(func.count(Address.id)< 2).all()
+
+class ExistsTest(QueryTest, AssertsCompiledSQL):
+
+ def test_exists(self):
+ User = self.classes.User
+ sess = create_session()
+ q1 = sess.query(User).filter(User.name == 'fred')
+ self.assert_compile(sess.query(q1.exists()),
+ 'SELECT EXISTS ('
+ 'SELECT 1 FROM users WHERE users.name = :name_1'
+ ') AS anon_1',
+ dialect=default.DefaultDialect()
+ )
+
+
class CountTest(QueryTest):
def test_basic(self):
users, User = self.tables.users, self.classes.User