Locks

Model lock
You can use lock using with_lock method on query collection:
1
Clear::SQL.transaction do
2
    # SELECT * FROM users WHERE organization = 'Crystal Lang' FOR UPDATE
3
    User.where(organization: "Crystal Lang").with_lock.each do |user|
4
        # Do something with your users
5
    end
6
end
Copied!
with_lock offers optional parameters (default: "FOR UPDATE"), to setup the lock options you want (ex: with_lock("FOR UPDATE SKIP LOCKED"))
See PostgreSQL deep explanation about locking here.
Lock work only inside transaction. Without transaction block, the call might fail.
​

Connection pool

Next - Querying

The collection object

Last modified 2yr ago

Copy link