Feature/import jobs
{{ resolvedDiscussionCount }}/{{ discussionCount }} {{ resolvedCountText }} resolved
-
1 class ChangeIntegerLimitJob < ActiveRecord::Migration[6.0] 2 def change 3 change_column :jobs, :company_id, :integer, limit: 8 -
Master
giữ nguyên trường
company_idnhư cũ -
-
-
lib/tasks/import_job_csv.rake 0 → 100644
1 require "csv" 2 3 namespace :import_job_csv do 4 desc "Import CSV file into database" 5 task create_job: :environment do 6 file = "db/Venjob.csv" 7 CSV.foreach(file, headers: true) do |row| 8 job_hash = row.to_hash 9 job = Job.where(id: job_hash["id"]) -
Master
-
-
-
lib/tasks/import_job_csv.rake 0 → 100644
1 require "csv" 2 3 namespace :import_job_csv do 4 desc "Import CSV file into database" 5 task create_job: :environment do 6 file = "db/Venjob.csv" -
lib/tasks/import_job_csv.rake 0 → 100644
1 require "csv" 2 3 namespace :import_job_csv do 4 desc "Import CSV file into database" 5 task create_job: :environment do 6 file = "db/Venjob.csv" -
-
-
-
-
lib/tasks/import_job_csv.rake 0 → 100644
1 require "csv" 2 3 namespace :import_job_csv do -
Master
namespace nên để là job tên task nên để là import_csv
-
-
-
lib/tasks/import_job_csv.rake 0 → 100644
14 rescue 15 import_company_logger = ActiveSupport::Logger.new("log/import_company.log") 16 import_company_logger.info "Skip #{row}" 17 next 18 job_params = { 19 company_id: Company.find_by(code: row["Company id"]).id, 20 location: row["Work place"], 21 title: row["Name"], 22 description: row["Description"], 23 position: row["Level"], 24 salary: row["Salary"], 25 requirement: row["Requirement"] 26 } 27 Job.create!(job_params) 28 rescue 29 import_company_logger = ActiveSupport::Logger.new("log/import_job.log") -
MasterEdited by Van Hau Le
@hoangds sao có tới 2 rescue vậy em? tham khảo logger và error handling bên dưới nhé em
https://stackify.com/rails-logger-and-rails-logging-best-practices/
https://medium.com/rails-ember-beyond/error-handling-in-rails-the-modular-way-9afcddd2fe1b
-
-
-
-
-
-
-
lib/tasks/import_job_csv.rake 0 → 100644
3 namespace :job do 4 desc "Import CSV file into database" 5 task import_csv: :environment do 6 csv_file = Settings.import_job.csv_file 7 CSV.foreach(csv_file, headers: true) do |row| 8 company_params = { 9 email: row["contact email"], 10 name: row["company name"], 11 address: row["company address"], 12 code: row["company id"] 13 } 14 company = Company.find_or_initialize_by(code: row["company id"]) 15 company.update(company_params) 16 17 job_params = { 18 company_id: company.id, -
Master
bỏ trường này đi, k cần tới
-
-
-
-
merged
Toggle commit list
