This article is tagged with:
With_for_update sqlalchemy
and mysql
with_for_update sqlalchemy
SELECT users.id AS users_id FROM users FOR UPDATE OF users NOWAIT
with_for_update sqlalchemy
q = sess.query(User).populate_existing().with_for_update(nowait=True, of=User)