changeset 179:da7cba64948d feature_55

new column in institutions table: order
new seed data function

--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/db/migrate/20110202170156_add_order_column_to_institutions.rb	Wed Feb 02 18:17:02 2011 +0000
@@ -0,0 +1,9 @@
+class AddOrderColumnToInstitutions < ActiveRecord::Migration
+  def self.up
+       add_column :institutions, :order, :integer
+  end
+
+  def self.down
+      remove_column :institutions, :order
+  end
+end

--- a/db/seeds.rb	Wed Feb 02 16:29:10 2011 +0000
+++ b/db/seeds.rb	Wed Feb 02 18:17:02 2011 +0000
@@ -6,10 +6,22 @@
 #   cities = City.create([{ :name => 'Chicago' }, { :name => 'Copenhagen' }])
 #   Major.create(:name => 'Daley', :city => cities.first)
 
-Institution.delete_all
+def truncate_table(table_name)
+  quoted = connection.quote_table_name(table_name)
+  connection.execute("TRUNCATE #{quoted}")
+end
+
+def connection
+  ActiveRecord::Base.connection
+end
+
+truncate_table('institutions')
+
+idx = 1
 
 open("db/seed_data/institutions.txt") do |institutions|
   institutions.read.each_line do |institution|
-    Institution.create(:name => institution.chomp)
+    Institution.create(:name => institution.chomp, :order => idx)
+    idx = idx + 1
   end
 end
\ No newline at end of file