./xml2vegbank <vb_plot_observation.xml

#!/bin/bash

# Runs xml2db with output to vegbank

selfDir="$(dirname -- "$0")"

export host=localhost user=vegbank password=vegbank database=vegbank

"$selfDir/xml2db"

export PGHOST=localhost PGUSER=vegbank PGPASSWORD=vegbank \

PGOPTIONS='--client-min-messages=WARNING'

psql --quiet --dbname=vegbank <"$selfDir/vegbank_reset.sql"

-- Name: vegbank; Type: DATABASE; Schema: -; Owner: postgres

CREATE DATABASE vegbank WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';

ALTER DATABASE vegbank OWNER TO postgres;

-- Name: public; Type: ACL; Schema: -; Owner: postgres

REVOKE ALL ON SCHEMA public FROM postgres;

GRANT ALL ON SCHEMA public TO postgres;

TRUNCATE address CASCADE;

TRUNCATE aux_role CASCADE;

TRUNCATE classcontributor CASCADE;

TRUNCATE commclass CASCADE;

TRUNCATE commconcept CASCADE;

TRUNCATE commcorrelation CASCADE;

TRUNCATE comminterpretation CASCADE;

TRUNCATE commlineage CASCADE;

TRUNCATE commname CASCADE;

TRUNCATE commstatus CASCADE;

TRUNCATE commusage CASCADE;

TRUNCATE coverindex CASCADE;

TRUNCATE covermethod CASCADE;

TRUNCATE dba_confidentialitystatus CASCADE;

TRUNCATE dba_cookie CASCADE;

TRUNCATE dba_cookielabels CASCADE;

TRUNCATE dba_datacache CASCADE;

TRUNCATE dba_datamodelversion CASCADE;

TRUNCATE dba_dbstatstime CASCADE;

TRUNCATE dba_fielddescription CASCADE;

TRUNCATE dba_fieldlist CASCADE;

TRUNCATE dba_onerow CASCADE;

TRUNCATE dba_preassignacccode CASCADE;

TRUNCATE dba_tabledescription CASCADE;

TRUNCATE dba_xmlcache CASCADE;

TRUNCATE definedvalue CASCADE;

TRUNCATE disturbanceobs CASCADE;

TRUNCATE embargo CASCADE;

TRUNCATE graphic CASCADE;

TRUNCATE keywords CASCADE;

TRUNCATE keywords_extra CASCADE;

TRUNCATE namedplace CASCADE;

TRUNCATE namedplacecorrelation CASCADE;

TRUNCATE note CASCADE;

TRUNCATE notelink CASCADE;

TRUNCATE observation CASCADE;

TRUNCATE observationcontributor CASCADE;

TRUNCATE observationsynonym CASCADE;

TRUNCATE party CASCADE;

TRUNCATE partymember CASCADE;

TRUNCATE place CASCADE;

TRUNCATE plantconcept CASCADE;

TRUNCATE plantcorrelation CASCADE;

TRUNCATE plantlineage CASCADE;

TRUNCATE plantname CASCADE;

TRUNCATE plantstatus CASCADE;

TRUNCATE plantusage CASCADE;

TRUNCATE plot CASCADE;

TRUNCATE project CASCADE;

TRUNCATE projectcontributor CASCADE;

TRUNCATE reference CASCADE;

TRUNCATE referencealtident CASCADE;

TRUNCATE referencecontributor CASCADE;

TRUNCATE referencejournal CASCADE;

TRUNCATE referenceparty CASCADE;

TRUNCATE revision CASCADE;

TRUNCATE soilobs CASCADE;

TRUNCATE soiltaxon CASCADE;

TRUNCATE stemcount CASCADE;

TRUNCATE stemlocation CASCADE;

TRUNCATE stratum CASCADE;

TRUNCATE stratummethod CASCADE;

TRUNCATE stratumtype CASCADE;

TRUNCATE taxonalt CASCADE;

TRUNCATE taxonimportance CASCADE;

TRUNCATE taxoninterpretation CASCADE;

TRUNCATE taxonobservation CASCADE;

TRUNCATE telephone CASCADE;

TRUNCATE temptbl_std_commnames CASCADE;

TRUNCATE temptbl_std_plantnames CASCADE;

TRUNCATE usercertification CASCADE;

TRUNCATE userdataset CASCADE;

TRUNCATE userdatasetitem CASCADE;

TRUNCATE userdefined CASCADE;

TRUNCATE usernotify CASCADE;

TRUNCATE userpermission CASCADE;

TRUNCATE userpreference CASCADE;

TRUNCATE userquery CASCADE;

TRUNCATE userrecordowner CASCADE;

TRUNCATE userregionalexp CASCADE;

TRUNCATE usr CASCADE;