20140528194044_create_database_descriptions_table.rb 487 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 
class CreateDatabaseDescriptionsTable < ActiveRecord::Migration
  def self.up
    create_table :database_descriptions do |t|
      t.string :name
    end

    file_name = "plugins/software_communities/public/static/databases.txt"
    list_file = File.open file_name, "r"
    list_file.each_line do |line|
      execute("INSERT INTO database_descriptions (name) VALUES ('#{line.strip}')")
    end
    list_file.close
  end

  def self.down
    drop_table :database_descriptions
  end
end