52 lines
1.3 KiB
Ruby
52 lines
1.3 KiB
Ruby
# == Schema Information
|
|
#
|
|
# Table name: csv_imports
|
|
#
|
|
# id :integer not null, primary key
|
|
# content :string not null
|
|
# separator :string not null
|
|
# created_at :datetime not null
|
|
# updated_at :datetime not null
|
|
#
|
|
class CsvImport < ApplicationRecord
|
|
enum :separator, { comma: ",", semicolon: ";" }, suffix: true, default: :comma
|
|
|
|
has_one_attached :file
|
|
|
|
validates :file, presence: true
|
|
validate :acceptable_csv, on: :create
|
|
|
|
before_save :read_csv
|
|
|
|
def acceptable_csv
|
|
return unless file.attached?
|
|
|
|
if file.blob.byte_size > 5 * 1024 * 1024
|
|
errors.add(:file, "this csv file is too large, it must be under 5MB")
|
|
return
|
|
end
|
|
|
|
if file.content_type != "text/csv"
|
|
errors.add(:file, :not_a_csv_file)
|
|
return
|
|
end
|
|
|
|
begin
|
|
csv = CSV.read(attachment_changes["file"].attachable.path, col_sep: separator)
|
|
|
|
errors.add(:file, :empty) if csv.count < 1 || (csv.count == 1 && csv[0].count == 1 && csv[0][0] == "")
|
|
rescue CSV::MalformedCSVError => e
|
|
errors.add(:file, e.message)
|
|
end
|
|
end
|
|
|
|
def read_csv
|
|
self.content = JSON.dump(CSV.read(attachment_changes["file"].attachable.path, col_sep: separator_for_database))
|
|
end
|
|
|
|
def options_for_separator
|
|
keys = self.class.separators.keys
|
|
keys.map(&:humanize).zip(keys).to_h
|
|
end
|
|
end
|