One off Flyway command line examples

flyway_cmdline_examples.sh

# Flyway command line examples
#

# Print some info about the migrations applied (or not) in the DB, relating to the migration scripts in some directory 
flyway -X -url='jdbc:mariadb://localhost:3306/my_db?currentSchema=my_schema' \
    -user='my_db_user' -password='my_db_passwd' \
    -locations=filesystem:./src/main/resources/db/migration \
    info

# Migrate the DB using the files in the directory, but only up to version 1.2
flyway -X -url='jdbc:mariadb://localhost:3306/my_db?currentSchema=my_schema' \
    -user='my_db_user' -password='my_db_passwd' \
    -locations=filesystem:./src/main/resources/db/migration \
    -target='1.2' migrate