module Sequel::Plugins::OptimisticLocking

This plugin implements a simple database-independent locking mechanism to ensure that concurrent updates do not override changes. This is best implemented by a code example:

class Person < Sequel::Model
  plugin :optimistic_locking
end
p1 = Person[1]
p2 = Person[1]
p1.update(name: 'Jim') # works
p2.update(name: 'Bob') # raises Sequel::NoExistingObject

In order for this plugin to work, you need to make sure that the database table has a lock_version column that defaults to 0. To change the column used, provide a :lock_column option when loading the plugin:

plugin :optimistic_locking, lock_column: :version

By default, the plugin allows using the lock column setter method to either increase or decrease the lock column value. To prevent increases, which could potentially be used to skip an update when it update should be made, you can use the :prevent_increase plugin option:

plugin :optimistic_locking, prevent_increase: true

This plugin relies on the instance_filters plugin.

Methods

Public Class

1. apply
2. configure

Classes and Modules

1. Sequel::Plugins::OptimisticLocking::InstanceMethods