Creates a small database table
called dog and populates with
hql. Creates 2 lookup tables breedLookup
and colorLookup and 4N dog.
Joins breedLookup and colorLookup
to form a new table dogextended. These
case-counts are deministrated 3 ways, ResultTransformer,
looking up ids on breedLookup and colorLookup,
and non-ResultTransformer method.
Add an immutable entity breedcount as a case-count uses a subquery join.
Updated an immutable entity breedcount as a view using a subselect with
case and join.
Compiled and ran from build server bloop.
Dependencies must be compatable with jdk8 or less.
- bloop
- java
- bloop-sbt
- hibernate
- hql
- log4j
- dolt driver
- hseeberger/scala-bloop-sbt:11.0.2-oraclelinux7_1.3.5_2.12.10
- dolthub/dolt-sql-serverdb:latest
sudo ./install.sh -u
sudo ./install.sh -d
sudo ./install.sh -h