import_nutr_def.sh 898 B

1234567891011121314151617181920212223242526272829
  1. #!/bin/sh
  2. USDA_DB_FILE="sr28asc.zip"
  3. USDA_DB_URL="https://www.ars.usda.gov/ARSUserFiles/80400525/Data/SR/SR28/dnload/$USDA_DB_FILE"
  4. NUTR_DEF_FILE="NUTR_DEF.txt"
  5. SCRIPT_DIR="$(dirname "$0")"
  6. USDA_DIR="$SCRIPT_DIR/../usda"
  7. DB="ieat"
  8. COLLECTION="usda-nutrdef"
  9. if [ ! -d "$USDA_DIR" ]; then
  10. if ! mkdir "$USDA_DIR"; then
  11. echo 1>&2 "Failed to create directory: '$USDA_DIR'."
  12. exit 1
  13. fi
  14. fi
  15. if [ ! -f "$USDA_DIR/$USDA_DB_FILE" ]; then
  16. if ! wget -P "$USDA_DIR" "$USDA_DB_URL"; then
  17. echo 1>&2 "Error downloading USDA ASCII database."
  18. exit 1
  19. fi
  20. fi
  21. if ! unzip -o "$USDA_DIR/$USDA_DB_FILE" $NUTR_DEF_FILE -d "$USDA_DIR"; then
  22. echo 1>&2 "Error extracting USDA ASCII database."
  23. echo 1>&2 "File, '$USDA_DIR/$USDA_DB_FILE', may be corrupted."
  24. exit 1
  25. fi
  26. "$SCRIPT_DIR"/nutr_def.jq "$USDA_DIR"/$NUTR_DEF_FILE |
  27. mongoimport --drop -d $DB -c $COLLECTION