Rails在has_many：through关系中创建数据

debugcn 发表于 Dev

Ngoc Nghia

我有这些文件和CSV文件。现在我想

job.rb

class Job < ApplicationRecord
  has_many :city_jobs
  has_many :cities, through: :city_jobs
end

city.rb

class City < ApplicationRecord
  has_many :city_jobs
  has_many :jobs, through: :city_jobs
end

city_jobs.rb

class CityJob < ApplicationRecord
  belongs_to :city
  belongs_to :job
end

迁移文件

    create_table :jobs do |t|
      t.string :title
      t.string :level
      t.string :salary
      t.string :other_salary
      t.text :description
      t.text :short_des
      t.text :requirement
      t.integer :category
      t.datetime :post_date
      t.datetime :expiration_date
      t.references :company, foreign_key: true

      t.timestamps
    end

    create_table :cities do |t|
      t.string :name, unique: true
      t.string :region

      t.timestamps
    end


    create_table :city_jobs do |t|
      t.references :city, foreign_key: true
      t.references :job, foreign_key: true

      t.timestamps
    end

Import.rb需要“ csv”

class JobsImport
  def import_job
    jobs = []
    cities = []

    job_columns = [:title, :level, :salary, :description, :short_des,
                   :requirement, :category, :company_id]
    city_columns = [:name, :region]

    CSV.foreach(Rails.root.join("lib", "jobss.csv"), headers: true) do |row|
         cities << {name: row["company province"], region: "Việt Nam"}
         jobs << JobCsv.new(row).csv_attributes
    end

    City.import city_columns, cities, on_duplicate_key_ignore: true
    Job.import job_columns, jobs
    puts "Data imported"
  end
end

我已经从CSV导入了City和Job到数据库。现在如何创建保留City_id和Jobs_id的City_jobs表数据？请帮我！谢谢！

竿

您可以再次遍历CSV文件以连接两个表。

CSV.foreach(Rails.root.join("lib", "jobss.csv"), headers: true) do |row|
     city = City.find_by(name: row["company province"])
     job = Job.find_by(JobsCsv.new(row).csv_attributes)
     city.jobs << job
end

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。