connect_mailstats:
	mariadb --defaults-file=./ini/.mailstats.cnf

connect_postfix:
	#mariadb --host 10.0.0.51 --port 3306 --database postfix --user postfix --password
	mariadb --defaults-file=./ini/.postfix.cnf

connect_roundcube:
	mariadb --host 10.0.0.51 --port 3306 --database roundcubemail --user roundcubemail --password

connect_session:
	mariadb --defaults-file=./ini/.session.cnf

init_mail_ost:
	mariadb --defaults-file=./ini/.postfix.cnf  <"./scripts/mail-ost.sql"

init_test:
	mariadb --defaults-file=./ini/.postfix.cnf  <"./scripts/test.sql"

get_user_accounts:
	@echo Added following users:
	mariadb --defaults-file=./ini/.postfix.cnf -e "select username from mailbox;"

get_mailstats:
	@mariadb --defaults-file=./ini/.mailstats.cnf \
		--execute "select s1.* from stats s1 inner join (select max(id) as id, user from stats group by user) s2 on s1.id = s2.id"
#    --execute "SELECT id,node,last_update,domain,user,size FROM stats GROUP BY user ORDER BY id DESC;"

#    --execute "SELECT * FROM stats ORDER BY id DESC limit 10;"
	@echo "---------------"
	@echo "\n"

get_master:
	@echo -n Current master:  
	@mariadb --defaults-file=./ini/.session.cnf \
    --silent \
    --skip-column-names \
    --execute "SELECT master FROM master ORDER BY id DESC LIMIT 1;"
	@echo "---------------"
	@echo "\n"

get_stats: get_mailstats get_session get_master


#    --execute "show tables;"
#		--execute "SELECT * FROM stats;"

get_session:
	@mariadb --defaults-file=./ini/.session.cnf \
		--execute "SELECT id, node, unix_timestamp(last_change), script_running FROM session ORDER BY id DESC LIMIT 10;"
	@echo "---------------"
	@echo "\n"
#	mariadb --host 10.0.0.51 --port 3306 --database session --user session-user --password --execute "SELECT * FROM session ORDER BY id DESC LIMIT 1;"

copy_haproxy_conf_prod:
	cat data/haproxy/haproxy-prod.cfg > data/haproxy/haproxy.cfg

copy_haproxy_conf_devl:
	cat data/haproxy/haproxy-devl.cfg > data/haproxy/haproxy.cfg

docker_init_prod: copy_haproxy_conf_prod
	docker compose build
	docker compose up database1 mailserver1 mailserver2 webmail1 webmail2 rspamd1 grafana1 -d


docker_init_devl: copy_haproxy_conf_devl 
	docker compose -f docker-compose-devl.yaml build
	docker compose -f docker-compose-devl.yaml up loadbalancer1 database1 mailserver1 mailserver2 webmail1 webmail2 rspamd1 -d

docker_restart:
	docker compose restart

docker_stop:
	docker compose stop

docker_destroy: docker_stop
	yes | docker compose rm

docker_clean_grafana:
	yes | docker compose rm grafana1
	docker image rm grafana/grafana-oss

docker_grafana:
	docker compose up grafana1

docker_delete_volume: 
	docker volume list | tail -n+2 | tr -s ' '  | cut -d' ' -f2 | xargs docker volume rm

docker_prune_system: docker_destroy docker_delete_volume
	docker system prune

docker_rebuild_prod: docker_destroy docker_delete_volume docker_init_prod

docker_rebuild_devl: docker_destroy docker_init_devl
