GregEakin/NutrishSr28

USDA National Nutrient Database for Standard Reference SR28

Nutrish Sr28

🔥 Greg Eakin

This is an experiment in configuring an existing database in Hibernate and JUnit 5. Here we defined the schema with annotation in Java files.

Run the Unit Tests

1. Start the HSQLDB server by running dev.eakin.server.Database.main().
2. Initialize the DB schema with dev.eakin.Ddl.main().
3. Download SR28ASC.zip, and unzip into the data folder.
4. Load the data into the database with dev.eakin.DbLoad.main().
5. Run all unit tests; everything should pass.
6. Remember to shut down the database when finished, by running dev.eakin.server.Shudown.main().

Tags

• Hibernate Object-Relation Mapping
• HyperSQL Database
• US Department of Agriculture, Agricultural Research Service. 2016. Nutrient Data Laboratory. USDA National Nutrient Database for Standard Reference, Release 28 (Slightly revised). Version Current: May 2016.
• Java 11
• JUnit 5 Unit Tests

Database: