TBD.
Stacks : Golang, MySQL, Nginx, Ubuntu...
Using Domain Drive Design with Golang
If you have change in database please create sql syntax to rollback, because infra need sleep.
Please Install golang-migrate to migrate database, to install golang-migrate you can read this documentation:
Windows :
https://verinumbenator.medium.com/installing-golang-migrate-on-windows-b4b3df9b97b2
Mac :
brew install golang-migrate
Ubuntu :
https://www.geeksforgeeks.org/how-to-install-golang-migrate-on-ubuntu/
if have done to install golang-migrate, please prepare your database and create new database, for example kerjago_db.
Migrate Create
Create a migration file. You can find the file at migration folder
make migrate-create NAME=namefile
Migrate Up To migrate all your migration file
make migrate-up
Migrate Down To delete all your schema with migration
make migrate-down
Migrate Rollback
to run migration down only N step(s) behind
make migrate-rollback N=yournumberrunmigrationdown
Fixing your Migration
What happend if your database is dirty?
You can fix your migration first and then using foce command with the version you want.
If you're happend to get error: Dirty database version 16. Fix and force version.
Then you want to run:
make migrate-force VERSION=15
Reference: golang-migrate/migrate#282 (comment)