django-usda-mongo
Overview
django-usda-mongo imports and maps the USDA National Nutrient Database for Standard Reference (SR22) to Django models using MongoDB with mongoengine. It also integrate django-mongonaut to admin the MongoDB database.
Requirements
- Python 2.5.x
- Django 1.2.x (import_sr22 will not work with early versions)
- mongoengine
- django-mongonaut
Installation
- pip install django-usda-mongo or copy the usda_mongo folder to a location available on your PYTHONPATH.
- Add 'usda' to INSTALLED_APPS in settings.py
- Optionally, add (r'^usda/', include('usda.urls')), to your urlpatterns.
Data Import
To import the latest SR22 data. Simply use the import_sr22 management command as follows:
./manage.py import_sr22
The above assumes that the sr22.zip file is in the current folder. To specify an alternative location specify -f <filename>.
The import_sr22 command takes several options:
- --database <dbname> -- Specify an alternative database to populate.
- --food -- Create/update all foods.
- --group -- Create/Update food groups.
- --nutrient -- Create/Update nutrients.
- --weight -- Create/Update weights.
- --footnote -- Create/Update footnotes.
- --datasource -- Create/Update data sources.
- --derivation -- Create/Update data derivations.
- --source -- Create/Update sources.
- --data -- Create/Update nutrient data.'
- --all -- Create/Update all data.
All of the above options can be combined to only create/update the desired data. If no options are specified, -all is assumed.
Also note that all data is loaded in a single transaction to ensure that database consistency is maintained.
Notes
The USDA National Nutrient Database for Standard Reference (SR22) can be found here: http://www.ars.usda.gov/Services/docs.htm?docid=18879.