Contents

class CreateRbac < ActiveRecord::Migration
  def self.up
    create_table :role_assignments do |t| 
      t.column :role_id, :integer
      t.column :user_id, :integer
    end

    create_table :roles do |t| 
      t.column :name, :string
      t.column :description, :string
    end 

    create_table :permission_groups do |t|
      t.column :right_id, :integer
      t.column :role_id, :integer
    end 

    create_table :rights do |t| 
      t.column :name, :string
      t.column :controller_name, :string
      t.column :actions, :string
    end
  end

  def self.down
    drop_table :role_assignments
    drop_table :roles
    drop_table :permission_groups
    drop_table :rights
  end
end

class Right < ActiveRecord::Base
  has_many :permission_groups, :dependent => :destroy
  has_many :roles, :through => :permission_groups
end

class Role < ActiveRecord::Base
  has_many :permission_groups, :dependent => :destroy
  has_many :rights, :through => :permission_groups
  has_many :role_assignments, :dependent => :destroy
end

class PermissionGroup < ActiveRecord::Base
  belongs_to :right
  belongs_to :role
end

class RoleAssignment < ActiveRecord::Base
  belongs_to :user
  belongs_to :role
end

module HasManyThroughMethods
  def setup
    CreateRbac.up
  end

  def teardown
    CreateRbac.down
  end

  def test_has_many_through
    role_rights   = Right.create( {:name => "Administrator - Full Access To Roles", :actions => "*", :controller_name => "Admin::RolesController"} )
    right_rights  = Right.create( {:name => "Administrator - Full Access To Rights", :actions => "*", :controller_name => "Admin::RightsController"} )

    admin_role    = Role.create( {:name => "Administrator", :description => "System defined super user - access to right and role management."} )
    admin_role.rights << role_rights
    admin_role.rights << right_rights
    admin_role.save
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
activerecord-jdbc-adapter-0.9.0.1	test/has_many_through.rb
activerecord-jdbc-adapter-0.8	test/has_many_through.rb
activerecord-jdbc-adapter-0.7.1	test/has_many_through.rb
activerecord-jdbc-adapter-0.8.1	test/has_many_through.rb
activerecord-jdbc-adapter-0.7.2	test/has_many_through.rb
activerecord-jdbc-adapter-0.9	test/has_many_through.rb
activerecord-jdbc-adapter-0.7	test/has_many_through.rb
activerecord-jdbc-adapter-0.8.2	test/has_many_through.rb