From 423cd7fbf695d2becdfc83751a8dbc0650854bea Mon Sep 17 00:00:00 2001 From: Diana Clarke Date: Fri, 29 Mar 2013 14:58:33 -0400 Subject: adding convenience method exists() to Query (see # 2673) --- test/orm/test_query.py | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'test') 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 -- cgit v1.2.1