require "csv"

csv_path = Rails.root.join("db", "data", "dolibarr_measurements.csv")
abort "CSV not found: #{csv_path}" unless File.exist?(csv_path)

CSV.foreach(csv_path, headers: true) do |row|
  NutrientMeasurement.find_or_create_by!(measured_on: Date.parse(row["date"])) do |m|
    m.nno3 = row["nno3"]
    m.p    = row["p"]
    m.k    = row["k"]
    m.ca   = row["ca"]
    m.mg   = row["mg"]
    m.s    = row["s"]
    m.na   = row["na"]
    m.cl   = row["cl"]
    m.si   = row["si"]
    m.fe   = row["fe"]
    m.zn   = row["zn"]
    m.b    = row["b"]
    m.mn   = row["mn"]
    m.cu   = row["cu"]
    m.mo   = row["mo"]
    m.nnh4 = row["nnh4"]
  end
end

puts "NutrientMeasurements: #{NutrientMeasurement.count}"