Changeset 3945 for spike/wktraster/scripts/Makefile.rt

Timestamp:

03/30/09 08:45:10 (3 years ago)

Author:

mloskot

Message:

[wktraster] Completed implementation of targets drop, create and check in the Makefile.rt.

Files:

• spike/wktraster/scripts/Makefile.rt (modified) (1 diff, 1 prop)

spike/wktraster/scripts/Makefile.rt

@@ -1 @@
-DBNAME=sistest
+#############################################################################
+# $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:
+# Provide location of SQL scripts of PostGIS and WKT Raster extensions
+#
+### BEGIN OF CONFIGURATION ##################################################
 POSTGIS = /usr/share/postgresql/8.3/contrib
 WKTRASTER = /home/mloskot/dev/wktraster/_svn/trunk
-DATA=/home/mloskot/data/test
-QUIET =
+### END OF CONFIGURATION ####################################################
+#
+# *** DO NOT EDIT ANYTHING BELOW ***
+
+ifdef NOERR
+        ERROUT=2>&1
+endif
 
 all:
-        @echo "****** Usage ******"
-        @echo "*** Create PostGIS and WKT Raster enabled database 'mydb' ******"
-        @echo "DBNAME=mydb make -f Makefile.rt"
-        @echo "*** Drop PostGIS and WKT Raster enabled database 'mydb' ******"
-        @echo "DBNAME=mydb make -f Makefile.rt clean"
+        @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"
 
-clean:
-        @echo "****** BEGIN ******"
+drop:
+        @echo "****** Makefile.rt ******"
+ifdef DBNAME
         @echo "*** Dropping database '$(DBNAME)'..."
-        @dropdb $(DBNAME)
-        @echo "****** END. ******"
+        @dropdb $(DBNAME) > /dev/null $(ERROUT);
+        @echo "****** END. *******"
+else
+        @echo "****** Missing DBNAME option. Aborting."
+endif
 
-db:
-        @echo "****** BEGIN ******"
+create:
+        @echo "****** Makefile.rt ******"
+ifdef DBNAME
         @echo "****** Creating database '$(DBNAME)'..."
-        @createdb $(DBNAME)
-        @createlang plpgsql $(DBNAME)
+        @createdb $(DBNAME) > /dev/null $(ERROUT);
+        @createlang plpgsql $(DBNAME) > /dev/null $(ERROUT);
         @echo "****** Loading PostGIS into '$(DBNAME)'..."
-        @psql -d $(DBNAME) -f $(POSTGIS)/postgis.sql > /dev/null;
-        @psql -d $(DBNAME) -f $(POSTGIS)/spatial_ref_sys.sql > /dev/null;
+        @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)/rt_pg/rtpostgis.sql > /dev/null;
+        @psql -d $(DBNAME) -f $(WKTRASTER)/rt_pg/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