diff db/seeds.rb @ 179:da7cba64948d feature_55

new column in institutions table: order
new seed data function

--- 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