#!/bin/sh

SCRIPT_DIR="$(dirname "$0")"
DB="ieat"
COLLECTION="Food"
API_KEY=CfiHcUnSf0RX0jBuqiWjDK2d2ziOmoZG15CTdhQn
API_URL="https://api.nal.usda.gov/ndb/reports"

mongoexport -d $DB -c $COLLECTION | while read json; do
    NDBNO=$(echo $json | jq -r '.ndbno['$numberLong']')
    if [ $? -eq 0 ]; then
        NUTRIENTS=$(wget -SO - \
               "$API_URL?ndbno=$NDBNO&type=f&format=json&api_key=$API_KEY")
        echo "{ndbno: $NDBNO, nutrients: $NUTRIENTS}"
    fi
done | mongoimport -d $DB -c $COLLECTION --mode=merge --upsertFields="ndbno"