| 12345678910111213141516 |
- #!/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"
|