From fc5ed48931608e5b7f303d778f8bdcca3ac15cdf Mon Sep 17 00:00:00 2001
From: Sandro Santilli <strk@keybit.net>
Date: Tue, 24 Nov 2015 09:22:39 +0000
Subject: [PATCH] Add check-installed-upgrades rule under extensions

The rule runs upgrade tests for all available extension
upgrade paths. Mostly fails, due to the features checked not
always being available in the installed versions of the extension,
but is a good starting point to improve the testing coverage.

git-svn-id: http://svn.osgeo.org/postgis/trunk@14421 b70326c6-7e19-0410-871a-916f4a2858ee
---
 extensions/upgradeable_versions.mk | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

diff --git a/extensions/upgradeable_versions.mk b/extensions/upgradeable_versions.mk
index 70cacea59..5780dbb5e 100644
--- a/extensions/upgradeable_versions.mk
+++ b/extensions/upgradeable_versions.mk
@@ -19,3 +19,29 @@ UPGRADEABLE_VERSIONS = \
 	2.1.9 \
 	2.2.0 \
 	2.2.1
+
+check-installed-upgrades:
+	MODULE=$(EXTENSION); \
+	TOVER=$(EXTVERSION); \
+  EXDIR=`$(PG_CONFIG) --sharedir`/extension; \
+	echo MODULE=$${MODULE}; \
+	echo TOVER=$${TOVER}; \
+	echo EXDIR=$${EXDIR}; \
+  ls $${EXDIR}/$${MODULE}--*--$${TOVER}.sql \
+        | grep -v unpackaged \
+        | while read fname; do \
+    p=`echo "$${fname}" | sed "s/.*$${MODULE}--//;s/\.sql$$//"`;  \
+    FROM=`echo $${p} | sed 's/--.*//'`; \
+    FF="$${EXDIR}/$${MODULE}--$${FROM}.sql"; \
+    if test -f "$${FF}"; then \
+      echo "Testing upgrade path $$p"; \
+      $(MAKE) -C ../.. installcheck \
+        RUNTESTFLAGS="-v --extension --upgrade-path $$p" \
+        || { \
+        echo "Upgrade path $$p failed FF=$${FF}"; \
+        exit 1; }; \
+    else \
+        echo "No install available for upgradeable ext version $${FROM}"; \
+    fi; \
+  done; \
+
-- 
2.50.1