First version of the stuff to create the DB.

[helm.git] / helm / metadata / postgresql_V7_mowgli / Makefile

diff --git a/helm/metadata/postgresql_V7_mowgli/Makefile b/helm/metadata/postgresql_V7_mowgli/Makefile
new file mode 100644 (file)
index 0000000..c0814d7
--- /dev/null
+++ b/helm/metadata/postgresql_V7_mowgli/Makefile
@@ -0,0 +1,16 @@
+CWD=/projects/helm/metadata/postgresql_V7_mowgli_new_schema
+
+txt:
+       (cd forward && find . -type d -exec mkdir -p $(CWD)/txt/{} \;)
+       (cd forward && find . -name "*.xml" -exec xsltproc --param path '"{}"' -o $(CWD)/txt/{}.txt $(CWD)/metainfo.xsl {} \; -exec echo {} \;)
+
+upload:
+       (cd txt && find */* -name "*.txt" > index.txt)
+       (cd txt && cat index.txt | ../inserisci.pl)
+       ./upload_rel.pl forward_rel.xml | psql -h mowgli -U helm helm_mowgli_new_schema
+       ./upload_sort.pl forward_sort.xml | psql -h mowgli -U helm helm_mowgli_new_schema
+
+clean:
+       rm -rf txt/*
+
+.PHONY: txt