Rails 3表锁

Question

是否有可能锁定数据库表。MySQL示例：

用户写入的锁表

..using一些本地的ActiveRecord方法？

Answer 1

ActiveRecord不支持这一点，您必须用以下方法手动运行：

ActiveRecord::Base.connection.execute("LOCK TABLE users WRITE")

您可能需要查看此在ruby-forum.com上讨论以获得更多信息。

Answer 2

Pass :lock => true to ActiveRecord::Base.find to obtain an exclusive lock on the selected rows

Pass :lock => 'some locking clause' to give a database-specific locking clause of your own such as ‘LOCK IN SHARE MODE’ or ‘FOR UPDATE NOWAIT

详见：http://api.rubyonrails.org/classes/ActiveRecord/Locking/Pessimistic.html