Updating the helper functions

SimonGoring · SimonGoring · commit a5d1a7834373 · 2021-02-25T16:05:22.000-08:00
Updated added a view for fulltext search.
diff --git a/function/ndb/publicationtsv.sql b/function/ndb/publicationtsv.sql
@@ -0,0 +1,9 @@
+CREATE OR REPLACE VIEW ndb.pubtsv AS
+  SELECT pu.publicationid,
+    setweight(to_tsvector(coalesce(pu.articletitle,'')), 'A')    ||
+    setweight(to_tsvector(coalesce(pu.booktitle,'')), 'A')    ||
+    setweight(to_tsvector(coalesce(pu.journal,'')), 'B')  ||
+    setweight(to_tsvector(coalesce(pu.seriestitle,'')), 'B') ||
+    setweight(to_tsvector(coalesce(pu.volumetitle,'')), 'B') ||
+    setweight(to_tsvector(coalesce(pu.citation,'')), 'C') AS pubtsv
+  FROM ndb.publications AS pu;
diff --git a/helpers/neofulldump.sh b/helpers/neofulldump.sh
@@ -7,7 +7,8 @@ fi
 now=`date +"%Y-%m-%d"`
 mkdir -p dumps
 mkdir -p archives
-pg_dump -Fc -O -h db5.cei.psu.edu -U $1 -N gen -N tmp -W -v -d neotoma > ./dumps/neotoma_dump_full_${now}.sql
+pg_dump -Fc -O -v -h db5.cei.psu.edu -U $1 -s neotoma > ./dumps/neotoma_ndb_schema_${now}.sql
+pg_dump -Fc -O -v -h db5.cei.psu.edu -U $1 -N gen -N tmp -W -v -d neotoma > ./dumps/neotoma_dump_full_${now}.sql
 tar -cvf ./archives/neotoma_dump_full_${now}.tar -C ./dumps neotoma_dump_full_${now}.sql
 rm ./dumps/neotoma_dump_full_${now}.sql
 pg_dump -Fc -O -h db5.cei.psu.edu -U $1 -N gen -n ndb -W -v -d neotoma > ./dumps/neotoma_dump_ndb_${now}.sql
