require "cases/helper" require 'models/post' require 'models/author' require 'models/developer' require 'models/project' require 'models/comment' require 'models/category' require 'models/person' require 'models/reference' class RelationScopingTest < ActiveRecord::TestCase fixtures :authors, :developers, :projects, :comments, :posts, :developers_projects def test_reverse_order assert_equal Developer.order("id DESC").to_a.reverse, Developer.order("id DESC").reverse_order end def test_reverse_order_with_arel_node assert_equal Developer.order("id DESC").to_a.reverse, Developer.order(Developer.arel_table[:id].desc).reverse_order end def test_reverse_order_with_multiple_arel_nodes assert_equal Developer.order("id DESC").order("name DESC").to_a.reverse, Developer.order(Developer.arel_table[:id].desc).order(Developer.arel_table[:name].desc).reverse_order end def test_reverse_order_with_arel_nodes_and_strings assert_equal Developer.order("id DESC").order("name DESC").to_a.reverse, Developer.order("id DESC").order(Developer.arel_table[:name].desc).reverse_order end def test_double_reverse_order_produces_original_order assert_equal Developer.order("name DESC"), Developer.order("name DESC").reverse_order.reverse_order end def test_scoped_find Developer.where("name = 'David'").scoping do assert_nothing_raised { Developer.find(1) } end end def test_scoped_find_first developer = Developer.find(10) Developer.where("salary = 100000").scoping do assert_equal developer, Developer.order("name").first end end def test_scoped_find_last highest_salary = Developer.order("salary DESC").first Developer.order("salary").scoping do assert_equal highest_salary, Developer.last end end def test_scoped_find_last_preserves_scope lowest_salary = Developer.first :order => "salary ASC" highest_salary = Developer.first :order => "salary DESC" Developer.order("salary").scoping do assert_equal highest_salary, Developer.last assert_equal lowest_salary, Developer.first end end def test_scoped_find_combines_and_sanitizes_conditions Developer.where("salary = 9000").scoping do assert_equal developers(:poor_jamis), Developer.where("name = 'Jamis'").first end end def test_scoped_find_all Developer.where("name = 'David'").scoping do assert_equal [developers(:david)], Developer.all end end def test_scoped_find_select Developer.select("id, name").scoping do developer = Developer.where("name = 'David'").first assert_equal "David", developer.name assert !developer.has_attribute?(:salary) end end def test_scope_select_concatenates Developer.select("id, name").scoping do developer = Developer.select('id, salary').where("name = 'David'").first assert_equal 80000, developer.salary assert developer.has_attribute?(:id) assert developer.has_attribute?(:name) assert developer.has_attribute?(:salary) end end def test_scoped_count Developer.where("name = 'David'").scoping do assert_equal 1, Developer.count end Developer.where('salary = 100000').scoping do assert_equal 8, Developer.count assert_equal 1, Developer.where("name LIKE 'fixture_1%'").count end end def test_scoped_find_include # with the include, will retrieve only developers for the given project scoped_developers = Developer.eager_load(:projects).scoping do Developer.where('projects.id = 2').all end assert scoped_developers.include?(developers(:david)) assert !scoped_developers.include?(developers(:jamis)) assert_equal 1, scoped_developers.size end def test_scoped_find_joins scoped_developers = Developer.joins('JOIN developers_projects ON id = developer_id').scoping do Developer.where('developers_projects.project_id = 2').all end assert scoped_developers.include?(developers(:david)) assert !scoped_developers.include?(developers(:jamis)) assert_equal 1, scoped_developers.size assert_equal developers(:david).attributes, scoped_developers.first.attributes end def test_scoped_create_with_where new_comment = VerySpecialComment.where(:post_id => 1).scoping do VerySpecialComment.create :body => "Wonderful world" end assert_equal 1, new_comment.post_id assert Post.find(1).comments.include?(new_comment) end def test_scoped_create_with_create_with new_comment = VerySpecialComment.create_with(:post_id => 1).scoping do VerySpecialComment.create :body => "Wonderful world" end assert_equal 1, new_comment.post_id assert Post.find(1).comments.include?(new_comment) end def test_scoped_create_with_create_with_has_higher_priority new_comment = VerySpecialComment.where(:post_id => 2).create_with(:post_id => 1).scoping do VerySpecialComment.create :body => "Wonderful world" end assert_equal 1, new_comment.post_id assert Post.find(1).comments.include?(new_comment) end def test_ensure_that_method_scoping_is_correctly_restored begin Developer.where("name = 'Jamis'").scoping do raise "an exception" end rescue end assert !Developer.scoped.where_values.include?("name = 'Jamis'") end end class NestedRelationScopingTest < ActiveRecord::TestCase fixtures :authors, :developers, :projects, :comments, :posts def test_merge_options Developer.where('salary = 80000').scoping do Developer.limit(10).scoping do devs = Developer.scoped assert_match '(salary = 80000)', devs.to_sql assert_equal 10, devs.taken end end end def test_merge_inner_scope_has_priority Developer.limit(5).scoping do Developer.limit(10).scoping do assert_equal 10, Developer.all.size end end end def test_replace_options Developer.where(:name => 'David').scoping do Developer.unscoped do assert_equal 'Jamis', Developer.where(:name => 'Jamis').first[:name] end assert_equal 'David', Developer.first[:name] end end def test_three_level_nested_exclusive_scoped_find Developer.where("name = 'Jamis'").scoping do assert_equal 'Jamis', Developer.first.name Developer.unscoped.where("name = 'David'") do assert_equal 'David', Developer.first.name Developer.unscoped.where("name = 'Maiha'") do assert_equal nil, Developer.first end # ensure that scoping is restored assert_equal 'David', Developer.first.name end # ensure that scoping is restored assert_equal 'Jamis', Developer.first.name end end def test_nested_scoped_create comment = Comment.create_with(:post_id => 1).scoping do Comment.create_with(:post_id => 2).scoping do Comment.create :body => "Hey guys, nested scopes are broken. Please fix!" end end assert_equal 2, comment.post_id end def test_nested_exclusive_scope_for_create comment = Comment.create_with(:body => "Hey guys, nested scopes are broken. Please fix!").scoping do Comment.unscoped.create_with(:post_id => 1).scoping do assert_blank Comment.new.body Comment.create :body => "Hey guys" end end assert_equal 1, comment.post_id assert_equal 'Hey guys', comment.body end end class HasManyScopingTest< ActiveRecord::TestCase fixtures :comments, :posts, :people, :references def setup @welcome = Post.find(1) end def test_forwarding_of_static_methods assert_equal 'a comment...', Comment.what_are_you assert_equal 'a comment...', @welcome.comments.what_are_you end def test_forwarding_to_scoped assert_equal 4, Comment.search_by_type('Comment').size assert_equal 2, @welcome.comments.search_by_type('Comment').size end def test_forwarding_to_dynamic_finders assert_equal 4, Comment.find_all_by_type('Comment').size assert_equal 2, @welcome.comments.find_all_by_type('Comment').size end def test_nested_scope_finder Comment.where('1=0').scoping do assert_equal 0, @welcome.comments.count assert_equal 'a comment...', @welcome.comments.what_are_you end Comment.where('1=1').scoping do assert_equal 2, @welcome.comments.count assert_equal 'a comment...', @welcome.comments.what_are_you end end def test_should_maintain_default_scope_on_associations magician = BadReference.find(1) assert_equal [magician], people(:michael).bad_references end def test_should_default_scope_on_associations_is_overriden_by_association_conditions reference = references(:michael_unicyclist).becomes(BadReference) assert_equal [reference], people(:michael).fixed_bad_references end def test_should_maintain_default_scope_on_eager_loaded_associations michael = Person.where(:id => people(:michael).id).includes(:bad_references).first magician = BadReference.find(1) assert_equal [magician], michael.bad_references end end class HasAndBelongsToManyScopingTest< ActiveRecord::TestCase fixtures :posts, :categories, :categories_posts def setup @welcome = Post.find(1) end def test_forwarding_of_static_methods assert_equal 'a category...', Category.what_are_you assert_equal 'a category...', @welcome.categories.what_are_you end def test_forwarding_to_dynamic_finders assert_equal 4, Category.find_all_by_type('SpecialCategory').size assert_equal 0, @welcome.categories.find_all_by_type('SpecialCategory').size assert_equal 2, @welcome.categories.find_all_by_type('Category').size end def test_nested_scope_finder Category.where('1=0').scoping do assert_equal 0, @welcome.categories.count assert_equal 'a category...', @welcome.categories.what_are_you end Category.where('1=1').scoping do assert_equal 2, @welcome.categories.count assert_equal 'a category...', @welcome.categories.what_are_you end end end class DefaultScopingTest < ActiveRecord::TestCase fixtures :developers, :posts def test_default_scope expected = Developer.find(:all, :order => 'salary DESC').collect { |dev| dev.salary } received = DeveloperOrderedBySalary.find(:all).collect { |dev| dev.salary } assert_equal expected, received end def test_default_scope_as_class_method assert_equal [developers(:david).becomes(ClassMethodDeveloperCalledDavid)], ClassMethodDeveloperCalledDavid.all end def test_default_scope_as_class_method_referencing_scope assert_equal [developers(:david).becomes(ClassMethodReferencingScopeDeveloperCalledDavid)], ClassMethodReferencingScopeDeveloperCalledDavid.all end def test_default_scope_as_block_referencing_scope assert_equal [developers(:david).becomes(LazyBlockReferencingScopeDeveloperCalledDavid)], LazyBlockReferencingScopeDeveloperCalledDavid.all end def test_default_scope_with_lambda assert_equal [developers(:david).becomes(LazyLambdaDeveloperCalledDavid)], LazyLambdaDeveloperCalledDavid.all end def test_default_scope_with_block assert_equal [developers(:david).becomes(LazyBlockDeveloperCalledDavid)], LazyBlockDeveloperCalledDavid.all end def test_default_scope_with_callable assert_equal [developers(:david).becomes(CallableDeveloperCalledDavid)], CallableDeveloperCalledDavid.all end def test_default_scope_is_unscoped_on_find assert_equal 1, DeveloperCalledDavid.count assert_equal 11, DeveloperCalledDavid.unscoped.count end def test_default_scope_is_unscoped_on_create assert_nil DeveloperCalledJamis.unscoped.create!.name end def test_default_scope_with_conditions_string assert_equal Developer.find_all_by_name('David').map(&:id).sort, DeveloperCalledDavid.find(:all).map(&:id).sort assert_equal nil, DeveloperCalledDavid.create!.name end def test_default_scope_with_conditions_hash assert_equal Developer.find_all_by_name('Jamis').map(&:id).sort, DeveloperCalledJamis.find(:all).map(&:id).sort assert_equal 'Jamis', DeveloperCalledJamis.create!.name end def test_default_scoping_with_threads 2.times do Thread.new { assert DeveloperOrderedBySalary.scoped.to_sql.include?('salary DESC') }.join end end def test_default_scope_with_inheritance wheres = InheritedPoorDeveloperCalledJamis.scoped.where_values_hash assert_equal "Jamis", wheres[:name] assert_equal 50000, wheres[:salary] end def test_default_scope_with_module_includes wheres = ModuleIncludedPoorDeveloperCalledJamis.scoped.where_values_hash assert_equal "Jamis", wheres[:name] assert_equal 50000, wheres[:salary] end def test_default_scope_with_multiple_calls wheres = MultiplePoorDeveloperCalledJamis.scoped.where_values_hash assert_equal "Jamis", wheres[:name] assert_equal 50000, wheres[:salary] end def test_method_scope expected = Developer.find(:all, :order => 'salary DESC, name DESC').collect { |dev| dev.salary } received = DeveloperOrderedBySalary.all_ordered_by_name.collect { |dev| dev.salary } assert_equal expected, received end def test_nested_scope expected = Developer.find(:all, :order => 'salary DESC, name DESC').collect { |dev| dev.salary } received = DeveloperOrderedBySalary.send(:with_scope, :find => { :order => 'name DESC'}) do DeveloperOrderedBySalary.find(:all).collect { |dev| dev.salary } end assert_equal expected, received end def test_scope_overwrites_default expected = Developer.find(:all, :order => 'salary DESC, name DESC').collect { |dev| dev.name } received = DeveloperOrderedBySalary.by_name.find(:all).collect { |dev| dev.name } assert_equal expected, received end def test_reorder_overrides_default_scope_order expected = Developer.order('name DESC').collect { |dev| dev.name } received = DeveloperOrderedBySalary.reorder('name DESC').collect { |dev| dev.name } assert_equal expected, received end def test_order_after_reorder_combines_orders expected = Developer.order('name DESC, id DESC').collect { |dev| [dev.name, dev.id] } received = Developer.order('name ASC').reorder('name DESC').order('id DESC').collect { |dev| [dev.name, dev.id] } assert_equal expected, received end def test_nested_exclusive_scope expected = Developer.find(:all, :limit => 100).collect { |dev| dev.salary } received = DeveloperOrderedBySalary.send(:with_exclusive_scope, :find => { :limit => 100 }) do DeveloperOrderedBySalary.find(:all).collect { |dev| dev.salary } end assert_equal expected, received end def test_order_in_default_scope_should_prevail expected = Developer.find(:all, :order => 'salary desc').collect { |dev| dev.salary } received = DeveloperOrderedBySalary.find(:all, :order => 'salary').collect { |dev| dev.salary } assert_equal expected, received end def test_create_attribute_overwrites_default_scoping assert_equal 'David', PoorDeveloperCalledJamis.create!(:name => 'David').name assert_equal 200000, PoorDeveloperCalledJamis.create!(:name => 'David', :salary => 200000).salary end def test_create_attribute_overwrites_default_values assert_equal nil, PoorDeveloperCalledJamis.create!(:salary => nil).salary assert_equal 50000, PoorDeveloperCalledJamis.create!(:name => 'David').salary end def test_default_scope_attribute jamis = PoorDeveloperCalledJamis.new(:name => 'David') assert_equal 50000, jamis.salary end def test_where_attribute aaron = PoorDeveloperCalledJamis.where(:salary => 20).new(:name => 'Aaron') assert_equal 20, aaron.salary assert_equal 'Aaron', aaron.name end def test_where_attribute_merge aaron = PoorDeveloperCalledJamis.where(:name => 'foo').new(:name => 'Aaron') assert_equal 'Aaron', aaron.name end def test_scope_composed_by_limit_and_then_offset_is_equal_to_scope_composed_by_offset_and_then_limit posts_limit_offset = Post.limit(3).offset(2) posts_offset_limit = Post.offset(2).limit(3) assert_equal posts_limit_offset, posts_offset_limit end def test_create_with_merge aaron = PoorDeveloperCalledJamis.create_with(:name => 'foo', :salary => 20).merge( PoorDeveloperCalledJamis.create_with(:name => 'Aaron')).new assert_equal 20, aaron.salary assert_equal 'Aaron', aaron.name aaron = PoorDeveloperCalledJamis.create_with(:name => 'foo', :salary => 20). create_with(:name => 'Aaron').new assert_equal 20, aaron.salary assert_equal 'Aaron', aaron.name end def test_create_with_reset jamis = PoorDeveloperCalledJamis.create_with(:name => 'Aaron').create_with(nil).new assert_equal 'Jamis', jamis.name end # FIXME: I don't know if this is *desired* behavior, but it is *today's* # behavior. def test_create_with_empty_hash_will_not_reset jamis = PoorDeveloperCalledJamis.create_with(:name => 'Aaron').create_with({}).new assert_equal 'Aaron', jamis.name end def test_unscoped_with_named_scope_should_not_have_default_scope assert_equal [DeveloperCalledJamis.find(developers(:poor_jamis).id)], DeveloperCalledJamis.poor assert DeveloperCalledJamis.unscoped.poor.include?(developers(:david).becomes(DeveloperCalledJamis)) assert_equal 10, DeveloperCalledJamis.unscoped.poor.length end def test_default_scope_select_ignored_by_aggregations assert_equal DeveloperWithSelect.all.count, DeveloperWithSelect.count end def test_default_scope_select_ignored_by_grouped_aggregations assert_equal Hash[Developer.all.group_by(&:salary).map { |s, d| [s, d.count] }], DeveloperWithSelect.group(:salary).count end def test_default_scope_order_ignored_by_aggregations assert_equal DeveloperOrderedBySalary.all.count, DeveloperOrderedBySalary.count end def test_default_scope_find_last assert DeveloperOrderedBySalary.count > 1, "need more than one row for test" lowest_salary_dev = DeveloperOrderedBySalary.find(developers(:poor_jamis).id) assert_equal lowest_salary_dev, DeveloperOrderedBySalary.last end def test_default_scope_include_with_count d = DeveloperWithIncludes.create! d.audit_logs.create! :message => 'foo' assert_equal 1, DeveloperWithIncludes.eager_load(:audit_logs).where(:audit_logs => { :message => 'foo' }).count end def test_default_scope_is_threadsafe if in_memory_db? return skip "in memory db can't share a db between threads" end threads = [] assert_not_equal 1, ThreadsafeDeveloper.unscoped.count threads << Thread.new do Thread.current[:long_default_scope] = true assert_equal 1, ThreadsafeDeveloper.all.count end threads << Thread.new do assert_equal 1, ThreadsafeDeveloper.all.count end threads.each(&:join) end end