Contents

class MoveTagIntoVclass < ActiveRecord::Migration
  def self.up
    # create a new virtual class for each site and assign all tags to this class.
    Site.find(:all).each do |site|
      VirtualClass.connection.execute("INSERT INTO virtual_classes (`name`,`kpath`,`real_class`,`icon`,`allowed_attributes`,`create_group_id`,`site_id`) VALUES ('Tag','NPT','Page',NULL,NULL,#{site[:site_group_id]},#{site[:id]})")
      vclass = VirtualClass.find(:first, :conditions=>["site_id = ? AND kpath = 'NPT'",site[:id]])
      Node.connection.execute "UPDATE nodes SET vclass_id = #{vclass[:id]} WHERE kpath = 'NPT'"
    end
  end

  def self.down
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
zena-0.16.9	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.8	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.7	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.6	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.5	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.4	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.3	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.2	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.1	db/migrate/025_move_tag_into_vclass.rb
zena-0.16.0	db/migrate/025_move_tag_into_vclass.rb
zena-0.15.2	db/migrate/025_move_tag_into_vclass.rb
zena-0.15.1	db/migrate/025_move_tag_into_vclass.rb
zena-0.15.0	db/migrate/025_move_tag_into_vclass.rb