def test_delete_with_bindparams(self):
        User = self.classes.User

        sess = Session()

        john, jack, jill, jane = sess.query(User).order_by(User.id).all()
        sess.query(User).filter(text('name = :name')).params(
            name='john').delete('fetch')
        assert john not in sess

        eq_(sess.query(User).order_by(User.id).all(), [jack, jill, jane])
dataset/ETHPy150Open zzzeek/sqlalchemy/test/orm/test_update_delete.py/UpdateDeleteTest.test_delete_with_bindparams/original