root/spike/wktraster/scripts/Makefile.rt.sample

#############################################################################
# $Id$ 
#
# Makefile used to simplify creation of PostGIS and WKT Raster enabled
# database. Run make -f Makefile.rt to see usage message.
#
#############################################################################
# Copyright (C) 2009 Mateusz Loskot <mateusz@loskot.net>
#
# This is free software; you can redistribute and/or modify it under
# the terms of the GNU General Public Licence. See the COPYING file.
#
#############################################################################
#
# Instructions:
# You may need to update the location of SQL scripts of PostGIS
# and WKT Raster extensions.
#
### BEGIN OF CONFIGURATION ##################################################
POSTGIS = /usr/share/postgresql/8.4/contrib
WKTRASTER = ${POSTGIS}
### END OF CONFIGURATION ####################################################
#
# *** DO NOT EDIT ANYTHING BELOW ***

ifndef VERBOSE
        ERROUT=2>&1
endif

all:
        @echo "****** Makefile.rt usage ******"
        @echo "*** Create PostGIS and WKT Raster enabled database:"
        @echo "\tDBNAME=mydb make -f Makefile.rt create"
        @echo "*** Drop PostGIS and WKT Raster enabled database:"
        @echo "\tDBNAME=mydb make -f Makefile.rt drop"
        @echo "*** Check if database exists:"
        @echo "\tDBNAME=mydb make -f Makefile.rt check"
        @echo "PostGIS installation scripts: $(POSTGIS)"
drop:
        @echo "****** Makefile.rt ******"
ifdef DBNAME
        @echo "*** Dropping database '$(DBNAME)'..."
        @dropdb $(DBNAME) > /dev/null $(ERROUT);
        @echo "****** END. *******"
else
        @echo "****** Missing DBNAME option. Aborting."
endif

create:
        @echo "****** Makefile.rt ******"
ifdef DBNAME
        @echo "****** Creating database '$(DBNAME)'..."
        @createdb --tablespace=tablespace2 $(DBNAME) > /dev/null $(ERROUT);
        @createlang plpgsql $(DBNAME) > /dev/null $(ERROUT);
        @echo "****** Loading PostGIS into '$(DBNAME)'..."
        @psql -d $(DBNAME) -f $(POSTGIS)/postgis.sql > /dev/null $(ERROUT);
        @psql -d $(DBNAME) -f $(POSTGIS)/spatial_ref_sys.sql > /dev/null $(ERROUT);
        @echo "****** Loading WKT Raster into '$(DBNAME)'..."
        @psql -d $(DBNAME) -f $(WKTRASTER)/rtpostgis.sql > /dev/null $(ERROUT);
        @echo "****** END. *******"
else
        @echo "****** Missing DBNAME option. Aborting."
endif

check:
        @echo "****** Makefile.rt ******"
ifeq ($(shell psql -l | grep ' $(DBNAME) '  | wc -l), 1)
        @echo "****** Database '$(DBNAME)' found"
else
        @echo "****** Database '$(DBNAME)' not found"
endif