Makefile

postgres:
	docker run --name kinma-postgres -p 5432:5432 -e POSTGRES_USER=root -e POSTGRES_PASSWORD=password -d postgres:14-alpine

createdb:
	docker exec -it kinma-postgres createdb --username=root --owner=root kinma_db

dropdb:
	docker exec -it kinma-postgres dropdb kinma_db

migrateup:
	migrate -path db/migration -database "postgresql://root:password@localhost:5432/kinma_db?sslmode=disable" -verbose up

migrateup1:
	migrate -path db/migration -database "postgresql://root:password@localhost:5432/kinma_db?sslmode=disable" -verbose up 1

migratedown:
	migrate -path db/migration -database "postgresql://root:password@localhost:5432/kinma_db?sslmode=disable" -verbose down

#only rollback 1 last migration
migratedown1:
	migrate -path db/migration -database "postgresql://root:password@localhost:5432/kinma_db?sslmode=disable" -verbose down 1

#forcely migrate back to the specific version
migrateforce:
	migrate -path db/migration -database "postgresql://root:password@localhost:5432/kinma_db?sslmode=disable" force 3

sqlc:
	sqlc generate

# Run test and cover all of the package by ./...
test:
	go test -v -cover ./...

server:
	go run main.go

.PHOMY: postgres createdb migrateup migrateup1 migratedown migratedown1 sqlc test server