Makefile

all: build

build:
	go build -o ./bin/pg_gatherer --tags netcgo ./gatherer/cmd/pg_gatherer/

dashboard:
	$(MAKE) -C grafana

test_in_docker:
	# init && start database
	sudo -H -u postgres bash -l -c '/usr/pgsql-12/bin/initdb -D /tmp/db'
	sudo -H -u postgres bash -l -c '/usr/pgsql-12/bin/pg_ctl start -W -D /tmp/db'
	sleep 3
	# change preload libraries
	psql -U postgres -Atc  "alter system set shared_preload_libraries TO pg_stat_statements, timescaledb"
	sudo -H -u postgres bash -l -c '/usr/pgsql-12/bin/pg_ctl restart -W -D /tmp/db'
	sleep 3
	# create user && database
	psql -U postgres -Atc "create user gatherer"
	psql -U postgres -Atc "create database gatherer owner gatherer"
	psql -U postgres -Atc "grant pg_monitor to gatherer"
	psql -U postgres -Atc "create database nobuffercache"
	# install extensions
	psql -U postgres -d gatherer -Atc "create extension pg_buffercache"
	psql -U postgres -d gatherer -Atc "create extension pg_stat_statements"
	psql -U postgres -d postgres -Atc "create extension pg_buffercache"
	psql -U postgres -d postgres -Atc "create extension pg_stat_statements"
	psql -U postgres -d gatherer -Atc "create extension timescaledb"
	# update statistics
	/usr/pgsql-12/bin/pgbench -U postgres -h /tmp -i -s 2 postgres
	/usr/pgsql-12/bin/pgbench -U postgres -h /tmp -i -s 2 gatherer
	/usr/pgsql-12/bin/pgbench -U postgres -h /tmp -T 5 postgres
	/usr/pgsql-12/bin/pgbench -U postgres -h /tmp -T 5 gatherer
	/usr/pgsql-12/bin/vacuumdb --analyze-only -U postgres -h /tmp --all
	# deploy schema gatherer
	psql -U gatherer -At -1 -f ./schema/schema.sql -d gatherer
	# start tests
	psql -U postgres -d gatherer -Atc "insert into host (name) values ('hostname-not-found-healthcheck-must-failed');"
	psql -U postgres -d postgres -Atc "select pg_create_physical_replication_slot('standby_slot')"
	timeout 10 /usr/pgsql-12/bin/pg_receivewal -h /tmp -U postgres -D /tmp/ -S standby_slot || echo ok
	go test -v -race ./...
	go build -o ./bin/testing --tags netcgo ./gatherer/cmd/testing/
	./bin/testing --plugin-dir ./plugins --cache-dir /tmp/cache --host /tmp --dbname gatherer --username gatherer

.DEFAULT_GOAL: all