Replace/delete field using sqlalchemy

Ad1. You need something like this:

session.query(Foo).filter_by(color = 'green').update({ 'color': 'red' })session.commit()

Ad2. Similarly:

session.query(Foo).filter_by(color = 'green').delete()session.commit()

You can find the querying documentation here and here.

CodeHunter