blob: 0ca14f192c5464714ee4b0a6d01ecb37f955f66c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
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}"
|
