Ticket #301: uninstall_script

#!/bin/bash

DB=postgis_uninstall

PGFILE=uninstall_postgis.sql
RTFILE=uninstall_rtpostgis.sql

if [ "raster" == "$1" ]; then
        OUTFILE=$RTFILE
else
        OUTFILE=$PGFILE
fi
INFILE=$OUTFILE.in.$RANDOM
RAND=$RANDOM

RTN=0

cleanup () {
        rm -f $INFILE $OUTFILE.$RAND
}

# get reference uninstall of postgis.sql only
if [ "$1" == "raster" ]; then
        $0
fi

# create database
createdb $DB

# load postgis.sql
psql -q -d $DB -f ../../postgis/postgis.sql

# raster requested, load rtpostgis.sql
if [ "$1" == "raster" ]; then
        psql -q -d $DB -f rtpostgis.sql
fi

# dump database loaded with postgis.sql and rtpostgis.sql and strip for only one-line DROP and SET statements
pg_dump --format=p --clean --schema-only --no-owner --no-acl --no-tablespaces $DB | grep -E "^(DROP|SET).*;$" | grep -v -E "^DROP (SCHEMA|PROCEDURAL) .*;$" > $INFILE

# drop database
dropdb $DB

# first search_path is parsed
schema=`grep -m 1 "SET search_path = " < $INFILE | sed -e 's/SET search_path = //' -e 's/\(,\|;\)//g' -e 's/ /\n/'`

# sed arguments
sedarg="\-e 's/^DROP \(TABLE\|VIEW\|CAST\|OPERATOR CLASS\|OPERATOR\|AGGREGATE\|FUNCTION\|TYPE\)/& IF EXISTS/' "
for x in $schema; do
        sedarg="\-e 's/${x}.//g' "${sedarg}
done

# remove SET statements, remove schema names from DROP statements and add IF EXISTS for DROP statements
grep -v -E "^SET" < $INFILE | eval "sed ${sedarg}" > $OUTFILE.$RAND
RTN=$?

if [ "$RTN" != "0" ]; then
        cleanup
        exit $RTN
fi

# if raster, separate raster from postgis items
if [ "raster" == "$1" ]; then
        OIFS=$IFS
        IFS=$'\n'

        echo -n '' > $OUTFILE

        # see if line found in uninstall_postgis.sql
        for x in `cat $OUTFILE.$RAND`; do
                y=`echo $x | sed -e 's/\(\[\|\]\)/\\\&/g'`
                y=`grep "^${y}$" < $PGFILE`

                # not postgis item
                if [ "x$y" == "x" ]; then
                        echo $x >> $OUTFILE
                fi
        done

        IFS=$OIFS
else
        mv $OUTFILE.$RAND $OUTFILE
fi

# cleanup
cleanup

# return error
exit $RTN