dashdotdb/Makefile.devhelpers at master · app-sre/dashdotdb · 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
DATABASE_URL ?= postgresql://postgres:[email protected]:5432/postgres
FLASK_APP ?= dashdotdb
DASHDOTDB_DATABASE_CONTAINER_NAME ?= dashdot-postgres
DASHDOTDB_FLASK_PORT ?= 8080

.PHONY: venv-init
venv-init:
	uv sync --group check

.PHONY: run-service
run-service:
	@if [[ "xDarwin" == "x$(UNAME_S)" ]]; then \
		export LDFLAGS=$(LDFLAGS) ;\
	fi && \
	FLASK_APP=$(FLASK_APP) DASHDOTDB_DATABASE_URL=$(DATABASE_URL) \
	uv run $(__UV_USE_ISOLATED) \
	--quiet                     \
	--frozen                    \
	--group dev                 \
	$(IGNORE_UV_CACHE_FLAG)     \
		flask run                 \
			--debugger              \
			--port $(DASHDOTDB_FLASK_PORT)

db-down:
	$(CONTAINER_ENGINE) rm -f $(DASHDOTDB_DATABASE_CONTAINER_NAME)

db-up:
	@$(CONTAINER_ENGINE) run                      \
		-d                                          \
		--name $(DASHDOTDB_DATABASE_CONTAINER_NAME) \
		--rm                                        \
		-it                                         \
		-p 5432:5432                                \
		-e POSTGRES_PASSWORD=postgres               \
			postgres &&                               \
			sleep 2

db-capture:
	@if [[ "xDarwin" == "x$(UNAME_S)" ]]; then \
		export LDFLAGS=$(LDFLAGS) ;\
	fi && \
	FLASK_APP=$(FLASK_APP) DASHDOTDB_DATABASE_URL=$(DATABASE_URL) \
	uv run $(__UV_USE_ISOLATED) \
	--quiet                     \
	--frozen                    \
	--group dev                 \
	$(IGNORE_UV_CACHE_FLAG)     \
		flask db migrate

db-init:
	@if [[ "xDarwin" == "x$(UNAME_S)" ]]; then \
		export LDFLAGS=$(LDFLAGS) ;\
	fi && \
	FLASK_APP=$(FLASK_APP) DASHDOTDB_DATABASE_URL=$(DATABASE_URL) \
	uv run $(__UV_USE_ISOLATED) \
	--quiet                     \
	--frozen                    \
	--group dev                 \
		$(IGNORE_UV_CACHE_FLAG)     \
		flask db upgrade

db-status:
	\@$(CONTAINER_ENGINE) inspect \
		--format "$(DASHDOTDB_DATABASE_CONTAINER_NAME): {{.State.Status}}" \
		$(DASHDOTDB_DATABASE_CONTAINER_NAME) 2>/dev/null || echo "$(DASHDOTDB_DATABASE_CONTAINER_NAME): not-running"

db: db-down db-up db-init db-capture db-init

.PHONY: db db-down db-up db-init db-capture db-init db-status
.PHONY: dddb-query-imv dddb-query-dv dddb-metrics

dddb-query-imv:
	curl "localhost:$(DASHDOTDB_FLASK_PORT)/api/v1/imagemanifestvuln?cluster=app-sre-prod-01&namespace=cso"

dddb-query-dv:
	curl "localhost:$(DASHDOTDB_FLASK_PORT)/api/v1/deploymentvalidation?cluster=app-sre-prod-01&namespace=app-interface-stage"

dddb-metrics:
	@for metricsrc in imagemanifestvuln deploymentvalidation serviceslometrics; do \
		curl "localhost:$(DASHDOTDB_FLASK_PORT)/api/v1/$${metricsrc}/metrics" ;\
	done