Nutrish Sr28 Kotlin

🔥 Greg Eakin

This is an experiment in configuring an existing database in Hibernate and JUnit 5. Here we defined the schema with annotations in Kotlin files running in the JRE.

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.
• Kotlin A modern programming language that makes developers happier.
• Java 11
• JUnit 5 Unit Tests

Database: