Skip to main content

Import and map the USDA National Nutrient Database for Standard Reference (SR22) to Django models using MongoDB with mongoengine

Project description

https://badge.fury.io/py/django-usda-mongo.png https://travis-ci.org/javipalanca/django-usda-mongo.png?branch=master https://coveralls.io/repos/javipalanca/django-usda-mongo/badge.png?branch=master

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

  1. pip install django-usda-mongo or copy the usda_mongo folder to a location available on your PYTHONPATH.

  2. Add ‘usda’ to INSTALLED_APPS in settings.py

  3. 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.

History

0.1.0 (2015-03-31)

  • First release on PyPI.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

django_usda_mongo-0.1.1-py2.py3-none-any.whl (14.6 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file django_usda_mongo-0.1.1-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for django_usda_mongo-0.1.1-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 e6f179d55ff688e0b1e9058be187e2e71de3c3b03c7887512d968b28e4ead559
MD5 bb04557c6eedd4c561122736d6c667e9
BLAKE2b-256 bcdd45addd633ad4814b0301a3546c96fefba4cfc71c767509304b2f560bf4ab

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page