mattes/migrate practice
$ curl -L https://github.com/mattes/migrate/releases/download/v3.0.1/migrate.linux-amd64.tar.gz | tr xvz
$ sudo mv migrate.linux-amd64 /usr/local/bin/migrate
run mysql(docker)
./mysql.sh
migrate
$ migrate -database 'mysql://root:my-secret-pw@tcp(127.0.0.1:3306)' -path ./sql up
version
$ migrate -database 'mysql://root:my-secret-pw@tcp(127.0.0.1:3306)' -path ./sql version
show data
$ docker exec some-mysql mysql -uroot -pmy-secret-pw -e 'select * from dbname.PERSON;'
show migrate data
$ docker exec some-mysql mysql -uroot -pmy-secret-pw -e 'select * from dbname.schema_migrations;'
clean mysql(docker)
$ docker rm -f some-mysql