luis@98: # This file should contain all the record creation needed to seed the database with its default values.
luis@98: # The data can then be loaded with the rake db:seed (or created alongside the db with db:setup).
luis@98: #
luis@98: # Examples:
luis@98: #   
luis@98: #   cities = City.create([{ :name => 'Chicago' }, { :name => 'Copenhagen' }])
luis@98: #   Major.create(:name => 'Daley', :city => cities.first)
luis@98: 
luisf@179: def truncate_table(table_name)
luisf@179:   quoted = connection.quote_table_name(table_name)
luisf@179:   connection.execute("TRUNCATE #{quoted}")
luisf@179: end
luisf@179: 
luisf@179: def connection
luisf@179:   ActiveRecord::Base.connection
luisf@179: end
luisf@179: 
luisf@179: truncate_table('institutions')
luisf@179: 
luisf@179: idx = 1
luis@98: 
luis@98: open("db/seed_data/institutions.txt") do |institutions|
luis@98:   institutions.read.each_line do |institution|
luisf@179:     Institution.create(:name => institution.chomp, :order => idx)
luisf@179:     idx = idx + 1
luis@98:   end
luis@98: end