1 files changed, 25 insertions, 0 deletions
diff --git a/db/seeds/NutrientMeasurement.rb b/db/seeds/NutrientMeasurement.rb
new file mode 100644
index 0000000..fcf8cfa
--- /dev/null
+++ b/db/seeds/NutrientMeasurement.rb
@@ -0,0 +1,25 @@
+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