Makefile

DB_CONTAINER=pokemondb
DB_PASSWORD=1234
DB_USER=postgres
DB_NAME = postgres

GOOSE_DRIVER=postgres
GOOSE_DBSTRING="postgres://${DB_USER}:${DB_PASSWORD}@localhost:5432/${DB_NAME}?sslmode=disable"
GOOSE_MIGRATION_DIR=./schema

init:
	docker run --name testdb -e POSTGRES_PASSWORD=1234 -e POSTGRES_HOST_AUTH_METHOD=trust -p 5432:5432 -d postgres
	goose -dir ${GOOSE_MIGRATION_DIR} ${GOOSE_DRIVER} ${GOOSE_DBSTRING} ${GOOSE_MIGRATION_DIR } up


test:
	
	docker start testdb
	
	go run ./cmd/.

build:
	docker-compose build

initUp: 
	docker-compose build
	@echo "starting docker container"
	docker-compose up -d
	@echo "initializing database schema"
	goose -dir ${GOOSE_MIGRATION_DIR} ${GOOSE_DRIVER} ${GOOSE_DBSTRING} ${GOOSE_MIGRATION_DIR } up
	@echo "initialization finished"
	docker-compose down

up:
	docker-compose up -d

down:
	docker-compose down

startPsql: 
	docker exec -ti ${DB_CONTAINER} psql -U ${DB_USER}

migrateup:
	@echo "migrating up"
	goose -dir ${GOOSE_MIGRATION_DIR} ${GOOSE_DRIVER} ${GOOSE_DBSTRING} ${GOOSE_MIGRATION_DIR } up
	@echo "migrating finished"

migratedown:
	@echo "migrating down"
	goose -dir ${GOOSE_MIGRATION_DIR} ${GOOSE_DRIVER} ${GOOSE_DBSTRING} ${GOOSE_MIGRATION_DIR } down
	@echo "migrating finished"