NAMEDATABASE = test
USERDATABASE = postgres


FILEPATCHED = BackUpPatched.sql
FILELOG = RestoreLog.log




all: dropdatabase createdatabse restorefrombackup
dropdatabase: 
	echo "drop database"
	$(shell dropdb $(NAMEDATABASE) -U $(USERDATABASE)) 
createdatabse:
	echo "create database"
	$(shell createdb -T template0 $(NAMEDATABASE) -U $(USERDATABASE))

restorefrombackup:
	echo "restore"
	$(shell psql -o $(FILELOG) -d $(NAMEDATABASE) -f $(FILEPATCHED) -U $(USERDATABASE))
	echo "end"