Skip to content

Latest commit

 

History

History
79 lines (56 loc) · 2.73 KB

README.md

File metadata and controls

79 lines (56 loc) · 2.73 KB
Raw

Numeri-wall common

This module helps to prepare the different resources used during the development phase

  • Flyway : manages the database migration
  • Gradle : pilots all the tasks

Database used in the build process

We use Flyway to manage the databases. All the SQL scripts to create the database are in the resources. For the default build lifecycle, we use an H2 database

To avoid to launch all the Gradle phases go in the directory ~/Workspace/ewall and to manage your database used these commands

To migrate your schema

../gradlew flywayMigrate -Pdatabase=mysql

If you want to have more informations on your database version launch

../gradlew flywayInfo -Pdatabase=mysql

And if you want to delete the database you can used

../gradlew flywayClean -Pdatabase=mysql

If you want to init an H2 database use

../gradlew flywayClean flywayMigrate

If you want to use a remote database params to launch flyway you can use

../gradlew flywayClean flywayMigrate -Dflyway.url=jdbc:mysql://localhost:3306/mixit -Dflyway.user=mixit -Dflyway.password=mixit -Dflyway.locations=classpath:db/migration/mysql

Database used when you launch the app

By default the app needs a MySQL DB. If you want to use the H2 database you need to override the Spring Boot configuration and used these args when you launch the jar

./gradlew bootRun --spring.datasource.driver-class-name=org.h2.Driver --spring.datasource.url=jdbc:h2:file:ewall --spring.datasource.username=sa --spring.datasource.password=

The database is not created automatically when you start the application. If you want to generate the database you can use flyway or add these arguments.

If you want to use MySQL, install a version > 5.x

If you want to ovverride the default MySQL database you can use environment variables

export EMSE_NW_DATABASE_DRIVER=com.mysql.jdbc.Driver
export EMSE_NW_DATABASE_HOST=localhost
export EMSE_NW_DATABASE_PORT=3306
export EMSE_NW_DATABASE_SCHEMA=ewall
export EMSE_NW_DATABASE_USERNAME=ewall
export EMSE_NW_DATABASE_PASSWORD=ewall
export

Create a default schema in MySql

mysql -u root -p

Then

CREATE DATABASE ewall;
CREATE USER 'ewall'@'localhost' IDENTIFIED BY 'ewall';
GRANT ALL on ewall.* TO 'ewall'@'localhost';