foodTable.scr

#!/bin/bash
#Usage: ./test.scr BARCODE1 BARCODE2 … > test.csv Example: ./test.scr 8000500310427 90162602 5449000000996 > test.csv

#Print CSV header once
echo '"product_name","carbohydrates","protein","fat","fiber","water","alcohol","sodium","salt","vitamin_a","vitamin_b1","vitamin_b2","vitamin_b3","vitamin_b6","vitamin_b12","vitamin_c","vitamin_d","vitamin_e","vitamin_k","iron","potassium","calcium","bad_sugar","bad_fat","cholesterol","omega3_omega6"'

for BARCODE in "$@"; do
  curl -s "https://world.openfoodfacts.org/api/v2/product/${BARCODE}.json" \
  | jq -r '
    .product as $p
    | [
        $p.product_name // "",
        ($p.nutriments["carbohydrates_100g"] // 0),
        ($p.nutriments["proteins_100g"] // 0),
        ($p.nutriments["fat_100g"] // 0),
        ($p.nutriments["fiber_100g"] // 0),
        ($p.nutriments["water_100g"] // 0),
        ($p.nutriments["alcohol_100g"] // 0),
        ($p.nutriments["sodium_100g"] // 0),
        ($p.nutriments["salt_100g"] // 0),
        ($p.nutriments["vitamin-a_100g"] // 0),
        ($p.nutriments["vitamin-b1_100g"] // 0),
        ($p.nutriments["vitamin-b2_100g"] // 0),
        ($p.nutriments["vitamin-b3_100g"] // 0),
        ($p.nutriments["vitamin-b6_100g"] // 0),
        ($p.nutriments["vitamin-b12_100g"] // 0),
        ($p.nutriments["vitamin-c_100g"] // 0),
        ($p.nutriments["vitamin-d_100g"] // 0),
        ($p.nutriments["vitamin-e_100g"] // 0),
        ($p.nutriments["vitamin-k_100g"] // 0),
        ($p.nutriments["iron_100g"] // 0),
        ($p.nutriments["potassium_100g"] // 0),
        ($p.nutriments["calcium_100g"] // 0),
        ($p.nutriments["sugars_100g"] // 0),
        ($p.nutriments["saturated-fat_100g"] // 0),
        ($p.nutriments["cholesterol_100g"] // 0),
        (
          ($p.nutriments["omega-3-fat_100g"] // 0) +
          ($p.nutriments["omega-6-fat_100g"] // 0)
        )
      ]
    | @csv
  '
done


#
#Bad Fat Type	Description
#Trans fats	Artificial fats created by hydrogenating vegetable oils. Found in margarine, packaged snacks, fried fast foods, and baked goods.
#Partially hydrogenated oils	The main source of industrial trans fats.
#Excess saturated fats	Found in fatty cuts of meat, full-fat dairy products, butter, lard, palm oil, and coconut oil (though the health effects of coconut oil are debated).
#High omega-6 fats without omega-3 balance	Found in certain vegetable oils (soybean, corn, sunflower oil) and processed foods. Excessive omega-6 can promote inflammation.

#Main Types of Bad Sugars
#Type of Sugar	Description
#Added sugars	Sugars added to foods during processing or preparation. Examples: table sugar (sucrose), high-fructose corn syrup (HFCS), glucose syrup.
#Refined sugars	Sugars stripped of nutrients during processing — e.g., white sugar, brown sugar, powdered sugar.
#High-fructose corn syrup (HFCS)	A sweetener made from corn starch containing high levels of fructose; widely used in soft drinks and processed foods.
#Liquid sugars in beverages	Soft drinks, energy drinks, sweetened juices. They spike blood sugar quickly.
#Confectionery sugars	Candies, syrups, pastries — usually high in sucrose and low in nutrients.