FERTILIZER_RECIPES = [
  {
    name: "Multi K Reci",
    purity: 99.0,
    composition: [
      { component: {
          name: "Potassium nitrate",
          formula: "KNO3",
          nno3: 13.0,
          k: 46.0 },
        percent_w: 100.0 }
    ]
  },
  {
    name: "Fixa Mn",
    purity: 98.0,
    composition: [
      { component: {
          name: "Manganese sulfate",
          formula: "MnSO4·H2O",
          mn: 32.0,
          s: 18.0 },
        percent_w: 100.0 }
    ]
  },
  {
    name: "Multi-Cal Haïfa",
    purity: 99.0,
    composition: [
      { component: {
          name: "Calcium nitrate",
          formula: "Ca(NO3)2·4H2O",
          nno3: 15.5,
          ca: 19.0 },
        percent_w: 100.0 }
    ]
  },
  {
    name: "DAP 18/46/00",
    purity: 100.0,
    composition: [
      { component: {
          name: "Diammonium phosphate",
          formula: "(NH4)2HPO4",
          nnh4: 18.0,
          p: 20.0 },
        percent_w: 100.0 }
    ]
  },
  {
    name: "Patenkali",
    purity: 100.0,
    composition: [
      { component: {
          name: "Potassium sulfate",
          formula: "K2SO4",
          k: 50.0,
          s: 18.0
        }, percent_w: 100.0 }
    ]
  },
  {
    name: "Eso Top",
    purity: 100.0,
    composition: [
      { component: {
          name: "Magnesium sulfate",
          formula: "MgSO4·7H2O",
          mg: 9.8,
          s: 13.0 },
        percent_w: 100.0 }
    ]
  },
  {
    name: "Ammonitrate 27",
    purity: 100.0,
    composition: [
      { component: {
          name: "Ammonium nitrate",
          formula: "NH4NO3",
          nno3: 13.5,
          nnh4: 13.5 },
        percent_w: 100.0 }
    ]
  },
  {
    name: "Fer chélaté",
    purity: 100.0,
    composition: [
      { component: {
          name: "Iron chelate (EDDHA)",
          formula: "Fe-EDDHA",
          fe: 6.0 },
        percent_w: 100.0 }
    ]
  },
  {
    name: "Carbonate de calcium",
    purity: 100.0,
    composition: [
      { component: {
          name: "Calcium carbonate",
          formula: "CaCO3",
          ca: 40.0 },
        percent_w: 100.0 }
    ]
  },
  {
    name: "Héliocuivre",
    purity: 100.0,
    composition: [
      { component: {
          name: "Copper chelate (EDTA)",
          formula: "Cu-EDTA",
          cu: 14.0 },
        percent_w: 100.0 }
    ]
  }
]

FERTILIZER_RECIPES.each do |recipe|
  product = FertilizerProduct.find_or_create_by!(name: recipe[:name]) do |fp|
    fp.purity = recipe[:purity]
  end

  recipe[:composition].each do |c|
    comp_attrs = c[:component]
    component = FertilizerComponent.find_or_create_by!(name: comp_attrs[:name]) do |fc|
      fc.formula = comp_attrs[:formula]
    end
    # update nutrient fields if missing
    component.update!(comp_attrs.except(:name, :formula))

    FertilizerComposition.find_or_create_by!(
      fertilizer_product: product,
      fertilizer_component: component
    ) do |fc|
      fc.percent_w = c[:percent_w]
    end
  end
end

puts "FertilizerProducts: #{FertilizerProduct.count}"