Thanks to web2py's DAL (Database Abstraction Layer),
web2py-usdadb
can import the USDA National Nutrient Database for Standard Reference (SR26)
to the database of your choice: SQLite, MySQL, Postgresql, Oracle etc.
- Python 2.6.x
- Copy the
web2py-usdadb
into a folder of your choice - Change the connection string in
model/db.py
to point to your database - run
python main.py
withinweb2py-usdadb
folder
- food_group_description
- food_description
- nutrient_definition
- nutrient_data
- weight
The USDA National Nutrient Database for Standard Reference can be found at: https://www.ars.usda.gov/main/site_main.htm?modecode=12-35-45-00