66 lines
2.1 KiB
Makefile
66 lines
2.1 KiB
Makefile
SHELL := /bin/bash
|
|
UV := uv
|
|
PYTHON_VERSION := 3.11
|
|
|
|
.PHONY: up down airflow-init logs gp-psql ddl-gp \
|
|
bookings-clone-demodb bookings-init bookings-psql bookings-generate-day \
|
|
dev-setup dev-sync dev-lock test lint fmt clean-venv
|
|
|
|
up:
|
|
docker compose -f docker-compose.yml up -d
|
|
|
|
down:
|
|
docker compose -f docker-compose.yml down -v
|
|
|
|
airflow-init:
|
|
docker compose -f docker-compose.yml run --rm airflow-init
|
|
|
|
logs:
|
|
docker compose -f docker-compose.yml logs -f airflow-webserver airflow-scheduler
|
|
|
|
gp-psql:
|
|
docker compose -f docker-compose.yml exec greenplum bash -c "su - gpadmin -c '/usr/local/greenplum-db/bin/psql -p 5432 -d gpadmin'"
|
|
|
|
ddl-gp:
|
|
docker compose -f docker-compose.yml exec greenplum bash -c "su - gpadmin -c '/usr/local/greenplum-db/bin/psql -d gpadmin -f /sql/ddl_gp.sql'"
|
|
|
|
bookings-clone-demodb:
|
|
mkdir -p bookings
|
|
test -d bookings/demodb || git clone --depth 1 https://github.com/postgrespro/demodb.git bookings/demodb
|
|
|
|
bookings-init: bookings-clone-demodb
|
|
docker compose -f docker-compose.yml up -d bookings-db
|
|
docker compose -f docker-compose.yml exec bookings-db bash -lc 'cd /bookings/demodb && PGPASSWORD="$$POSTGRES_PASSWORD" psql -v ON_ERROR_STOP=1 -U "$$POSTGRES_USER" -d "$$POSTGRES_DB" -f install.sql'
|
|
|
|
bookings-psql:
|
|
docker compose -f docker-compose.yml exec bookings-db bash -lc 'PGPASSWORD="$$POSTGRES_PASSWORD" psql -U "$$POSTGRES_USER" -d demo'
|
|
|
|
bookings-generate-day:
|
|
docker compose -f docker-compose.yml up -d bookings-db
|
|
docker compose -f docker-compose.yml exec bookings-db bash -lc 'PGPASSWORD="$$POSTGRES_PASSWORD" psql -v ON_ERROR_STOP=1 -U "$$POSTGRES_USER" -d demo -v start_date="$${BOOKINGS_START_DATE:-2017-01-01}" -f /bookings/generate_next_day.sql'
|
|
|
|
dev-setup:
|
|
$(UV) python install $(PYTHON_VERSION)
|
|
$(UV) python pin $(PYTHON_VERSION)
|
|
$(UV) sync
|
|
|
|
dev-sync:
|
|
$(UV) sync
|
|
|
|
dev-lock:
|
|
$(UV) lock --upgrade
|
|
|
|
test:
|
|
$(UV) run pytest -q
|
|
|
|
lint:
|
|
$(UV) run black --check airflow tests
|
|
$(UV) run isort --check-only airflow tests
|
|
|
|
fmt:
|
|
$(UV) run black airflow tests
|
|
$(UV) run isort airflow tests
|
|
|
|
clean-venv:
|
|
python -c "import shutil; shutil.rmtree('.venv', ignore_errors=True)"
|