def test_select_exists_false(self, connection):
stuff = self.tables.stuff
eq_(
connection.execute(
select([stuff.c.id]).where(exists().where(stuff.c.data == "no data"))
).fetchall(),
[],
)
def test_select_exists(self, connection):
stuff = self.tables.stuff
eq_(
connection.execute(
select([stuff.c.id]).where(
and_(stuff.c.id == 1, exists().where(stuff.c.data == "some data"),)
)
).fetchall(),
[(1,)],
)