22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
# File 'app/sidekiq/income_limits/std_county_import.rb', line 22
def perform
ActiveRecord::Base.transaction do
data = fetch_csv_data
if data
CSV.parse(data, headers: true) do |row|
created = DateTime.strptime(row['CREATED'], '%m/%d/%Y %l:%M:%S.%N %p').to_s
updated = DateTime.strptime(row['UPDATED'], '%m/%d/%Y %l:%M:%S.%N %p').to_s if row['UPDATED']
std_county = StdCounty.find_or_initialize_by(id: row['ID'].to_i)
next unless std_county.new_record?
std_county.assign_attributes(
name: row['NAME'].to_s,
county_number: row['COUNTYNUMBER'].to_i,
description: row['DESCRIPTION'],
state_id: row['STATE_ID'].to_i,
version: row['VERSION'].to_i,
created:,
updated:,
created_by: row['CREATEDBY'].to_s,
updated_by: row['UPDATEDBY'].to_s
)
std_county.save!
end
else
raise 'Failed to fetch CSV data.'
end
end
rescue => e
ActiveRecord::Base.rollback_transaction
raise "error: #{e}"
end
|