Makefile

# ======================
# Project and Main Files
# ======================

NAME = FastAPI-CRUD
include .env
export
SHELL := /bin/bash
.DEFAULT_GOAL = all

# ======================
# Migrations
# ======================

M ?= "init"

migrations-create:
	@docker compose exec backend alembic revision --autogenerate -m "$(M)"
	@echo "✅ Database migrations created successfully.";

migrations-up:
	@docker compose exec backend alembic upgrade head
	@echo "✅ Database migrations updated successfully.";

# ======================
# Database Tests
# ======================

wait-db:
	@echo "⏳ Waiting for database..."
	@until docker compose exec db pg_isready -U admin > /dev/null 2>&1; do \
		sleep 1; \
	done
	@echo "✅ DB is ready"

test-db:
	@docker compose exec backend python scripts/test_db.py

seed:
	@docker compose exec backend python scripts/seed.py

TABLE = tasks

db-clean:
	docker compose exec db psql -U admin -d todo_db -c \
	"TRUNCATE TABLE $(TABLE) RESTART IDENTITY CASCADE;"

query-tables:
	@docker compose exec db psql -U admin -d todo_db -c "\dt"

query-data:
	@docker compose exec db psql -U admin -d todo_db -c \
	"SELECT * FROM $(TABLE) LIMIT 5;"

# ======================
# Python Cache Cleanup
# ======================

rm-pycache:
	@echo "🛠️ Removing Python cache files..."
	@sudo find . -type d -name "__pycache__" -exec rm -rf {} +
	@sudo find . -type f -name "*.pyc" -delete
	@echo "✅ Python cache cleaned."

# ======================
# Rules
# ======================

all:  up wait-db test-db migrations-up

up:
	@docker compose up -d --build --wait
	@echo "✅ $(NAME) is running at http://localhost:8000";

down:
	@docker compose down
	@echo "✅ $(NAME) has been stopped.";

clean:
	@docker compose down --rmi local --remove-orphans
	@echo "✅ $(NAME) has been cleaned.";

fclean:
	@docker compose down --rmi local --volumes --remove-orphans
	@${MAKE} --no-print-directory rm-pycache
	@echo "✅ $(NAME) has been deep cleaned.";

.PHONY: migrations-create migrations-up wait-db test-db seed db-clean \
query-tables query-data rm-pycache all up down clean fclean