Chris@1115: require File.dirname(__FILE__) + '/test_helper'
Chris@1115: 
Chris@1115: class Note < ActiveRecord::Base
Chris@1115:   acts_as_nested_set :scope => [:notable_id, :notable_type]
Chris@1115: end
Chris@1115: 
Chris@1115: class AwesomeNestedSetTest < Test::Unit::TestCase
Chris@1115: 
Chris@1115:   class Default < ActiveRecord::Base
Chris@1115:     acts_as_nested_set
Chris@1115:     self.table_name = 'categories'
Chris@1115:   end
Chris@1115:   class Scoped < ActiveRecord::Base
Chris@1115:     acts_as_nested_set :scope => :organization
Chris@1115:     self.table_name = 'categories'
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_column_default
Chris@1115:     assert_equal 'lft', Default.acts_as_nested_set_options[:left_column]
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_right_column_default
Chris@1115:     assert_equal 'rgt', Default.acts_as_nested_set_options[:right_column]
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_parent_column_default
Chris@1115:     assert_equal 'parent_id', Default.acts_as_nested_set_options[:parent_column]
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_scope_default
Chris@1115:     assert_nil Default.acts_as_nested_set_options[:scope]
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_left_column_name
Chris@1115:     assert_equal 'lft', Default.left_column_name
Chris@1115:     assert_equal 'lft', Default.new.left_column_name
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_right_column_name
Chris@1115:     assert_equal 'rgt', Default.right_column_name
Chris@1115:     assert_equal 'rgt', Default.new.right_column_name
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_parent_column_name
Chris@1115:     assert_equal 'parent_id', Default.parent_column_name
Chris@1115:     assert_equal 'parent_id', Default.new.parent_column_name
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_quoted_left_column_name
Chris@1115:     quoted = Default.connection.quote_column_name('lft')
Chris@1115:     assert_equal quoted, Default.quoted_left_column_name
Chris@1115:     assert_equal quoted, Default.new.quoted_left_column_name
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_quoted_right_column_name
Chris@1115:     quoted = Default.connection.quote_column_name('rgt')
Chris@1115:     assert_equal quoted, Default.quoted_right_column_name
Chris@1115:     assert_equal quoted, Default.new.quoted_right_column_name
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_column_protected_from_assignment
Chris@1115:     assert_raises(ActiveRecord::ActiveRecordError) { Category.new.lft = 1 }
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_right_column_protected_from_assignment
Chris@1115:     assert_raises(ActiveRecord::ActiveRecordError) { Category.new.rgt = 1 }
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_parent_column_protected_from_assignment
Chris@1115:     assert_raises(ActiveRecord::ActiveRecordError) { Category.new.parent_id = 1 }
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_colums_protected_on_initialize
Chris@1115:     c = Category.new(:lft => 1, :rgt => 2, :parent_id => 3)
Chris@1115:     assert_nil c.lft
Chris@1115:     assert_nil c.rgt
Chris@1115:     assert_nil c.parent_id
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_scoped_appends_id
Chris@1115:     assert_equal :organization_id, Scoped.acts_as_nested_set_options[:scope]
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_roots_class_method
Chris@1115:     assert_equal Category.find_all_by_parent_id(nil), Category.roots
Chris@1115:   end
Chris@1115:     
Chris@1115:   def test_root_class_method
Chris@1115:     assert_equal categories(:top_level), Category.root
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_root
Chris@1115:     assert_equal categories(:top_level), categories(:child_3).root
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_root?
Chris@1115:     assert categories(:top_level).root?
Chris@1115:     assert categories(:top_level_2).root?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_leaves_class_method
Chris@1115:     assert_equal Category.find(:all, :conditions => "#{Category.right_column_name} - #{Category.left_column_name} = 1"), Category.leaves
Chris@1115:     assert_equal Category.leaves.count, 4
Chris@1115:     assert (Category.leaves.include? categories(:child_1))
Chris@1115:     assert (Category.leaves.include? categories(:child_2_1))
Chris@1115:     assert (Category.leaves.include? categories(:child_3))
Chris@1115:     assert (Category.leaves.include? categories(:top_level_2))
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_leaf
Chris@1115:     assert categories(:child_1).leaf?
Chris@1115:     assert categories(:child_2_1).leaf?
Chris@1115:     assert categories(:child_3).leaf?
Chris@1115:     assert categories(:top_level_2).leaf?
Chris@1115:     
Chris@1115:     assert !categories(:top_level).leaf?
Chris@1115:     assert !categories(:child_2).leaf?
Chris@1115:   end
Chris@1115:     
Chris@1115:   def test_parent
Chris@1115:     assert_equal categories(:child_2), categories(:child_2_1).parent
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_self_and_ancestors
Chris@1115:     child = categories(:child_2_1)
Chris@1115:     self_and_ancestors = [categories(:top_level), categories(:child_2), child]
Chris@1115:     assert_equal self_and_ancestors, child.self_and_ancestors
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_ancestors
Chris@1115:     child = categories(:child_2_1)
Chris@1115:     ancestors = [categories(:top_level), categories(:child_2)]
Chris@1115:     assert_equal ancestors, child.ancestors
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_self_and_siblings
Chris@1115:     child = categories(:child_2)
Chris@1115:     self_and_siblings = [categories(:child_1), child, categories(:child_3)]
Chris@1115:     assert_equal self_and_siblings, child.self_and_siblings
Chris@1115:     assert_nothing_raised do
Chris@1115:       tops = [categories(:top_level), categories(:top_level_2)]
Chris@1115:       assert_equal tops, categories(:top_level).self_and_siblings
Chris@1115:     end
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_siblings
Chris@1115:     child = categories(:child_2)
Chris@1115:     siblings = [categories(:child_1), categories(:child_3)]
Chris@1115:     assert_equal siblings, child.siblings
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_leaves
Chris@1115:     leaves = [categories(:child_1), categories(:child_2_1), categories(:child_3), categories(:top_level_2)]
Chris@1115:     assert categories(:top_level).leaves, leaves
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_level
Chris@1115:     assert_equal 0, categories(:top_level).level
Chris@1115:     assert_equal 1, categories(:child_1).level
Chris@1115:     assert_equal 2, categories(:child_2_1).level
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_has_children?
Chris@1115:     assert categories(:child_2_1).children.empty?
Chris@1115:     assert !categories(:child_2).children.empty?
Chris@1115:     assert !categories(:top_level).children.empty?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_self_and_descendents
Chris@1115:     parent = categories(:top_level)
Chris@1115:     self_and_descendants = [parent, categories(:child_1), categories(:child_2),
Chris@1115:       categories(:child_2_1), categories(:child_3)]
Chris@1115:     assert_equal self_and_descendants, parent.self_and_descendants
Chris@1115:     assert_equal self_and_descendants, parent.self_and_descendants.count
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_descendents
Chris@1115:     lawyers = Category.create!(:name => "lawyers")
Chris@1115:     us = Category.create!(:name => "United States")
Chris@1115:     us.move_to_child_of(lawyers)
Chris@1115:     patent = Category.create!(:name => "Patent Law")
Chris@1115:     patent.move_to_child_of(us)
Chris@1115:     lawyers.reload
Chris@1115: 
Chris@1115:     assert_equal 1, lawyers.children.size
Chris@1115:     assert_equal 1, us.children.size
Chris@1115:     assert_equal 2, lawyers.descendants.size
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_self_and_descendents
Chris@1115:     parent = categories(:top_level)
Chris@1115:     descendants = [categories(:child_1), categories(:child_2),
Chris@1115:       categories(:child_2_1), categories(:child_3)]
Chris@1115:     assert_equal descendants, parent.descendants
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_children
Chris@1115:     category = categories(:top_level)
Chris@1115:     category.children.each {|c| assert_equal category.id, c.parent_id }
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_is_or_is_ancestor_of?
Chris@1115:     assert categories(:top_level).is_or_is_ancestor_of?(categories(:child_1))
Chris@1115:     assert categories(:top_level).is_or_is_ancestor_of?(categories(:child_2_1))
Chris@1115:     assert categories(:child_2).is_or_is_ancestor_of?(categories(:child_2_1))
Chris@1115:     assert !categories(:child_2_1).is_or_is_ancestor_of?(categories(:child_2))
Chris@1115:     assert !categories(:child_1).is_or_is_ancestor_of?(categories(:child_2))
Chris@1115:     assert categories(:child_1).is_or_is_ancestor_of?(categories(:child_1))
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_is_ancestor_of?
Chris@1115:     assert categories(:top_level).is_ancestor_of?(categories(:child_1))
Chris@1115:     assert categories(:top_level).is_ancestor_of?(categories(:child_2_1))
Chris@1115:     assert categories(:child_2).is_ancestor_of?(categories(:child_2_1))
Chris@1115:     assert !categories(:child_2_1).is_ancestor_of?(categories(:child_2))
Chris@1115:     assert !categories(:child_1).is_ancestor_of?(categories(:child_2))
Chris@1115:     assert !categories(:child_1).is_ancestor_of?(categories(:child_1))
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_is_or_is_ancestor_of_with_scope
Chris@1115:     root = Scoped.root
Chris@1115:     child = root.children.first
Chris@1115:     assert root.is_or_is_ancestor_of?(child)
Chris@1115:     child.update_attribute :organization_id, 'different'
Chris@1115:     assert !root.is_or_is_ancestor_of?(child)
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_is_or_is_descendant_of?
Chris@1115:     assert categories(:child_1).is_or_is_descendant_of?(categories(:top_level))
Chris@1115:     assert categories(:child_2_1).is_or_is_descendant_of?(categories(:top_level))
Chris@1115:     assert categories(:child_2_1).is_or_is_descendant_of?(categories(:child_2))
Chris@1115:     assert !categories(:child_2).is_or_is_descendant_of?(categories(:child_2_1))
Chris@1115:     assert !categories(:child_2).is_or_is_descendant_of?(categories(:child_1))
Chris@1115:     assert categories(:child_1).is_or_is_descendant_of?(categories(:child_1))
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_is_descendant_of?
Chris@1115:     assert categories(:child_1).is_descendant_of?(categories(:top_level))
Chris@1115:     assert categories(:child_2_1).is_descendant_of?(categories(:top_level))
Chris@1115:     assert categories(:child_2_1).is_descendant_of?(categories(:child_2))
Chris@1115:     assert !categories(:child_2).is_descendant_of?(categories(:child_2_1))
Chris@1115:     assert !categories(:child_2).is_descendant_of?(categories(:child_1))
Chris@1115:     assert !categories(:child_1).is_descendant_of?(categories(:child_1))
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_is_or_is_descendant_of_with_scope
Chris@1115:     root = Scoped.root
Chris@1115:     child = root.children.first
Chris@1115:     assert child.is_or_is_descendant_of?(root)
Chris@1115:     child.update_attribute :organization_id, 'different'
Chris@1115:     assert !child.is_or_is_descendant_of?(root)
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_same_scope?
Chris@1115:     root = Scoped.root
Chris@1115:     child = root.children.first
Chris@1115:     assert child.same_scope?(root)
Chris@1115:     child.update_attribute :organization_id, 'different'
Chris@1115:     assert !child.same_scope?(root)
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_left_sibling
Chris@1115:     assert_equal categories(:child_1), categories(:child_2).left_sibling
Chris@1115:     assert_equal categories(:child_2), categories(:child_3).left_sibling
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_sibling_of_root
Chris@1115:     assert_nil categories(:top_level).left_sibling
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_sibling_without_siblings
Chris@1115:     assert_nil categories(:child_2_1).left_sibling
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_sibling_of_leftmost_node
Chris@1115:     assert_nil categories(:child_1).left_sibling
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_right_sibling
Chris@1115:     assert_equal categories(:child_3), categories(:child_2).right_sibling
Chris@1115:     assert_equal categories(:child_2), categories(:child_1).right_sibling
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_right_sibling_of_root
Chris@1115:     assert_equal categories(:top_level_2), categories(:top_level).right_sibling
Chris@1115:     assert_nil categories(:top_level_2).right_sibling
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_right_sibling_without_siblings
Chris@1115:     assert_nil categories(:child_2_1).right_sibling
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_right_sibling_of_rightmost_node
Chris@1115:     assert_nil categories(:child_3).right_sibling
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_move_left
Chris@1115:     categories(:child_2).move_left
Chris@1115:     assert_nil categories(:child_2).left_sibling
Chris@1115:     assert_equal categories(:child_1), categories(:child_2).right_sibling
Chris@1115:     assert Category.valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_move_right
Chris@1115:     categories(:child_2).move_right
Chris@1115:     assert_nil categories(:child_2).right_sibling
Chris@1115:     assert_equal categories(:child_3), categories(:child_2).left_sibling
Chris@1115:     assert Category.valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_move_to_left_of
Chris@1115:     categories(:child_3).move_to_left_of(categories(:child_1))
Chris@1115:     assert_nil categories(:child_3).left_sibling
Chris@1115:     assert_equal categories(:child_1), categories(:child_3).right_sibling
Chris@1115:     assert Category.valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_move_to_right_of
Chris@1115:     categories(:child_1).move_to_right_of(categories(:child_3))
Chris@1115:     assert_nil categories(:child_1).right_sibling
Chris@1115:     assert_equal categories(:child_3), categories(:child_1).left_sibling
Chris@1115:     assert Category.valid?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_move_to_root
Chris@1115:     categories(:child_2).move_to_root
Chris@1115:     assert_nil categories(:child_2).parent
Chris@1115:     assert_equal 0, categories(:child_2).level
Chris@1115:     assert_equal 1, categories(:child_2_1).level
Chris@1115:     assert_equal 1, categories(:child_2).left
Chris@1115:     assert_equal 4, categories(:child_2).right
Chris@1115:     assert Category.valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_move_to_child_of
Chris@1115:     categories(:child_1).move_to_child_of(categories(:child_3))
Chris@1115:     assert_equal categories(:child_3).id, categories(:child_1).parent_id
Chris@1115:     assert Category.valid?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_move_to_child_of_appends_to_end
Chris@1115:     child = Category.create! :name => 'New Child'
Chris@1115:     child.move_to_child_of categories(:top_level)
Chris@1115:     assert_equal child, categories(:top_level).children.last
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_subtree_move_to_child_of
Chris@1115:     assert_equal 4, categories(:child_2).left
Chris@1115:     assert_equal 7, categories(:child_2).right
Chris@1115:     
Chris@1115:     assert_equal 2, categories(:child_1).left
Chris@1115:     assert_equal 3, categories(:child_1).right
Chris@1115:     
Chris@1115:     categories(:child_2).move_to_child_of(categories(:child_1))
Chris@1115:     assert Category.valid?
Chris@1115:     assert_equal categories(:child_1).id, categories(:child_2).parent_id
Chris@1115:     
Chris@1115:     assert_equal 3, categories(:child_2).left
Chris@1115:     assert_equal 6, categories(:child_2).right
Chris@1115:     assert_equal 2, categories(:child_1).left
Chris@1115:     assert_equal 7, categories(:child_1).right    
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_slightly_difficult_move_to_child_of
Chris@1115:     assert_equal 11, categories(:top_level_2).left
Chris@1115:     assert_equal 12, categories(:top_level_2).right
Chris@1115:     
Chris@1115:     # create a new top-level node and move single-node top-level tree inside it.
Chris@1115:     new_top = Category.create(:name => 'New Top')
Chris@1115:     assert_equal 13, new_top.left
Chris@1115:     assert_equal 14, new_top.right
Chris@1115:     
Chris@1115:     categories(:top_level_2).move_to_child_of(new_top)
Chris@1115:     
Chris@1115:     assert Category.valid?
Chris@1115:     assert_equal new_top.id, categories(:top_level_2).parent_id
Chris@1115:     
Chris@1115:     assert_equal 12, categories(:top_level_2).left
Chris@1115:     assert_equal 13, categories(:top_level_2).right
Chris@1115:     assert_equal 11, new_top.left
Chris@1115:     assert_equal 14, new_top.right    
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_difficult_move_to_child_of
Chris@1115:     assert_equal 1, categories(:top_level).left
Chris@1115:     assert_equal 10, categories(:top_level).right
Chris@1115:     assert_equal 5, categories(:child_2_1).left
Chris@1115:     assert_equal 6, categories(:child_2_1).right
Chris@1115:     
Chris@1115:     # create a new top-level node and move an entire top-level tree inside it.
Chris@1115:     new_top = Category.create(:name => 'New Top')
Chris@1115:     categories(:top_level).move_to_child_of(new_top)
Chris@1115:     categories(:child_2_1).reload
Chris@1115:     assert Category.valid?  
Chris@1115:     assert_equal new_top.id, categories(:top_level).parent_id
Chris@1115:     
Chris@1115:     assert_equal 4, categories(:top_level).left
Chris@1115:     assert_equal 13, categories(:top_level).right
Chris@1115:     assert_equal 8, categories(:child_2_1).left
Chris@1115:     assert_equal 9, categories(:child_2_1).right    
Chris@1115:   end
Chris@1115: 
Chris@1115:   #rebuild swaps the position of the 2 children when added using move_to_child twice onto same parent
Chris@1115:   def test_move_to_child_more_than_once_per_parent_rebuild
Chris@1115:     root1 = Category.create(:name => 'Root1')
Chris@1115:     root2 = Category.create(:name => 'Root2')
Chris@1115:     root3 = Category.create(:name => 'Root3')
Chris@1115:     
Chris@1115:     root2.move_to_child_of root1
Chris@1115:     root3.move_to_child_of root1
Chris@1115:       
Chris@1115:     output = Category.roots.last.to_text
Chris@1115:     Category.update_all('lft = null, rgt = null')
Chris@1115:     Category.rebuild!
Chris@1115:     
Chris@1115:     assert_equal Category.roots.last.to_text, output
Chris@1115:   end
Chris@1115:   
Chris@1115:   # doing move_to_child twice onto same parent from the furthest right first
Chris@1115:   def test_move_to_child_more_than_once_per_parent_outside_in
Chris@1115:     node1 = Category.create(:name => 'Node-1')
Chris@1115:     node2 = Category.create(:name => 'Node-2')
Chris@1115:     node3 = Category.create(:name => 'Node-3')
Chris@1115:     
Chris@1115:     node2.move_to_child_of node1
Chris@1115:     node3.move_to_child_of node1
Chris@1115:       
Chris@1115:     output = Category.roots.last.to_text
Chris@1115:     Category.update_all('lft = null, rgt = null')
Chris@1115:     Category.rebuild!
Chris@1115:     
Chris@1115:     assert_equal Category.roots.last.to_text, output
Chris@1115:   end
Chris@1115: 
Chris@1115: 
Chris@1115:   def test_valid_with_null_lefts
Chris@1115:     assert Category.valid?
Chris@1115:     Category.update_all('lft = null')
Chris@1115:     assert !Category.valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_valid_with_null_rights
Chris@1115:     assert Category.valid?
Chris@1115:     Category.update_all('rgt = null')
Chris@1115:     assert !Category.valid?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_valid_with_missing_intermediate_node
Chris@1115:     # Even though child_2_1 will still exist, it is a sign of a sloppy delete, not an invalid tree.
Chris@1115:     assert Category.valid?
Chris@1115:     Category.delete(categories(:child_2).id)
Chris@1115:     assert Category.valid?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_valid_with_overlapping_and_rights
Chris@1115:     assert Category.valid?
Chris@1115:     categories(:top_level_2)['lft'] = 0
Chris@1115:     categories(:top_level_2).save
Chris@1115:     assert !Category.valid?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_rebuild
Chris@1115:     assert Category.valid?
Chris@1115:     before_text = Category.root.to_text
Chris@1115:     Category.update_all('lft = null, rgt = null')
Chris@1115:     Category.rebuild!
Chris@1115:     assert Category.valid?
Chris@1115:     assert_equal before_text, Category.root.to_text
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_move_possible_for_sibling
Chris@1115:     assert categories(:child_2).move_possible?(categories(:child_1))
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_move_not_possible_to_self
Chris@1115:     assert !categories(:top_level).move_possible?(categories(:top_level))
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_move_not_possible_to_parent
Chris@1115:     categories(:top_level).descendants.each do |descendant|
Chris@1115:       assert !categories(:top_level).move_possible?(descendant)
Chris@1115:       assert descendant.move_possible?(categories(:top_level))
Chris@1115:     end
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_is_or_is_ancestor_of?
Chris@1115:     [:child_1, :child_2, :child_2_1, :child_3].each do |c|
Chris@1115:       assert categories(:top_level).is_or_is_ancestor_of?(categories(c))
Chris@1115:     end
Chris@1115:     assert !categories(:top_level).is_or_is_ancestor_of?(categories(:top_level_2))
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_left_and_rights_valid_with_blank_left
Chris@1115:     assert Category.left_and_rights_valid?
Chris@1115:     categories(:child_2)[:lft] = nil
Chris@1115:     categories(:child_2).save(false)
Chris@1115:     assert !Category.left_and_rights_valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_and_rights_valid_with_blank_right
Chris@1115:     assert Category.left_and_rights_valid?
Chris@1115:     categories(:child_2)[:rgt] = nil
Chris@1115:     categories(:child_2).save(false)
Chris@1115:     assert !Category.left_and_rights_valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_and_rights_valid_with_equal
Chris@1115:     assert Category.left_and_rights_valid?
Chris@1115:     categories(:top_level_2)[:lft] = categories(:top_level_2)[:rgt]
Chris@1115:     categories(:top_level_2).save(false)
Chris@1115:     assert !Category.left_and_rights_valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_and_rights_valid_with_left_equal_to_parent
Chris@1115:     assert Category.left_and_rights_valid?
Chris@1115:     categories(:child_2)[:lft] = categories(:top_level)[:lft]
Chris@1115:     categories(:child_2).save(false)
Chris@1115:     assert !Category.left_and_rights_valid?
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_left_and_rights_valid_with_right_equal_to_parent
Chris@1115:     assert Category.left_and_rights_valid?
Chris@1115:     categories(:child_2)[:rgt] = categories(:top_level)[:rgt]
Chris@1115:     categories(:child_2).save(false)
Chris@1115:     assert !Category.left_and_rights_valid?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_moving_dirty_objects_doesnt_invalidate_tree
Chris@1115:     r1 = Category.create
Chris@1115:     r2 = Category.create
Chris@1115:     r3 = Category.create
Chris@1115:     r4 = Category.create
Chris@1115:     nodes = [r1, r2, r3, r4]
Chris@1115:     
Chris@1115:     r2.move_to_child_of(r1)
Chris@1115:     assert Category.valid?
Chris@1115:     
Chris@1115:     r3.move_to_child_of(r1)
Chris@1115:     assert Category.valid?
Chris@1115:     
Chris@1115:     r4.move_to_child_of(r2)
Chris@1115:     assert Category.valid?
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_multi_scoped_no_duplicates_for_columns?
Chris@1115:     assert_nothing_raised do
Chris@1115:       Note.no_duplicates_for_columns?
Chris@1115:     end
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_multi_scoped_all_roots_valid?
Chris@1115:     assert_nothing_raised do
Chris@1115:       Note.all_roots_valid?
Chris@1115:     end
Chris@1115:   end
Chris@1115: 
Chris@1115:   def test_multi_scoped
Chris@1115:     note1 = Note.create!(:body => "A", :notable_id => 2, :notable_type => 'Category')
Chris@1115:     note2 = Note.create!(:body => "B", :notable_id => 2, :notable_type => 'Category')
Chris@1115:     note3 = Note.create!(:body => "C", :notable_id => 2, :notable_type => 'Default')
Chris@1115:     
Chris@1115:     assert_equal [note1, note2], note1.self_and_siblings
Chris@1115:     assert_equal [note3], note3.self_and_siblings
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_multi_scoped_rebuild
Chris@1115:     root = Note.create!(:body => "A", :notable_id => 3, :notable_type => 'Category')
Chris@1115:     child1 = Note.create!(:body => "B", :notable_id => 3, :notable_type => 'Category')
Chris@1115:     child2 = Note.create!(:body => "C", :notable_id => 3, :notable_type => 'Category')
Chris@1115:     
Chris@1115:     child1.move_to_child_of root
Chris@1115:     child2.move_to_child_of root
Chris@1115:           
Chris@1115:     Note.update_all('lft = null, rgt = null')
Chris@1115:     Note.rebuild!
Chris@1115:     
Chris@1115:     assert_equal Note.roots.find_by_body('A'), root
Chris@1115:     assert_equal [child1, child2], Note.roots.find_by_body('A').children
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_same_scope_with_multi_scopes
Chris@1115:     assert_nothing_raised do
Chris@1115:       notes(:scope1).same_scope?(notes(:child_1))
Chris@1115:     end
Chris@1115:     assert notes(:scope1).same_scope?(notes(:child_1))
Chris@1115:     assert notes(:child_1).same_scope?(notes(:scope1))
Chris@1115:     assert !notes(:scope1).same_scope?(notes(:scope2))
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_quoting_of_multi_scope_column_names
Chris@1115:     assert_equal ["\"notable_id\"", "\"notable_type\""], Note.quoted_scope_column_names
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_equal_in_same_scope
Chris@1115:     assert_equal notes(:scope1), notes(:scope1)
Chris@1115:     assert_not_equal notes(:scope1), notes(:child_1)
Chris@1115:   end
Chris@1115:   
Chris@1115:   def test_equal_in_different_scopes
Chris@1115:     assert_not_equal notes(:scope1), notes(:scope2)
Chris@1115:   end
Chris@1115:   
Chris@1115: end