view db/seeds.rb @ 774:58410c63bb84 feature_334

Force a Google search box rudely into the middle of the search view, just to see how it looks. It can be styled reasonably well -- but the adverts, when they appear, are atrocious.
author Chris Cannam <chris.cannam@soundsoftware.ac.uk>
date Thu, 17 Nov 2011 14:56:55 +0000
parents 5b074cadc4d1
children
line wrap: on
line source
# This file should contain all the record creation needed to seed the database with its default values.
# The data can then be loaded with the rake db:seed (or created alongside the db with db:setup).
#
# Examples:
#   
#   cities = City.create([{ :name => 'Chicago' }, { :name => 'Copenhagen' }])
#   Major.create(:name => 'Daley', :city => cities.first)

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

open("db/seed_data/institutions.txt") do |institutions|
  institutions.read.each_line do |institution|
    inst=institution.split('|')
    
    
    Institution.create(:name => inst[0].chomp, :order => inst[1].chomp)
  end
end