1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
#!/bin/sh
EXIT_ON_FIRST_FAILURE=0
if test "$1" = "-s"; then
EXIT_ON_FIRST_FAILURE=1
shift
fi
if test -z "$1"; then
echo "Usage: $0 [-s] <to_version>" >&2
echo "Options:" >&2
echo "\t-s Stop on first failure" >&2
exit 1
fi
to_version_param="$1"
to_version=$to_version_param
if expr $to_version : ':auto' >/dev/null; then
export PGDATABASE=template1
to_version=`psql -XAtc "select default_version from pg_available_extensions where name = 'postgis'"` || exit 1
fi
# Return -1, 1 or 0 if the first version
# is respectively smaller, greater or equal
# to the second version
semver_compare()
{
V1=`echo "$1" | tr '.' ' '`
V2=$2
# echo "V1: $V1" >&2
# echo "V2: $V2" >&2
for v1 in $V1; do
v2=`echo "$V2" | cut -d. -f1`
if [ -z "$v2" ]; then
echo 1; return;
fi
V2=`echo "$V2" | cut -d. -sf2-`
# echo "v: $v1 - $v2" >&2
if expr "$v1" '<' "$v2" > /dev/null; then
echo -1; return;
fi
if expr "$v1" '>' "$v2" > /dev/null; then
echo 1; return;
fi
done
if [ -n "$V2" ]; then
echo -1; return;
fi
echo 0; return;
}
BUILDDIR=$PWD
EXTDIR=`pg_config --sharedir`/extension/
CTBDIR=`pg_config --sharedir`/contrib/
cd $EXTDIR
failures=0
INSTALLED_EXTENSIONS=postgis
if test -f postgis_topology--${to_version}.sql; then
INSTALLED_EXTENSIONS="$INSTALLED_EXTENSIONS postgis_topology"
fi
if test -f postgis_raster--${to_version}.sql; then
INSTALLED_EXTENSIONS="$INSTALLED_EXTENSIONS postgis_raster"
fi
echo "INFO: installed extensions: $INSTALLED_EXTENSIONS"
failed()
{
failures=$((failures+1))
if test $EXIT_ON_FIRST_FAILURE != 0 -a $failures != 0; then
exit $failures
fi
}
for EXT in ${INSTALLED_EXTENSIONS}; do
if test "${EXT}" = "postgis"; then
REGDIR=${BUILDDIR}/regress
elif test "${EXT}" = "postgis_topology"; then
REGDIR=${BUILDDIR}/topology/test
elif test "${EXT}" = "postgis_raster"; then
REGDIR=${BUILDDIR}/raster/test/regress
else
echo "SKIP: don't know where to find regress tests for extension ${EXT}"
fi
# Check extension->extension upgrades
files=`'ls' ${EXT}--* | grep -v -- '--.*--' | sed "s/^${EXT}--\(.*\)\.sql/\1/"`
for fname in $files; do
from_version="$fname"
UPGRADE_PATH="${from_version}--${to_version_param}"
UPGRADE_FILE="${EXT}--${from_version}--${to_version}.sql"
# only consider versions older than ${to_version}
cmp=`semver_compare "${from_version}" "${to_version}"`
if test $cmp -ge 0; then
echo "SKIP: upgrade $UPGRADE_PATH ($to_version is not newer than $from_version)"
continue
fi
if test -e ${UPGRADE_FILE}; then
echo "Testing ${EXT} upgrade $UPGRADE_PATH"
export RUNTESTFLAGS="-v --extension --upgrade-path=${UPGRADE_PATH}"
make -C ${REGDIR} check && {
echo "PASS: upgrade $UPGRADE_PATH"
} || {
echo "FAIL: upgrade $UPGRADE_PATH"
failed
}
else
echo "SKIP: ${EXT} upgrade $UPGRADE_FILE is missing"
fi
done
# Check unpackaged->extension upgrades
for majmin in `'ls' -d ${CTBDIR}/postgis-* | sed 's/.*postgis-//'`; do
UPGRADE_PATH="unpackaged${majmin}--${to_version_param}"
# only consider versions older than ${to_version_param}
cmp=`semver_compare "${majmin}" "${to_version_param}"`
if test $cmp -ge 0; then
echo "SKIP: upgrade $UPGRADE_PATH ($to_version_param is not newer than $majmin)"
continue
fi
echo "Testing ${EXT} upgrade $UPGRADE_PATH"
export RUNTESTFLAGS="-v --extension --upgrade-path=${UPGRADE_PATH}"
make -C ${REGDIR} check && {
echo "PASS: upgrade $UPGRADE_PATH"
} || {
echo "FAIL: upgrade $UPGRADE_PATH"
failed
}
done
done
exit $failures
|
