-
Supports OpenJdk 9+ / Spring Boot 2+ / Mariadb 10.3+
-
First create the database and create a new user and grant privileges
CREATE USER IF NOT EXISTS 'user'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE test;
GRANT ALL PRIVILEGES ON test.* TO 'user'@'localhost' ;
-
After that you youd need to update application*.properties files which can be found in server/travelneer-spring-boot/src/main/resources with the username, password and url
-
Then build the project:
$ mvn clean install -DskipTests
- Flyway is a database migration tool that supports both raw SQL based migrations and Java based migrations
- SQL migrations can be found in server/travelneer-spring-boot/src/main/resources/db/migration/ while Java migrations can be - found in server/travelneer-spring-boot/src/main/java/db/migration (this folder does not exist yet as I never needed to use Java - based migrations until now).
- I have set up spring boot to automatically validate and run new migrations with each run using application*.properties files but you can still use this command to run migrations:
$ mvn flyway:migrate -Dflyway.url=... -Dflyway.user=... -Dflyway.password=... -DskipTests
- Alternatively you can create an external config file and use the following command:
$ mvn flyway:migrate -Dflyway.configFiles=path/to/myAlternativeConfig.conf -DskipTests
- JOOQ is a library that provides a DSL to construct queries from classes generated from a database schema
- Generated classes can be found in server/travelneer-spring-boot/src/generated/java/com/travelneer/jooq/
- You can use this command to generate JOOQ classes (see generate profile in server/travelneer-spring-boot/pom.xml for more details):
$ mvn install -Pgenerate -DskipTests
Note: You can use -DskipTests if you would like to skip tests