.PHONY: backup
##OWNER_USER ?= webadmin
##OWNER_GROUP ?= webadmin
## Project dir
DIR ?= /home/zottau/projects/zhriza/env/
#DIR ?= /srv/projects/env1/
#PD ?= $(DIR)golos_veri_admin
BP ?= backups/fixtures
BPDB ?= backups/databases
BPMD ?= backups/media
MANAGE ?= ./manage.py
SOURCE ?= .
#ENV ?= $(SOURCE) $(DIR)bin/activate && $(MANAGE)
ENV ?= $(MANAGE)
DATE ?= `date '+%Y%m%d%H%M%S'`
#FRESH_DIR ?= `ls -lt | head -2 | tail -1 | awk '{print $9}'`
#FRESH_DIR ?= `ls -lts | grep drwx | awk '{print "/$10"}'`
FRESH_DIR ?= `ls -lt $(BP)/ | grep drwx | head -1 | tr ' ' '\n' | tail -1`


default: help

#backup: dump gzip clean-backup

#clean:
#	@find . -name '*.pyc' -exec rm --force {} +
#	@find . -name '*.pyo' -exec rm --force {} +
#	@find . -name '*~' -exec rm --force {} +
#	@find . -name '__pycache__' -exec rm -r --force {} +

#clean-backup:
#	@echo "Clean dir"...
#	@rm $(PD)/$(BP)/db_fixtures.*
#	@rm $(PD)/$(BP)/db.sqlite3_20210426_OLD.*

collect:
#	@cd $(PD)/; mkdir -p media
	@yes yes | $(ENV) collectstatic --no-input

createapp:
	@echo "Usage: make createapp ARGS='param'"
	mkdir -p apps/$(ARGS) ;./manage.py startapp $(ARGS) apps/$(ARGS)
	@echo "Application '$(ARGS)' will be created and has been located in 'apps/$(ARGS)' directory"

dump-all:
	@echo "Fixtures dumping done..."
	@$(ENV) dumpdata --natural-foreign --indent 4 --exclude auth.permission --exclude contenttypes > $(BP)/$(DATE)/_all.`date +%Y%m%d%H%M%S`.json

dump: \
	dump-init \
	backup-db-postgresql \
	dump--admin-logentry \
	dump--auth-permissions \
	dump--auth-user \
	dump--auth-group \
	dump--contenttypes \
	dump--sessions-session \
	dump--sites \
	dump--easy_thumbnails \
	dump--filer \
	dump--account \
	dump--blog \
	dump--employee \
	dump--feedback \
	dump--finances \
	dump--homepage \
	dump--menu \
	dump--newsletter \
	dump--pages \
	dump--search \
	dump--settings \
	dump--socialaccount \
	dump--user_profile
	@echo "Done. Fixtures dumped successful."
#	backup-db-sqlite \

#	@$(ENV) dumpdata --natural-foreign --indent 4 --exclude auth.permission --exclude contenttypes > $(BP)/_all.`date +%Y%m%d%H%M%S`.json

dump-init:
	@mkdir -p $(BP)
	@mkdir -p $(BP)/$(DATE)

backup-db-sqlite:
	@cp db.sqlite3 $(BPDB)/db.sqlite3.`date +%Y%m%d%H%M%S`
	@echo "Backing up db.sqlite"

backup-db-postgresql:
	@echo "Please, use the first password of placed here..."
	@echo `cat project/settings.py | grep 'PASSWORD' | head -1 | awk '{print $2}'`
	@pg_dump -h localhost -U zhriza_user -Fc db_zhriza > $(BPDB)/backup_db_psql_`date +%Y%m%d%H%M%S`.sql
	@echo "Backing up the PostgreSQL database"

backup-media:
	@echo "Backing up media and static files"
	@mkdir -p $(BPMD)
	@tar cJvf $(BPMD)/media_and_static_files_$(DATE).tar.xz media/ static/ static_files/

# TODO: Add all new apps to dump/load commands
dump--admin-logentry:
	@$(ENV) dumpdata admin.logentry --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/admin.logentry.`date +%Y%m%d%H%M%S`.json
	@echo "- admin.logentry"

dump--auth-permissions:
	@$(ENV) dumpdata auth.permission --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/auth.permission.`date +%Y%m%d%H%M%S`.json
	@echo "- auth.permission"

dump--auth-user:
	@$(ENV) dumpdata auth.user --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/auth.user.`date +%Y%m%d%H%M%S`.json
	@echo "- auth.user"

dump--auth-group:
	@$(ENV) dumpdata auth.group --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/auth.group.`date +%Y%m%d%H%M%S`.json
	@echo "- auth.group"

dump--contenttypes:
	@$(ENV) dumpdata contenttypes --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/contenttypes.`date +%Y%m%d%H%M%S`.json
	@echo "- contenttypes"

dump--sessions-session:
	@$(ENV) dumpdata sessions.session --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/sessions.session.`date +%Y%m%d%H%M%S`.json
	@echo "- sessions.session"

dump--sites:
	@$(ENV) dumpdata sites --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/sites.`date +%Y%m%d%H%M%S`.json
	@echo "- sites"

#2020.10.29 +account, +admin, +auth, +contenttypes, +employee, +feedback, +homepage, +newsletter, +sessions, +sites, +socialaccount
#2021.04.22 +easy_thumbnails, +filer, +menu, +pages, +settings

dump--easy_thumbnails:
	@$(ENV) dumpdata easy_thumbnails --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/easy_thumbnails.`date +%Y%m%d%H%M%S`.json
	@echo "- easy_thumbnails"

dump--filer:
	@$(ENV) dumpdata filer --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/filer.`date +%Y%m%d%H%M%S`.json
	@echo "- filer"


dump--account:
	@$(ENV) dumpdata account --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/account.`date +%Y%m%d%H%M%S`.json
	@echo "- account"

dump--blog:
	@$(ENV) dumpdata blog --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/blog.`date +%Y%m%d%H%M%S`.json
	@echo "- blog"

dump--employee:
	@$(ENV) dumpdata employee --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/employee.`date +%Y%m%d%H%M%S`.json
	@echo "- employee"

dump--feedback:
	@$(ENV) dumpdata feedback --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/feedback.`date +%Y%m%d%H%M%S`.json
	@echo "- feedback"

dump--finances:
	@$(ENV) dumpdata finances --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/finances.`date +%Y%m%d%H%M%S`.json
	@echo "- finances"

dump--homepage:
	@$(ENV) dumpdata homepage --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/homepage.`date +%Y%m%d%H%M%S`.json
	@echo "- homepage"

dump--menu:
	@$(ENV) dumpdata menu --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/menu.`date +%Y%m%d%H%M%S`.json
	@echo "- menu"

dump--newsletter:
	@$(ENV) dumpdata newsletter --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/newsletter.`date +%Y%m%d%H%M%S`.json
	@echo "- newsletter"

dump--pages:
	@$(ENV) dumpdata pages --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/pages.`date +%Y%m%d%H%M%S`.json
	@echo "- pages"

dump--search:
	@$(ENV) dumpdata search --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/search.`date +%Y%m%d%H%M%S`.json
	@echo "- search"

dump--settings:
	@$(ENV) dumpdata settings --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/settings.`date +%Y%m%d%H%M%S`.json
	@echo "- settings"

dump--socialaccount:
	@$(ENV) dumpdata socialaccount --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/socialaccount.`date +%Y%m%d%H%M%S`.json
	@echo "- socialaccount"

dump--user_profile:
	@$(ENV) dumpdata user_profile --natural-foreign --indent 4 > $(BP)/$(FRESH_DIR)/user_profile.`date +%Y%m%d%H%M%S`.json
	@echo "- user_profile"


#fix:
#	chown $(OWNER_USER):$(OWNER_GROUP) -R $(PD)/*
#	chown $(OWNER_USER):$(OWNER_GROUP) -R $(PD)/.*

#gzip:
#	@echo "GZipping files..."
#	@tar czvfP $(PD)/$(BP)/backup_fixtures_`date +%Y%m%d%H%M%S`.tar.gz $(PD)/$(BP)/db_fixtures.*
#	@tar czvfP $(PD)/$(BP)/backup_db_`date +%Y%m%d%H%M%S`.tar.gz $(PD)/$(BP)/db.sqlite3_20210426_OLD.*

#load: load-auth-permission load-auth-user load-content-about load-content-airs load-content-announces load-content-author load-content-contacts load-content-friends load-content-storage load-posts-category load-posts-posts load-sessions-session

migrate:
	@$(ENV) migrate

load-all:
	@echo "Loading fixtures..."
	$(ENV) loaddata $(BP)/$(DATE)/_all.*.json
	@echo "Done. Fixtures has been loaded successfully."

load: \
	load-init \
	migrate \
	load--sites \
	load--search \
	load--feedback \
	load--finances \
	load--homepage \
	load--newsletter \
	load--pages \
	load--settings \
	load--auth-group \
	load--auth-user \
	load--user_profile \
	load--employee \
	load--blog \
	load--menu \
	load--sessions-session \
	load--account \
	load--auth-permissions

	@# load--admin-logentry \

	@# Zeroed fixtures

	@#load--filer \

	@#load--easy_thumbnails \

	@#load--socialaccount \

	@echo "Done. Fixtures has been loaded successfully."

test-dirs:
	@echo "test dirs"
	@#`ls -lt | head -2 | tail -1 | awk '{print $9}'`
	@ls -lt $(BP)/ | grep drwx | head -1 | tr ' ' '\n' | tail -1
	@#cd backups/fixtures; ls ${FRESH_DIR}

load-init:
	@echo "Load fixtures initialization..."

restore-db-postgresql:
	@echo "Restore the PostrgeSQL database backup from dump saved earlier."
	@# Don't forget create database: =# CREATE DATABASE db_zhriza WITH ENCODING='UTF-8';
	@#Manual: psql db_zhriza < $(BP)/`ls backups/backup_db_psql_*.sql | tail -1`
	@pg_restore -d db_zhriza $(BP)/`ls backups/backup_db_psql_*.sql | tail -1`

load--admin-logentry:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/admin.logentry.*.json
	@echo "- admin.logentry"

load--auth-permissions:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/auth.permission.*.json
	@echo "- auth.permission"

load--auth-user:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/auth.user.*.json
	@echo "- auth.user"

load--auth-group:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/auth.group.*.json
	@echo "- auth.group"

load--contenttypes:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/contenttypes.*.json
	@echo "- contenttypes"

load--sessions-session:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/sessions.session.*.json
	@echo "- sessions.session"

load--sites:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/sites.*.json
	@echo "- sites"

load--easy_thumbnails:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/easy_thumbnails.*.json
	@echo "- easy_thumbnails"

load--filer:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/filer.*.json
	@echo "- filer"

load--account:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/account.*.json
	@echo "- account"

load--blog:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/blog.*.json
	@echo "- blog"

load--employee:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/employee.*.json
	@echo "- employee"

load--feedback:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/feedback.*.json
	@echo "- feedback"

load--finances:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/finances.*.json
	@echo "- finances"

load--homepage:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/homepage.*.json
	@echo "- homepage"

load--menu:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/menu.*.json
	@echo "- menu"

load--newsletter:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/newsletter.*.json
	@echo "- newsletter"

load--pages:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/pages.*.json
	@echo "- pages"

load--search:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/search.*.json
	@echo "- search"

load--settings:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/settings.*.json
	@echo "- settings"

load--socialaccount:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/socialaccount.*.json
	@echo "- socialaccount"

load--user_profile:
	@$(ENV) loaddata $(BP)/$(FRESH_DIR)/user_profile.*.json
	@echo "- user_profile"


npm: npm_build npm_dev collect npm_dev_watch

npm_all:
	cd frontend/; npm run build && npm run dev

npm_dev:
	cd frontend/; npm run dev

npm_dev_watch:
	cd frontend/; npm run dev_watch

npm_build:
	cd frontend/; npm run build

npm_build_stats:
	cd frontend/; npm run build_stats


freeze-requirements:
	@echo "Freezing requirements..."
	@mkdir -p requirements/
	python3 -m pip freeze > ./requirements/freeze_$(DATE).txt


#run:
#	$(ENV) runserver 0.0.0.0:7777

help:
	@echo ""
	@echo "Commands:"
	@echo "------------------------------------------------------"
	@echo " help         -- This help page"
	@echo " backup-media -- Backup media and static files"
#	@echo " backup       -- Create db and static files backup"
#	@echo " clean        -- Clean pyc, pyo files"
	@echo " collect      -- Django collect static files"
	@echo " dump         -- Django dump all data to fixtures"
#	@echo " gzip         -- Archive all backups files"
#	@echo " fix          -- Reset file restrictions"
	@echo " load         -- Django load custom set of data from fixtures"
	@echo " load-all     -- Django load all data set from fixtures"
	@echo " npm          -- Run NPM commands"
#	@echo " run          -- Django runserver +args"
	@echo " createapp    -- Django create application. Usage: make createapp ARGS='param' "
	@echo " freeze-requirements -- Django freeze PIP requirements"
	@echo " "
	@echo "------------------------------------------------------"