blob: fb17ab7a721748bce8cf67d50739969bb9e24804 (
plain)
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
|
#!/bin/sh
# $Header: /cvsroot/pgsql/src/test/regress/Attic/regress.sh,v 1.1.1.1 1996/07/09 06:22:24 scrappy Exp $
#
if [ -d ./obj ]; then
cd ./obj
fi
#FRONTEND=monitor
FRONTEND="psql -n -e -q"
echo =============== destroying old regression database... =================
destroydb regression
echo =============== creating new regression database... =================
createdb regression
if [ $? -ne 0 ]; then
echo createdb failed
exit 1
fi
$FRONTEND regression < create.sql
if [ $? -ne 0 ]; then
echo the creation script has an error
exit 1
fi
echo =============== running regression queries ... =================
$FRONTEND regression < queries.sql
if [ $? -ne 0 ]; then
echo the queries script causes an error
exit 1
fi
echo =============== running error queries ... =================
$FRONTEND regression < errors.sql
if [ $? -ne 0 ]; then
echo the errors script has an unanticipated problem
exit 1
fi
#set this to 1 to avoid clearing the database
debug=0
if test "$debug" -eq 1
then
echo Skipping clearing and deletion of the regression database
else
echo =============== clearing regression database... =================
$FRONTEND regression < destroy.sql
if [ $? -ne 0 ]; then
echo the destroy script has an error
exit 1
fi
exit 0
echo =============== destroying regression database... =================
destroydb regression
if [ $? -ne 0 ]; then
echo destroydb failed
exit 1
fi
exit 0
fi
|
