2020-08-12 14:23:34 +02:00
|
|
|
#!/bin/bash
|
|
|
|
|
|
|
|
|
|
# Use this to create a new template schema based on an existing schema in the database.
|
|
|
|
|
#
|
|
|
|
|
# The template schema is used by bin/create_survey.sh to initialise a new set of tables for a prospect.
|
|
|
|
|
|
2020-08-12 18:18:47 +02:00
|
|
|
PGUSER=${PGUSER:-postgres}
|
|
|
|
|
PGHOST=${PGHOST:-localhost}
|
|
|
|
|
PGDATABASE=${PGDATABASE:-dougal}
|
|
|
|
|
|
2020-08-12 14:23:34 +02:00
|
|
|
SCHEMA_NAME=${SCHEMA_NAME:-survey_1}
|
|
|
|
|
EPSG_CODE=${EPSG_CODE:-23031}
|
|
|
|
|
DEST=${DEST:-"$(dirname "$0")/../etc/db/schema-template.sql"}
|
|
|
|
|
|
2020-08-12 18:18:47 +02:00
|
|
|
pg_dump -U $PGUSER --schema="$SCHEMA_NAME" --schema-only --host=$PGHOST $PGDATABASE |
|
2020-08-12 14:23:34 +02:00
|
|
|
sed -r "s/$SCHEMA_NAME/_SURVEY__TEMPLATE_/g;s/$EPSG_CODE/_EPSG__CODE_/g" >"$DEST" &&
|
|
|
|
|
echo "Schema $SCHEMA_NAME dumped to $DEST"
|
