Skip to content

Instantly share code, notes, and snippets.

@ProGM
Forked from coorasse/main.rb
Last active June 19, 2017 10:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ProGM/869356d5e17ad5fb0a1b0564a6e56181 to your computer and use it in GitHub Desktop.
Save ProGM/869356d5e17ad5fb0a1b0564a6e56181 to your computer and use it in GitHub Desktop.
CanCanCan Issue when compiling SQL using `accessible_by`
begin
require 'bundler/inline'
rescue LoadError => e
$stderr.puts 'Bundler version 1.10 or later is required. Please update your Bundler'
raise e
end
gemfile(true) do
source 'https://rubygems.org'
gem 'rails', '5.1.1' # use correct rails version
gem 'arel', '8.0.0'
gem 'cancancan' # use correct cancancan version
gem 'sqlite3' # use another DB if necessary
end
require 'active_record'
require 'cancancan'
require 'cancan/model_adapters/active_record_adapter'
require 'cancan/model_adapters/active_record_4_adapter'
require 'minitest/autorun'
require 'logger'
# This connection will do for database-independent bug reports.
ActiveRecord::Base.establish_connection(adapter: 'sqlite3', database: ':memory:')
ActiveRecord::Base.logger = Logger.new(STDOUT)
# create your tables here
ActiveRecord::Schema.define do
create_table :books, force: true do |t|
t.integer :user_id
t.integer :visibility
t.integer :status
end
create_table :users, force: true do |t|
t.string :name
end
end
class Book < ActiveRecord::Base
belongs_to :user
end
class User < ActiveRecord::Base
has_many :books
end
class Ability
include CanCan::Ability
def initialize(user)
can :read, Book, visibility: 0
if user.present?
can :create, Book
can :manage, Book, user: user, status: 0
end
end
end
class BugTest < Minitest::Test
def test_bug
user1 = User.create!
user2 = User.create!
books = Book.create([{user: user1, status: 0, visibility: 1},{user: user2}])
ability = Ability.new(user1)
books = Book.accessible_by(ability, :read).to_a
assert_equal [user1], books
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment