Contents

class EltChildrenCount < ActiveRecord::Migration
  def self.up
		add_column :elts, :elts_count, :integer, :default => 0
		execute 'UPDATE elts SET elts_count = (SELECT COUNT(*) FROM elts e2 WHERE e2.parent_id = elts.id)'
		add_index "elts", ["lft"], :name => "elts_lft_key"
		add_index "elts", ["parent_id"], :name => "elts_parent_key"
  end

  def self.down
		remove_column :elts, :elts_count
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
parlement-0.10	db/migrate/003_elt_children_count.rb
parlement-0.11	db/migrate/003_elt_children_count.rb
parlement-0.12	db/migrate/003_elt_children_count.rb
parlement-0.13	db/migrate/003_elt_children_count.rb
parlement-0.14	db/migrate/003_elt_children_count.rb
parlement-0.17	db/migrate/003_elt_children_count.rb