updateNDBno.sh 550 B

12345678910111213141516
  1. #!/bin/sh
  2. SCRIPT_DIR="$(dirname "$0")"
  3. DB="ieat"
  4. COLLECTION="Food"
  5. API_KEY=CfiHcUnSf0RX0jBuqiWjDK2d2ziOmoZG15CTdhQn
  6. API_URL="https://api.nal.usda.gov/ndb/reports"
  7. mongoexport -d $DB -c $COLLECTION | while read json; do
  8. NDBNO=$(echo $json | jq -r '.ndbno['$numberLong']')
  9. if [ $? -eq 0 ]; then
  10. NUTRIENTS=$(wget -SO - \
  11. "$API_URL?ndbno=$NDBNO&type=f&format=json&api_key=$API_KEY")
  12. echo "{ndbno: $NDBNO, nutrients: $NUTRIENTS}"
  13. fi
  14. done | mongoimport -d $DB -c $COLLECTION --mode=merge --upsertFields="ndbno"