https://qiita.com/im_yoneda/items/333c75cd69116dc74ec4
https://documentation.red-gate.com/flyway/getting-started-with-flyway/quickstart-guides/quickstart-command-line
OS: Rocky Linux 9
tar xvzf FlywayDesktopLinuxX64_8.5.4.0.tar.gz
cd flyway
cat <<-'EOF' > conf/flyway.toml
[flyway]
locations = ["filesystem:migrations"]
[environments.default]
url = "jdbc:sqlite:FlywayQuickStartCLI.db"
user = ""
password = ""
EOF
mkdir migrations
cat <<-'EOF' > migrations/V1__Create_person_table.sql
create table PERSON (
ID int not null,
NAME varchar(100) not null
);
EOF
./flyway migrate
cat <<-'EOF' > migrations/V2__Add_people.sql
insert into PERSON (ID, NAME) values (1, 'Axel');
insert into PERSON (ID, NAME) values (2, 'Mr. Foo');
insert into PERSON (ID, NAME) values (3, 'Ms. Bar');
EOF
./flyway migrate
sqlite3 FlywayQuickStartCLI.db
select * from PERSON;
.exit
