--- trunk/Makefile	2005/07/31 18:58:26	33
+++ trunk/Makefile	2005/08/31 20:33:58	106
@@ -1,5 +1,8 @@
 tmp=/tmp/backuppc-svn/
 target=/data/backuppc/
+profile_opt=
+profile_file=profile
+db=backuppc
 
 all:
 	@echo "make install to install BackupPC using sudo"
@@ -21,10 +24,36 @@
 	sudo $(target)/etc/backuppc stop
 
 install-etc:
-	test -d $(target)/etc || cp -r etc $(target) && chmod 755 $(target)/etc/backuppc
+	test -d $(target)/etc || sudo cp -r etc $(target) && sudo chmod 755 $(target)/etc/backuppc
+
+update:
+	sudo -u backuppc /data/backuppc/bin/BackupPC_updatedb
+
+index: test
+	sudo rm -Rf /data/backuppc/data/casket || true
+	sudo -u backuppc /data/backuppc/bin/BackupPC_updatedb -i
+
+xls:
+	sudo -u backuppc /data/backuppc/bin/BackupPC_xls_report && cp -vf /tmp/report.xls ~/public_html/
 
 asa:
 	rm -Rf $(tmp)
 	svn export . $(tmp)
 	rsync -rav $(tmp) 10.210.99.1:backuppc-svn/
 	rm -Rf $(tmp)
+
+profile: test
+	test -e tmon.out || touch tmon.out
+	sudo chown backuppc tmon.out
+	dropdb $(db) || echo "skip drop db"
+	createdb $(db)
+	date > $(profile_file)
+	echo "## NORMAL RUN" >> $(profile_file)
+	sudo -u backuppc /data/backuppc/bin/BackupPC_updatedb -c $(profile_opt) | tee -a $(profile_file)
+	echo "## DProf RUN" >> $(profile_file)
+	sudo -u backuppc perl -d:DProf /data/backuppc/bin/BackupPC_updatedb -d $(profile_opt)
+	dprofpp 2>&1 | tee -a $(profile_file)
+	echo "## DBI_PROFILE RUN" >> $(profile_file)
+	DBI_PROFILE=2 sudo -u backuppc /data/backuppc/bin/BackupPC_updatedb -d $(profile_opt) 2>&1 | tee -a $(profile_file)
+	mv $(profile_file) profile.`perl -e 'my @p = glob("profile.[0-9]*"); print scalar @p + 1'`
+