Ruby on Rails - 从 CSV 文件导入数据

# Ruby on Rails - 从 CSV 文件导入数据

ruby
<%= form_for @data_import, url: import_data_path, html: { multipart: true } do |f| %>
  <%= f.label :csv_file %>
  <%= f.file_field :csv_file %>
  <%= f.submit "导入数据" %>
<% end %>

ruby
class DataImportsController < ApplicationController
  def new
    @data_import = DataImport.new
  end
  def create
    @data_import = DataImport.new(data_import_params)
    if @data_import.save
      # 解析CSV文件并导入数据的代码将在下一部分中提供
      flash[:success] = "数据导入成功！"
      redirect_to data_path
    else
      render :new
    end
  end
  private
  def data_import_params
    params.require(:data_import).permit(:csv_file)
  end
end

ruby
class DataImport < ApplicationRecord
  mount_uploader :csv_file, CsvFileUploader
  def import_data
    if csv_file.present? && csv_file.file.exists?
      CSV.foreach(csv_file.path, headers: true) do |row|
        # 在这里处理每一行CSV数据并将其导入数据库
        # 例如：data = Data.new(column1: row['column1'], column2: row['column2'])
        # data.save
      end
    end
  end
end