#
# Helper Makefile
cmdphp = bin/*
PHP ?= `which php`

PEAR = ./bin/pear
DBNAME=schaufelberger
PROJECT=schaufelberger2019
SERVER=exit0.net

dump:
	@echo "Dump table structure"
	@mysqldump --no-data $(DBNAME) | head -n -1 >doc/table.sql
	@echo "Dump primary data"
	@mysqldump --ignore-table=$(DBNAME).wbpageview --ignore-table=$(DBNAME).wbsohocoinprice --ignore-table=$(DBNAME).wbsessionview --ignore-table=$(DBNAME).wbvfsfileview $(DBNAME) | head -n -1 >doc/dump.sql

dumpstat:
	@echo "Dump statistic data"
	@mysqldump $(DBNAME) wbsohocoinprice wbpageview wbsessionview wbvfsfileview | head -n -1 >doc/dumpstat.sql

deploy:
	@echo "********************************************************************************"
	git pull
	make flushcache
	@echo "********************************************************************************"

install: dirs perms

dirs:
	mkdir -p var/tmp
	mkdir -p var/cache
	mkdir -p var/cache/sheet
	mkdir -p var/log
	mkdir -p var/spool
	mkdir -p var/lang
	mkdir -p var/valueace
	mkdir -p var/archive/invoice

perms:
	chmod -R go+w var/vfs
	chmod -R go+w var/tmp
	chmod -R go+w var/tmp
	chmod -R go+w var/cache
	chmod -R go+w var/log
	chmod -R go+w var/spool
	chmod -R go+w var/lang
	chmod -R go+w var/archive
	chmod -R go+w var/valueace

flushcache:
	rm -rf var/cache/css
	rm -rf var/cache/javascript
	rm -rf var/cache/general
	rm -rf var/cache/template
	rm -rf var/tmp/*
	rm -rf var/cache/sheet/*

rsync:
	#rsync -v $(SERVER):www/$(PROJECT)/doc/dump\*.sql $(SERVER):www/$(PROJECT)/doc/table.sql doc/
	rsync --delete -av $(SERVER):www/$(PROJECT)/var/vfs var/
	rsync --delete -av $(SERVER):www/$(PROJECT)/var/valueace var/
	rsync --delete -av $(SERVER):www/$(PROJECT)/var/archive var/