Makefile

postgres:
	docker run --name postgres13 -p 5432:5432 -e POSTGRES_USER=root -e POSTGRES_PASSWORD=secret -d postgres:13-alpine 

createdb:	
	docker exec -it postgres13 createdb --username=root --owner=root upcoming_mobiles
dropdb:
	docker exec -it postgres13 dropdb upcoming_mobiles
migrateup:
	migrate -path db/migration -database "postgresql://root:secret@localhost:5432/upcoming_mobiles?sslmode=disable" -verbose up
migratedown:
	migrate -path db/migration -database "postgresql://root:secret@localhost:5432/upcoming_mobiles?sslmode=disable" -verbose down


createtestdb:
	docker exec -it postgres13 createdb --username=root --owner=root upcoming_mobiles_test
droptestdb:
	docker exec -it postgres13 dropdb upcoming_mobiles_test
migratetestup:
	migrate -path db/migration -database "postgresql://root:secret@localhost:5432/upcoming_mobiles_test?sslmode=disable" -verbose up
migratedownup:
	migrate -path db/migration -database "postgresql://root:secret@localhost:5432/upcoming_mobiles_test?sslmode=disable" -verbose down
testdbup:
	make createtestdb; \
	make migratetestup


dockersql:
	docker exec -it postgres13 psql -U root -d upcoming_mobiles
sqlcgenerate:
	sqlc generate
sqlccompile:
	sqlc compile
sqlcinit:
	sqlc init -f sqlc.yaml
test:
	go test -v -cover ./...
server:
	go run main.go
.PHONY: createdb dropdb postgres migratedown migrateup sqlccompile sqlcgenerate sqlcinit server droptestdb createtestdb droptestdb migratetestup migratedownup testdbup