Rails - Jan 2011 - acts_as_versioned + optimistic locking

Is it possible to use this plugin with version and lock_version
columns?

From my experimentation I can''t get it to work the way I''d
hoped.

I have the following User model.
--------------------
class CreateUsers < ActiveRecord::Migration
  def self.up
    create_table :users do |t|
      t.string :name
      t.string :email
      t.integer :lock_version, :default => 1
      t.integer :version, :default => 1

      t.timestamps
    end
  end

  def self.down
    drop_table :users
  end
end
--------------------
class User < ActiveRecord::Base
  acts_as_versioned
end
--------------------
class AddVersioning < ActiveRecord::Migration
  def self.up
    User.create_versioned_table
  end

  def self.down
    User.drop_versioned_table
  end
end


So I create a new user, and the version column is set to one in both
tables. I then edit the user and I would expect the version to be 2 in
the user table and 2 in the user_versions table, but it isn''t, its
still 1.

Using only a lock_version column doesn''t work either. It breaks as
soon as you revert_to! to a previous version and then edit the user
again. The lock_version column in the user_versions table doesn''t
increment correctly so you end up with a non-contiguous lock_version
column which means you can no longer revert to any version of a user
because it now has multiple records for the same version.

Any help or pointers are much apprecaited.

Many thanks

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.