Bulk operations with ActiveRecord import

                  require 'activerecord-import'

class BulkImportPostsService
  BATCH_SIZE = 1000

  def initialize(csv_file_path)
    @csv_file_path = csv_file_path
  end

  def call
    posts = []
    imported_count = 0

    CSV.foreach(@csv_file_path, headers: true) do |row|
      posts << Post.new(
        title: row['title'],
        body: row['body'],
        author_id: row['author_id'],
        published_at: row['published_at']
      )

      if posts.size >= BATCH_SIZE
        imported_count += import_batch(posts)
        posts = []
      end
    end

    # Import remaining posts
    imported_count += import_batch(posts) if posts.any?

    Result.success(imported_count: imported_count)
  rescue StandardError => e
    Rails.logger.error("Bulk import failed: #{e.message}")
    Result.failure(error: e.message)
  end

  private

  def import_batch(posts)
    Post.import(
      posts,
      validate: false,
      on_duplicate_key_update: {
        conflict_target: [:id],
        columns: [:title, :body, :updated_at]
      }
    )
    posts.size
  end
end