如何使用smarter_csv为API批量创建- Ruby on Rails

gem 'smarter_csv'

rails generate controller Api::Users

namespace :api do
  resources :users do
    collection do
      post :import
    end
  end
end

module Api
  class UsersController < ApplicationController
    def import
      if params[:file].nil?
        render json: { error: 'No file provided' }, status: :unprocessable_entity and return
      end

      begin
        # 使用 SmarterCSV 处理 CSV 文件
        options = { key_mapping: { name: :name, email: :email } } # 根据 CSV 文件的列名进行映射
        SmarterCSV.process(params[:file].path, options) do |chunk|
          # 批量创建用户
          User.insert_all(chunk.map { |row| row[:data] })
        end

        render json: { message: 'Users imported successfully' }, status: :ok
      rescue => e
        render json: { error: e.message }, status: :unprocessable_entity
      end
    end
  end
end

name,email
John Doe,john@example.com
Jane Smith,jane@example.com

curl -X POST http://localhost:3000/api/users/import -F "file=@path/to/your/file.csv"

module Api
  class UsersController < ApplicationController
    def import
      if params[:file].nil?
        render json: { error: 'No file provided' }, status: :unprocessable_entity and return
      end

      begin
        options = { key_mapping: { name: :name, email: :email } }
        SmarterCSV.process(params[:file].path, options) do |chunk|
          User.insert_all(chunk.map { |row| row[:data] })
        end

        render json: { message: 'Users imported successfully' }, status: :ok
      rescue => e
        render json: { error: e.message }, status: :unprocessable_entity
      end
    end
  end
end