makefile

###### Docker Compose Commands
## We use these since there is a production profile and without specifying the profile
## docker will not start those services. This can be a footgun

prodUp:
	docker compose --profile production up -d

prodBuild:
	docker compose --profile production build

prodDown:
	docker compose --profile production down

####### Helper Commands

# start the reverse proxy which gives our server https and points to the proper domain
caddy:
	cp ./Caddyfile /etc/caddy/Caddyfile
	sudo systemctl restart caddy

# get rid of the sensorthings db, mainly for testing purposes
# or if you need to recrawl. NOTE that you may need to reapply the indices after
wipedb:
	docker volume rm oregonwaterdataportal-etl_postgis_volume

# run tests on the dagster pipeline. NOTE: this will clear the db and start fresh
test:
	pytest -vv -x

# install uv for python package management
uv:
# uv is a python version manager and venv manager that we use because of the fact that dagster is pinned to specific
# python versions and is not trivial to manage. 
	wget -qO- https://astral.sh/uv/install.sh | sh

# install requirements needed to run dagster
build:
# make sure you are in a new shell env after installing uv
	uv python install 3.12
	uv sync 
	source .venv/bin/activate

# Check which indices are present on the observations table
indexCheck:
	docker exec -t owdp-database psql -U sensorthings -d sensorthings -c "SELECT indexname FROM pg_indexes WHERE tablename = 'OBSERVATIONS'"

# Send a sample log message to the frost server log output
# this should trigger the slow query log and is mainly just for testing
mimicSlowLog:
	docker exec owdp-frost sh -c "echo 'Slow Query 200000000000' > /proc/1/fd/1"