Makefile

# Easily setup the development environment by running make <command name>
postgres:
	docker run --name voxpopuli_postgres -p 5432:5432 -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=root -d postgres:17-alpine
createdb:
	docker exec -it voxpopuli_postgres createdb --username=postgres --owner=postgres voxpopuli
dropdb:
	docker exec -it voxpopuli_postgres dropdb --username=postgres voxpopuli
migrate-up:
	goose -dir internal/db/migrations postgres "postgres://postgres:root@localhost:5432/voxpopuli" up
migrate-down:
	goose -dir internal/db/migrations postgres "postgres://postgres:root@localhost:5432/voxpopuli" down

create-migration:
ifdef migration_name
	goose -dir internal/db/migrations postgres "postgres://postgres:root@localhost:5432/voxpopuli" create $(migration_name)
else
	@echo "Please provide a migration_name argument, e.g., make create-migration migration_name=bug_report"
endif
	
sqlc-gen:
	sqlc generate

server:
	go run cmd/main.go

.PHONY: postgres dropdb createdb migrate-up migrate-down create-migration sqlc-gen server