help:
	@echo "help\t- Print this message"
	@echo "deploy\t- Used by Continuous Integration worker to deploy into server"

deploy: simplemaps_worldcities_basic.db
	-sudo systemctl stop furmeet-geoquery.service
	@echo "Serving"
	-sudo rm -rf /var/www/furmeet-geoquery
	-sudo mkdir -p /var/www/furmeet-geoquery
	-sudo cp -R ./backend_code/. /var/www/furmeet-geoquery/.
	-sudo install simplemaps_worldcities_basic.db /var/www/furmeet-geoquery
	-sudo install simplemaps_worldcities_basic.json /var/www/furmeet-geoquery
	-sudo install simplemaps_worldcities_basic_names.json /var/www/furmeet-geoquery
	-sudo cp simplemaps_worldcities_basic.json /var/www/furmeet-geoquery/cached/fulldata.json
	-sudo cp simplemaps_worldcities_basic_names.json /var/www/furmeet-geoquery/cached/autocomplete.json
	-cd /var/www/furmeet-geoquery/cached; sudo gzip -rk9 .
	-sudo rm /etc/nginx/sites-available/geoquery-furmeet-app-http.conf
	sudo install ./nginx_config/geoquery-furmeet-app-http.conf /etc/nginx/sites-available
	sudo systemctl reload nginx.service
	@echo "Configuration"
	cd /var/www/furmeet-geoquery; sudo chown http:http -R .
	sudo make -C /var/www/furmeet-geoquery all
	@echo "Application"
	-sudo rm /etc/systemd/system/furmeet-geoquery.service
	-sudo install ./nginx_config/furmeet-geoquery.service /etc/systemd/system
	sudo systemctl daemon-reload
	cd /var/www/furmeet-geoquery; sudo chown http:http -R .
	sudo systemctl enable furmeet-geoquery.service
	sudo systemctl restart furmeet-geoquery.service

simplemaps_worldcities_basic.db: simplemaps_worldcities_basic.csv
	python3 makeDb.py

simplemaps_worldcities_basic.csv: simplemaps_worldcities_basic.zip
	unzip -Z -1 simplemaps_worldcities_basic.zip | egrep "\.csv$$" > csvfilename
	xargs -i unzip -p simplemaps_worldcities_basic.zip {} > simplemaps_worldcities_basic.csv < csvfilename
	rm csvfilename

simplemaps_worldcities_basic.zip:
	echo -n "https://simplemaps.com" > simplemaps_worldcities_basic.txt
	curl -s "https://simplemaps.com/data/world-cities" | grep href | grep "\.zip" | sed -re 's/^.*(href="[^"]+).*$$/\1/mg' | cut -c 7- >> simplemaps_worldcities_basic.txt
	xargs -i curl -s '{}' -o simplemaps_worldcities_basic.zip < simplemaps_worldcities_basic.txt
	rm simplemaps_worldcities_basic.txt