Makefile

DB_URL=postgresql://root:secret@localhost:5432/simple_bank?sslmode=disable

#-- Docker
network:
	docker network create bank-network

start_postgres:
	docker run --name postgres16 --network bank-network -p 5432:5432 -e POSTGRES_USER=root -e POSTGRES_PASSWORD=secret -d postgres

stop_postgres:
	docker stop postgres16

delete_postgres:
	docker stop postgres16 && docker rm postgres16

create_db:
	docker exec -it postgres16 createdb --username=root --owner=root simple_bank

drop_db:
	docker exec -it postgres16 dropdb simple_bank

migrate_up:  ## Apply all migrations
	migrate -path db/migration -database "$(DB_URL)" -verbose up

migrate_up_last: ## Apply last migration
	migrate -path db/migration -database "$(DB_URL)" -verbose up 1

migrate_down: ## Reverse all DB migrations
	migrate -path db/migration -database "$(DB_URL)" -verbose down -all

migrate_down_last: ## Reverse last DB migration
	migrate -path db/migration -database "$(DB_URL)" -verbose down 1

new_migration: ## generate file for migration up and down
	migrate create -ext sql -dir db/migration -seq $(name)

db_docs: ## documentation
	dbdocs build doc/db.dbml

db_schema: ## dbdoc schema
	dbml2sql --postgres -o doc/schema.sql doc/db.dbml

sqlc: ## sql to go
	sqlc generate

test: ## Launch units tests
	go test -v -cover -short ./...

server: ## start server
	go run main.go

mock: ## Generate mock
	mockgen -package mockdb -destination db/mock/store.go bitbucket.org/jessyw/go_simplebank/db/sqlc Store
	mockgen -package mockwk -destination worker/mock/store.go bitbucket.org/jessyw/go_simplebank/worker TaskDistributor

proto: ## gRPC
	rm -f pb/*.go
	rm -f doc/swagger/*.swagger.json
	protoc --proto_path=proto --go_out=pb --go_opt=paths=source_relative \
    --go-grpc_out=pb --go-grpc_opt=paths=source_relative \
	--grpc-gateway_out=pb --grpc-gateway_opt=paths=source_relative \
	--openapiv2_out=doc/swagger --openapiv2_opt=allow_merge=true,merge_file_name=go_simple_bank \
    proto/*.proto
	statik -src=./doc/swagger -dest=./doc

#-- Test gRPC server
evans:
	evans --host localhost --port 9090 -r repl

redis:
	docker run --name redis -p 6379:6379 -d redis:7.4.1-alpine

.PHONY: network start_postgres stop_postgres delete_postgres create_db drop_db migrate_up migrate_down migrate_up_last migrate_down_last new_migration db_docs db_schema sqlc test server mock proto evans redis