如何将字符串转换为ActionDispatch::Http::UploadedFile？REST API上传需求

Absolutely! You can totally convert a file path string into an ActionDispatch::Http::UploadedFile object to handle Excel uploads via a REST API (no browser required) and import the data into your database. Let me break down the process clearly:

Step 1: Know What UploadedFile Needs #

ActionDispatch::Http::UploadedFile relies on a few key parameters to initialize properly:

• tempfile: A file-like object (usually a Tempfile) pointing to your Excel file
• filename: The actual name of the file (e.g., sales_data.xlsx)
• content_type: The correct MIME type for Excel files—use application/vnd.openxmlformats-officedocument.spreadsheetml.sheet for .xlsx files, or application/vnd.ms-excel for older .xls files

Step 2: Build the UploadedFile Object from a Path #

Here’s a practical code snippet to create the object from your file path:

require 'tempfile'
require 'action_dispatch/http/uploaded_file'

# Replace this with your actual file path
file_path = "/home/user/documents/import_data.xlsx"

# Open the file and wrap it in a Tempfile (safer for request handling than the original file)
original_file = File.open(file_path, 'rb')
tempfile = Tempfile.new(['excel_upload', '.xlsx'], binmode: true)
tempfile.write(original_file.read)
tempfile.rewind # Reset the file pointer to the start

# Initialize the UploadedFile
uploaded_file = ActionDispatch::Http::UploadedFile.new(
  tempfile: tempfile,
  filename: File.basename(file_path),
  content_type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
)

original_file.close # Don't forget to clean up the original file handle

Step 3: Send the File via API Request #

How you send the file depends on whether you’re testing your API or making external requests:

For Rails Testing (RSpec/Minitest) #

Pass the uploaded_file directly in your request params, just like a browser would:

# Example RSpec request spec
post '/api/v1/excel_imports', params: {
  excel_file: uploaded_file
}

For External Requests (Faraday Client) #

If you’re calling the API from another service, use Faraday::UploadIO to handle the multipart form data:

require 'faraday'

conn = Faraday.new(url: 'https://your-api-domain.com') do |faraday|
  faraday.request :multipart
  faraday.request :url_encoded
  faraday.adapter Faraday.default_adapter
end

response = conn.post '/api/v1/excel_imports' do |req|
  req.params['excel_file'] = Faraday::UploadIO.new(
    file_path,
    'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
    File.basename(file_path)
  )
end

Step 4: Handle the Upload in Your Controller #

Set up your controller to receive the file, parse the Excel, and insert data into the database. Use a gem like roo for easy Excel parsing:

class Api::V1::ExcelImportsController < ApplicationController
  def create
    @excel_file = params[:excel_file]
    
    # Parse the Excel file (install 'roo' gem first)
    require 'roo'
    xlsx = Roo::Excelx.new(@excel_file.tempfile.path)
    
    # Iterate through rows and import data
    xlsx.each_row_streaming(offset: 1) do |row| # Skip header row with offset:1
      YourModel.create!(
        name: row[0].value,
        amount: row[1].value,
        date: row[2].value
        # Add other columns as needed
      )
    end

    render json: { message: 'Excel data imported successfully!' }, status: :created
  end
end

Key Things to Remember #

• Always validate the file path: Make sure the file exists and your application has read permissions for it.
• Clean up temp files: In production, ensure temp files are deleted after processing to avoid filling up disk space.
• Validate file content: Don’t trust uploads blindly—check that the file is actually an Excel file (use content type checks or gem-specific validations) to prevent malicious uploads.
• Multipart form data is required: File uploads via API rely on multipart/form-data encoding, so make sure your request client supports this (like Faraday with the :multipart middleware).

内容的提问来源于stack exchange，提问作者Ross Agulto