TaimakoAI/Makefile at main · stenwire/TaimakoAI · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
# Load variables from .env file (if present)
ifneq (,$(wildcard ./.env))
    include .env
    export
endif

# Default values (fallback if .env missing or vars not set)
PROJECT_PREFIX      ?= taimako
POSTGRES_USER       ?= taimako
POSTGRES_DB         ?= taimako_db
POSTGRES_CONTAINER  ?= $(PROJECT_PREFIX)_postgres
BACKEND_CONTAINER   ?= $(PROJECT_PREFIX)_backend
FRONTEND_CONTAINER  ?= $(PROJECT_PREFIX)_frontend

.PHONY: start start-d stop build logs migrate migrate-generate db-shell db-backup db-restore clean ps db-reset db-truncate logs-backend logs-frontend lint-be lint-be-fix lint-fe lint-fe-fix test-be test-be-unit test-be-api test-be-integration test-fe install-hooks setup create-admin

# Start all services (foreground)
start:
	docker-compose up

# Start in detached mode
start-d:
	docker-compose up -d

# Run all backend tests
test-be:
	cd backend && uv run pytest tests/ -v

# Run backend unit tests only
test-be-unit:
	cd backend && uv run pytest tests/unit/ -v

# Run backend API tests only
test-be-api:
	cd backend && uv run pytest tests/api/ -v

# Run backend integration tests only
test-be-integration:
	cd backend && uv run pytest tests/integration/ -v

# Stop all services
stop:
	docker-compose down

# Stop and remove volumes (CAUTION: deletes database data)
clean:
	docker-compose down -v

# Build/rebuild containers
build:
	docker-compose build

# View logs (all services)
logs:
	docker-compose logs -f

logs-backend:
	docker-compose logs -f backend

logs-frontend:
	docker-compose logs -f frontend

# Database migrations (runs inside backend container)
migrate:
	docker-compose exec backend uv run alembic upgrade head

# Generate new migration
migrate-generate:
	@read -p "Enter migration message: " msg; \
	docker-compose exec backend uv run alembic revision --autogenerate -m "$$msg"

# Access PostgreSQL shell
db-shell:
	docker-compose exec $(POSTGRES_CONTAINER) psql -U $(POSTGRES_USER) -d $(POSTGRES_DB)

# Backup database to local file
db-backup:
	@timestamp=$$(date +%Y%m%d_%H%M%S); \
	docker-compose exec $(POSTGRES_CONTAINER) pg_dump -U $(POSTGRES_USER) $(POSTGRES_DB) > backup_$${timestamp}.sql; \
	echo "Database backed up to backup_$${timestamp}.sql"

# Restore database from backup file
# Usage: make db-restore FILE=backup_20251231_120000.sql
db-restore:
	@if [ -z "$(FILE)" ]; then \
		echo "Error: Please specify backup file. Usage: make db-restore FILE=backup.sql"; \
		exit 1; \
	fi
	@if [ ! -f "$(FILE)" ]; then \
		echo "Error: File $(FILE) not found!"; \
		exit 1; \
	fi
	cat $(FILE) | docker-compose exec -T $(POSTGRES_CONTAINER) psql -U $(POSTGRES_USER) -d $(POSTGRES_DB)
	@echo "Database successfully restored from $(FILE)"

# Reset database (drop everything and recreate public schema)
db-reset:
	@echo "Resetting database to clean state (dropping all tables)..."
	docker-compose exec $(POSTGRES_CONTAINER) psql -U $(POSTGRES_USER) -d $(POSTGRES_DB) -c "\
		DROP SCHEMA public CASCADE; \
		CREATE SCHEMA public; \
		GRANT ALL ON SCHEMA public TO $(POSTGRES_USER); \
		GRANT ALL ON SCHEMA public TO public;"
	@echo "Database reset complete. Run 'make migrate' to recreate tables."

# Truncate all tables (clear data, preserve structure)
db-truncate:
	@echo "Truncating all tables (excluding alembic_version)..."
	docker-compose exec $(POSTGRES_CONTAINER) psql -U $(POSTGRES_USER) -d $(POSTGRES_DB) -c "\
		DO \$\$ \
		DECLARE r RECORD; \
		BEGIN \
			FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public' AND tablename != 'alembic_version') LOOP \
				EXECUTE 'TRUNCATE TABLE ' || quote_ident(r.tablename) || ' CASCADE'; \
			END LOOP; \
		END \$\$;"
	@echo "All tables truncated (data cleared, structure preserved)."

# Lint backend with ruff
lint-be:
	cd backend && uv run ruff check .

# Lint and auto-fix backend with ruff
lint-be-fix:
	cd backend && uv run ruff check . --fix

# Lint frontend with eslint
lint-fe:
	cd frontend && npm run lint

# Lint and auto-fix frontend with eslint
lint-fe-fix:
	cd frontend && npx eslint --fix .

# Run all frontend tests
test-fe:
	cd frontend && npm test

# Install git pre-commit hook
install-hooks:
	@cp scripts/pre-commit .git/hooks/pre-commit
	@chmod +x .git/hooks/pre-commit
	@echo "Pre-commit hook installed."

# One-command dev setup (dependencies + hooks)
setup: install-hooks
	@echo "Installing backend dependencies..."
	cd backend && uv sync --dev
	@echo "Installing frontend dependencies..."
	cd frontend && npm ci
	@echo "Setup complete."

# Create or promote admin user
# Promote existing user: make create-admin EMAIL=user@example.com
# Create new admin:      make create-admin EMAIL=admin@example.com PASSWORD=securepass NAME="Admin"
create-admin:
	@if [ -z "$(EMAIL)" ]; then \
		echo "Error: EMAIL is required."; \
		echo "  Promote existing user: make create-admin EMAIL=user@example.com"; \
		echo "  Create new admin:      make create-admin EMAIL=admin@example.com PASSWORD=securepass"; \
		exit 1; \
	fi
	docker-compose exec backend uv run python -m scripts.create_admin --email $(EMAIL) $(if $(PASSWORD),--password $(PASSWORD)) $(if $(NAME),--name "$(NAME)")

# Show running containers
ps:
	docker-compose ps