Sha256: 4eb5f1815a09074cf46c665d504e12d475045c90cee45141610468670534e680
Contents?: true
Size: 1.41 KB
Versions: 7
Compression:
Stored size: 1.41 KB
Contents
# This migration comes from spree (originally 20091007134354)
class ChangeTaxonsToNestedSet < ActiveRecord::Migration
def up
add_column :taxons, :lft, :integer
add_column :taxons, :rgt, :integer
Spree::Taxon.reset_column_information # So the new root ids get saved
# Temporarily set the table back to taxons
Spree::Taxon.table_name = 'taxons'
Spree::Taxon.class_eval do
# adapted from awesome nested set to use 'position' information
indices = {}
left_column_name = 'lft'
right_column_name = 'rgt'
quoted_parent_column_name = 'parent_id'
scope = lambda{|node|}
set_left_and_rights = lambda do |node|
# set left
node[left_column_name] = indices[scope.call(node)] += 1
# find
where("#{quoted_parent_column_name} = ?", node).order('position ASC').each{ |n| set_left_and_rights.call(n) }
# set right
node[right_column_name] = indices[scope.call(node)] += 1
node.save!
end
# Find root node(s)
where("#{quoted_parent_column_name}" => nil).order('position ASC').each do |root_node|
# setup index for this scope
indices[scope.call(root_node)] ||= 0
set_left_and_rights.call(root_node)
end
end
# Set it back after the migration
Spree::Taxon.table_name = 'spree_taxons'
end
def down
remove_column :taxons, :lft
remove_column :taxons, :rgt
end
end
Version data entries
7 entries across 7 versions & 2 rubygems