postgres-docker-setup-makefile

makefile

postgres:
	docker run --name <postgres-container-name> -p 5432:5432 -e POSTGRES_PASSWORD=<postgres-password> -d postgres:14-alpine

createdb:
	docker exec -it <postgres-container-name> createdb --username=<username> --owner=postgres <db-name>

dropdb:
	docker exec -it <postgres-container-name> dropdb <db-name>

migrateup:
	migrate -path <sql-file-path> -database "postgresql://postgres:<postgres-password>@localhost:5432/<db-name>?sslmode=disable" -verbose up 

migratedown:
	migrate -path <sql-file-path> -database "postgresql://postgres:<postgres-password>@localhost:5432/<db-name>?sslmode=disable" -verbose down 


.PHONY: postgres createdb dropdb migrateup migratedown