[Rails 6.0] About batch saving of multiple records

Introduction

Since we have implemented the order management function in the personal application, we will output the method of batch saving of multiple records learned at that time.

Reference material

In creating this article, I have greatly referred to the following articles. I'm really thankful to you. [Rails 5] Procedure for batch registration of models [Rails 6] Batch registration using form_with 1.2. Implementation of batch registration form

Product

Register only products with checkboxes checked

Prerequisites

Product model

models/product.rb

class Product < ApplicationRecord

  with_options presence: true do
   validates :name
   validates :unit
   validates :price, numericality: {only_integer: true, greater_than_or_equal_to: 0 }
   validates :availability, inclusion: { in: [true, false] }
  end

end

policy

1. Create a collection model for saving multiple products at once
2. Describe the process for batch registration on the controller
3. Create a form that allows you to register multiple products at once on the view screen

1. Create a collection model for saving multiple products at once

Create a form directory in the models directory, and create a ProductCollection model and a Base model in it.

models/form/product_collection

class Form::ProductCollection < Form::Base
  FORM_COUNT = 10 #Here, specify the number of registration forms you want to create
  attr_accessor :products 

  def initialize(attributes = {})
    super attributes
    self.products = FORM_COUNT.times.map { Product.new() } unless self.products.present?
  end
  
  def products_attributes=(attributes)
    self.products = attributes.map { |_, v| Product.new(v) }
  end

  def save
    Product.transaction do
      self.products.map do |product|
        if product.availability #Only the products for which the check box is checked here are saved.
          product.save
        end
      end
    end
      return true
    rescue => e
      return false
  end
end

models/form/base.rb

class Form::Base
  include ActiveModel::Model
  include ActiveModel::Callbacks
  include ActiveModel::Validations
  include ActiveModel::Validations::Callbacks

end

2. Instance creation and data processing with the controller

controllers/products_controller.rb

class ProductsController < ApplicationController
  
  def new
    @form = Form::ProductCollection.new
  end

  def create
    @form = Form::ProductCollection.new(product_collection_params)
    if @form.save
      redirect_to products_path, notice: "I registered the product"
    else
      flash.now[:alert] = "Product registration failed"
      render :new
    end

  end

  private
  
    def product_collection_params
        params.require(:form_product_collection)
        .permit(products_attributes: [:name, :price, :unit, :availability])
    end
    
end

@form = Form :: ProductCollection.new will instantiate the model you just created. Strong parameters are received in products_attributes.

3. Create a form that allows you to register multiple products at once on the view screen

ruby:views/products/new.html.haml

= form_with model: @form, url: products_path, method: :post, local: true do |form|
  %table
    %thread
      %tr
        %th registration
        %th product name
        %th selling price (yen)
        %th ordering unit
  %tbody
    = form.fields_for :products do |f|
      %tr
        %td.text-center
          = f.check_box :availability
        %td
          = f.text_field :name
        %td
          = f.text_field :price
        %td
          = f.text_field :unit
  = form.submit "Bulk registration"
  = link_to "Return", :back

I am creating a form that can be registered multiple times using form_with and fields_for.

Now you can save all at once.

Finally

Thank you for visiting. If you have any mistakes, please point them out.