批量导入数据

def import_countries
  country_file = Rails.root.join('db/data', 'country.csv').to_s

  countries = []

  CSV.foreach country_file do |row|
    country = Country.new name: row[2], code: row[3], name_en: row[1].gsub(/^\s+|\s+$/, '') # 去除投和尾的空格
    puts country
    countries << country
  end

  Country.import countries
end

def create_countries
  country_file = Rails.root.join('db/data', 'country.csv').to_s

  countries = []

  CSV.foreach country_file do |row|
    country = {
        name: row[2],
        code: row[3],
        name_en: row[1].gsub(/^\s+|\s+$/, '') # 去除投和尾的空格
    }

    puts country
    countries << country
  end

  Country.create countries
end

def prof(&block)
  start_time = Time.now

  if block_given?
    block.call
  end

  cost_time = Time.now - start_time

  puts "Cost Time is: #{cost_time} s"
end

prof do 
  import_countries # Cost Time is: 1.692939 s
end
  
prof do 
  create_countries # 0.241883 s
end