Makefile

GOOSE_VERSION := v3.27.3
GOOSE := go run github.com/pressly/goose/v3/cmd/goose@$(GOOSE_VERSION)

MIGRATIONS_DIR := apps/api/migrations
ENV_FILE := .env

.PHONY: migrate-create migrate-version migrate-status migrate-up migrate-down

migrate-create:
	@test -n "$(name)" || (echo "usage: make migrate-create name=<migration_name>"; exit 1)
	@mkdir -p $(MIGRATIONS_DIR)
	@$(GOOSE) -s -dir $(MIGRATIONS_DIR) create "$(name)" sql

migrate-version:
	@test -f $(ENV_FILE) || (echo "missing $(ENV_FILE); copy .env.example to .env"; exit 1)
	@set -a; . ./$(ENV_FILE); set +a; \
		$(GOOSE) postgres "$$DATABASE_URL" version

migrate-status:
	@test -f $(ENV_FILE) || (echo "missing $(ENV_FILE); copy .env.example to .env"; exit 1)
	@set -a; . ./$(ENV_FILE); set +a; \
		$(GOOSE) -dir $(MIGRATIONS_DIR) postgres "$$DATABASE_URL" status

migrate-up:
	@test -f $(ENV_FILE) || (echo "missing $(ENV_FILE); copy .env.example to .env"; exit 1)
	@set -a; . ./$(ENV_FILE); set +a; \
		$(GOOSE) -dir $(MIGRATIONS_DIR) postgres "$$DATABASE_URL" up

migrate-down:
	@test -f $(ENV_FILE) || (echo "missing $(ENV_FILE); copy .env.example to .env"; exit 1)
	@set -a; . ./$(ENV_FILE); set +a; \
		$(GOOSE) -dir $(MIGRATIONS_DIR) postgres "$$DATABASE_URL" down