marybozorgi / library

0 stars 0 forks source link

Adding Flyway for Database Migration #6

Open marybozorgi opened 2 years ago

marybozorgi commented 2 years ago

followed document https://flywaydb.org/documentation/getstarted/firststeps/commandline

changed the flyway.conf by following changes flyway.url=jdbc:postgresql://localhost:5432/postgres flyway.user=lib_user flyway.password=Password1

added migration file to sql folder with following format V1__Create_PersonTable.sql ( note: did not work with one after V1?!)

run command flyway migrate and checked database ( database needed re-connecting to show changes) ./flyway migrate

not sure why got some connection error when tried downloading newer version but the old version was working fine

next step could be setting up the flyway plugin instead of using the command line tool