Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Creates a small database table

NotificationsYou must be signed in to change notification settings

bearddan2000/java-cli-maven-mysql-liquibase-view

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Description

Creates a small database tablecalleddog. This table,dog, has been normalized to 3NF.Two new tables have been added,breedLookup andcolorLookup.Creates a new tabledog_expanded that joinsdog,breedLookup andcolorLookup. Added clustered indexes ondog.breedId anddog.colorId and a non-clustered index fordog_expanded.id. Turneddog_expanded into a view with animplicit index ondog_expanded.id. All output normallyseen in a terminal will be injava-srv/log which will dump to the screen. The project may seem to hang but the logs from the container must be written to the project this can take up to 3 min.

Uses liquibase migration tool to augmentthe schema.

Tech stack

  • java
  • liquibase
  • maven
    • log4j
    • mysql driver

Docker stack

  • maven:3-openjdk-17
  • mariadb:latest
  • webdevops/liquibase:mysql

To run

sudo ./install.sh -uCreates java-srv/log

To stop

sudo ./install.sh -dRemoves java-srv/log

For help

sudo ./install.sh -h

Credit

Releases

No releases published

Packages

No packages published

[8]ページ先頭

©2009-2025 Movatter.jp