Redmine

language: ruby

script: bundle exec rspec spec

  - DB=postgresql

  - DB=mysql

  - 2.0.0

  - 1.9.3

  - rbx-19mode

  - jruby-19mode

  - rbx-18mode

  - jruby-18mode

  - gemfiles/Gemfile.rails-3.2.rb

2.1.6

* Fixed rebuild! when there is a default_scope with order [Adrian Serafin]

* Testing with stable bundler, ruby 2.0, MySQL and PostgreSQL [Philip Arndt]

* Optimized move_to for large trees [ericsmith66]

task :spec do

  %w(3.0 3.1 3.2).each do |rails_version|

    puts "\n" + (cmd = "BUNDLE_GEMFILE='gemfiles/Gemfile.rails-#{rails_version}.rb' bundle exec rspec spec")

    system cmd

  end

end

require File.expand_path('../lib/awesome_nested_set/version', __FILE__)

  s.extra_rdoc_files = %w[README.rdoc]

  s.license = %q{MIT}

  s.add_development_dependency 'rspec-rails', '~> 2.12'

  s.add_development_dependency 'rake', '~> 10'

  s.add_development_dependency 'combustion', '>= 0.3.3'

            # default_scope with order may break database queries so we do all operation without scope

            unscoped do

              # Don't rebuild a valid tree.

              return true if valid?

              scope = lambda{|node|}

              if acts_as_nested_set_options[:scope]

                scope = lambda{|node|

                  scope_column_names.inject(""){|str, column_name|

                    str << "AND #{connection.quote_column_name(column_name)} = #{connection.quote(node.send(column_name.to_sym))} "

                  }

              end

              indices = {}

              set_left_and_rights = lambda do |node|

                # set left

                node[left_column_name] = indices[scope.call(node)] += 1

                # find

                where(["#{quoted_parent_column_full_name} = ? #{scope.call(node)}", node]).order("#{quoted_left_column_full_name}, #{quoted_right_column_full_name}, id").each{|n| set_left_and_rights.call(n) }

                # set right

                node[right_column_name] = indices[scope.call(node)] += 1

                node.save!(:validate => validate_nodes)

              end

              # Find root node(s)

              root_nodes = where("#{quoted_parent_column_full_name} IS NULL").order("#{quoted_left_column_full_name}, #{quoted_right_column_full_name}, id").each do |root_node|

                # setup index for this scope

                indices[scope.call(root_node)] ||= 0

                set_left_and_rights.call(root_node)

              end

              where_statement = ["not (#{quoted_left_column_name} = CASE " +

                                     "WHEN #{quoted_left_column_name} BETWEEN :a AND :b " +

                                     "THEN #{quoted_left_column_name} + :d - :b " +

                                     "WHEN #{quoted_left_column_name} BETWEEN :c AND :d " +

                                     "THEN #{quoted_left_column_name} + :a - :c " +

                                     "ELSE #{quoted_left_column_name} END AND " +

                                     "#{quoted_right_column_name} = CASE " +

                                     "WHEN #{quoted_right_column_name} BETWEEN :a AND :b " +

                                     "THEN #{quoted_right_column_name} + :d - :b " +

                                     "WHEN #{quoted_right_column_name} BETWEEN :c AND :d " +

                                     "THEN #{quoted_right_column_name} + :a - :c " +

                                     "ELSE #{quoted_right_column_name} END AND " +

                                     "#{quoted_parent_column_name} = CASE " +

                                     "WHEN #{self.class.base_class.primary_key} = :id THEN :new_parent " +

                                     "ELSE #{quoted_parent_column_name} END)" ,

                                 {:a => a, :b => b, :c => c, :d => d, :id => self.id, :new_parent => new_parent}    ]

              self.nested_set_scope.where(*where_statement).update_all([

  VERSION = '2.1.6' unless defined?(::AwesomeNestedSet::VERSION)

require 'awesome_nested_set/helper'

  describe 'rebuilding tree with a default scope ordering' do

    it "doesn't throw exception" do

      expect { Position.rebuild! }.not_to raise_error

    end

  end

  encoding: unicode

  database: awesome_nested_set_plugin_test

  pool: 5

  min_messages: warning

  password:

  password:

  create_table :positions, :force => true do |t|

    t.column :name, :string

    t.column :parent_id, :integer

    t.column :lft, :integer

    t.column :rgt, :integer

    t.column :depth, :integer

    t.column :position, :integer

  end

ActiveRecord::Base.establish_connection(ENV["DB"] ||= "sqlite3mem")

require 'combustion/database'

Combustion::Database.create_database(ActiveRecord::Base.configurations[ENV["DB"]])

require 'awesome_nested_set'

require 'action_controller'

  config.after(:suite) do

    unless /sqlite/ === ENV['DB']

      Combustion::Database.drop_database(ActiveRecord::Base.configurations[ENV['DB']])

    end

  end

class Position < ActiveRecord::Base

  acts_as_nested_set

  default_scope order(:position)

end