X-Git-Url: http://matita.cs.unibo.it/gitweb/?a=blobdiff_plain;f=helm%2Fmetadata%2FMakefile;h=1485dfdbfef49b9e97b2e7803d791dc8ef2709ec;hb=97c2d258a5c524eb5c4b85208899d80751a2c82f;hp=3b6b9b08e22dafd483e8c041d6d053c90469399e;hpb=543467755945c45e36f27eac25e0a82a873430b4;p=helm.git

diff --git a/helm/metadata/Makefile b/helm/metadata/Makefile
index 3b6b9b08e..1485dfdbf 100644
--- a/helm/metadata/Makefile
+++ b/helm/metadata/Makefile
@@ -1,17 +1,40 @@
 FILLDB=fill_db.sql
+INDUCTIVETYPES=inductive_types.txt
+CONSTANTSANDVARIABLES=constants_and_variables.txt
+ALLOBJECTS=all_objects.txt
+GETTERURL=http://mowgli.cs.unibo.it:58081
+DBCOMM=mysql -pbjIcRpru -u helmadmin mowgli
+#DBCOMM=psql -q -U helm mowgli2
 
 all:
+	@echo "try one of:"
+	@echo "  make indexes"
+	@echo "  make drop_tables"
+	@echo "  make create_tables"
+	@echo "  make $(FILLDB)"
+	@echo "  make fill_db"
+
+$(FILLDB):
 	rm -f $(FILLDB)
-	time for i in `cat tipi_induttivi.txt` ; do (cd tmp ; wget -t 1 -O downloaded.xml.gz "http://mowgli.cs.unibo.it:58081/getxml?format=gz&uri=$$i") ; zcat tmp/downloaded.xml.gz > tmp/inductive_type.xml ; extractor/meta_ind $$i "tmp/inductive_type.xml" >> $(FILLDB) ; rm -f tmp/downloaded.xml.gz tmp/inductive_type.xml; done > log 2>&1
-	time for i in `cat costanti_e_variabili.txt` ; do (cd tmp ; wget -t 1 -O downloaded.xml.gz "http://mowgli.cs.unibo.it:58081/getxml?format=gz&uri=$$i" ; wget -t 1 -O downloaded_body.xml.gz "http://mowgli.cs.unibo.it:58081/getxml?format=gz&uri=$$i.body"); zcat tmp/downloaded.xml.gz > tmp/type.xml ; zcat tmp/downloaded_body.xml.gz > tmp/body.xml ; extractor/meta $$i "tmp/body.xml" "tmp/type.xml" >> $(FILLDB) ; rm -f tmp/downloaded.xml.gz tmp/downloaded_body.xml.gz tmp/type.xml tmp/body.xml ; done > log 2>&1
+	time for i in `cat $(INDUCTIVETYPES)` ; do (cd tmp ; wget -t 1 -O downloaded.xml.gz "$(GETTERURL)/getxml?format=gz&uri=$$i") ; zcat tmp/downloaded.xml.gz > tmp/inductive_type.xml ; extractor/meta_ind $$i "tmp/inductive_type.xml" >> $(FILLDB) ; rm -f tmp/downloaded.xml.gz tmp/inductive_type.xml; done > log 2>&1
+	time for i in `cat $(CONSTANTSANDVARIABLES)` ; do (cd tmp ; wget -t 1 -O downloaded.xml.gz "$(GETTERURL)/getxml?format=gz&uri=$$i" ; wget -t 1 -O downloaded_body.xml.gz "$(GETTERURL)/getxml?format=gz&uri=$$i.body"); zcat tmp/downloaded.xml.gz > tmp/type.xml ; zcat tmp/downloaded_body.xml.gz > tmp/body.xml ; extractor/meta $$i "tmp/body.xml" "tmp/type.xml" >> $(FILLDB) ; rm -f tmp/downloaded.xml.gz tmp/downloaded_body.xml.gz tmp/type.xml tmp/body.xml ; done > log 2>&1
+	cat sql/fill_inconcl_aux.sql >> $@
+	cat sql/fill_no_concl_hyp.sql >> $@
+
+indexes:
+	wget "$(GETTERURL)/getalluris?format=txt" -O - | grep -v "\\.body$$" | grep -v "\\.types$$" | grep -v "\\.proof_tree$$" | sort > $(ALLOBJECTS)
+	cat $(ALLOBJECTS) | grep "\\.ind$$" > $(INDUCTIVETYPES)
+	cat $(ALLOBJECTS) | grep -v "\\.ind$$" > $(CONSTANTSANDVARIABLES)
 
 drop_tables:
-	cat sql/drop_mowgli_tables.sql | mysql -pbjIcRpru -u helmadmin mowgli
+	#cat sql/drop_mowgli_tables.sql | $(DBCOMM)
+	cat sql/drop_mowgli_tables.mysql.sql | $(DBCOMM)
 
 create_tables:
-	cat sql/create_mowgli_tables.sql | mysql -pbjIcRpru -u helmadmin mowgli
+	#cat sql/create_mowgli_tables.sql | $(DBCOMM)
+	cat sql/create_mowgli_tables.mysql.sql | $(DBCOMM)
 
 fill_db:
-	cat $(FILLDB) | mysql -pbjIcRpru -u helmadmin mowgli
+	cat $(FILLDB) | $(DBCOMM)
 
-.PHONY: all create_tables drop_tables fill_db
+.PHONY: all create_tables drop_tables fill_db indexes $(FILLDB)