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
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
|
#!/bin/bash
#!/bin/ksh
#
# This file is part of rasdaman community.
#
# Rasdaman community is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# Rasdaman community is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with rasdaman community. If not, see <http://www.gnu.org/licenses/>.
#
# Copyright 2003, 2004, 2005, 2006, 2007, 2008, 2009 Peter Baumann /
# rasdaman GmbH.
#
# For more information please see <http://www.rasdaman.org>
# or contact Peter Baumann via <baumann@rasdaman.com>.
#
# SYNOPSIS
# test.sh
# Description
# Command-line utility for testing rasdaman.
# 1) Send rasql query
# 2) Get response
# 3) Compare the response with the expected result
# 4) Give out the testing result.
#
# PRECONDITIONS
# Postgres, Rasdaman installed
#
# Usage: ./test.sh
# images needed for testing shall be put in directory of testdata
# Parameters:
#
#
# CHANGE HISTORY
# 2009-Sep-16 J.Yu created
# 2010-Apr-13 J.Yu revise on input folder structure to support different queries input, including folders on mandatory, bug fixed, bug unfixed, and other queries.
#
# Parameters definistion and initiation
PROGNAME=`basename $0`
USERNAME=rasadmin
PASSWORD=rasadmin
DATABASE=RASBASE
# RMANBASE: change RMANBASE depending on your system, where rasdaman is installed
# RASQL="rasql --quiet" no ornament msg
# QUERY_DIR: the test input folder, including queries for extracting some aspects of tested data
# QUERY_DIR_T: the test input folder, including queries for updating some aspects of tested data
# TESTDATA_DIR: the images needed
# ORACLE_DIR: the expected result
RMANBASE=$RMANHOME
RASQL="rasql"
RASDL="rasdl"
DIR_NAME=$(dirname $0)
QUERY_DIR=$DIR_NAME/test_rasql
TESTDATA_DIR=$DIR_NAME/testdata
ORACLE_DIR=$DIR_NAME/oracle
LOG_DIR=$DIR_NAME
LOG=$LOG_DIR/log
TEST_GREY=test_grey
TEST_GREY2=test_grey2
TEST_RGB2=test_rgb2
QUERY=""
# LOG_DIR: the query output
# REPOET: test report
# NUM_TOTAL: number of the test query
# NUM_FAIL: number of fail test
# NUM_SUC: number of success test
# Q_ID: query identifier
NUM_TOTAL=0
NUM_FAIL=0
NUM_SUC=0
Q_ID=""
CODE_OK=0
CODE_FAIL=255
echo "Test by:"$PROGNAME $QUERY_DIR $ORACLE_DIR $LOG_DIR" at "`date`|tee $LOG
#---------------------------Precondition------------------------------------------
# check the Postgres
ps -e | grep --quiet -w postmaster
if [ $? -ne 0 ]
then
echo no postmaster available|tee -a $LOG
exit $CODE_FAIL
fi
# check the Rasdaman
ps -e | grep --quiet -w rasmgr
if [ $? -ne 0 ]
then
echo no rasmgr available|tee -a $LOG
exit $CODE_FAIL
fi
# check usr
#
# check data collection
$RASQL -q "select r from RAS_COLLECTIONNAMES as r"
if [ $? -ne 0 ]
then
echo no data collection available|tee -a $LOG
exit $CODE_FAIL
fi
# check data type
$RASDL --print|grep --quiet GreySet
if [ $? -ne 0 ]
then
echo no GreySet type available, try create_db.sh|tee -a $LOG
exit $CODE_FAIL
fi
$RASDL --print|grep --quiet RGBSet
if [ $? -ne 0 ]
then
echo no RGBSet type available, try create_db.sh|tee -a $LOG
exit $CODE_FAIL
fi
#--------------------------initiation--------------------------------------------
# drop test collection if they already exists
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w $TEST_GREY
then
echo dropping collection ... | tee -a $LOG
$RASQL -q 'drop collection '$TEST_GREY'' --user $USERNAME --passwd $PASSWORD | tee -a $LOG
fi
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w $TEST_GREY2
then
echo dropping collection ... | tee -a $LOG
$RASQL -q 'drop collection '$TEST_GREY2'' --user $USERNAME --passwd $PASSWORD | tee -a $LOG
fi
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w $TEST_RGB2
then
echo dropping collection ... | tee -a $LOG
$RASQL -q 'drop collection '$TEST_RGB2'' --user $USERNAME --passwd $PASSWORD | tee -a $LOG
fi
echo test data initiation... | tee -a $LOG
echo creating test collection $TEST_GREY... | tee -a $LOG
$RASQL -q 'create collection '$TEST_GREY' GreySet' --user $USERNAME --passwd $PASSWORD || echo Error creating collection $TEST_GREY| tee -a $LOG
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w $TEST_GREY
then
echo create collection $TEST_GREY GreySet successfully ... | tee -a $LOG
else
echo create collection $TEST_GREY GreySet unsuccessfully ... | tee -a $LOG
fi
echo inserting MDD into collection $TEST_GREY... | tee -a $LOG
if [ ! -f $TESTDATA_DIR/mr_1.png ]
then
echo "there is no test data in "$TESTDATA_DIR
exit $CODE_FAIL
else
if $RASQL -q 'insert into test_grey values inv_png($1)' --file $TESTDATA_DIR/mr_1.png --user $USERNAME --passwd $PASSWORD
then
echo insert test data into collection $TEST_GREY successfully ... | tee -a $LOG
else
echo insert test data into collection $TEST_GREY unsuccessfully ... | tee -a $LOG
exit $CODE_FAIL
fi
fi
echo creating test collection $TEST_GREY2... | tee -a $LOG
$RASQL -q 'create collection '$TEST_GREY2' GreySet' --user $USERNAME --passwd $PASSWORD || echo Error creating collection $TEST_GREY2| tee -a $LOG
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w $TEST_GREY2
then
echo create collection $TEST_GREY2 GreySet successfully ... | tee -a $LOG
else
echo create collection $TEST_GREY2 GreySet unsuccessfully ... | tee -a $LOG
fi
echo inserting MDD into collection $TEST_GREY2... | tee -a $LOG
if [ ! -f $TESTDATA_DIR/mr2_1.png ]
then
echo "there is no test data in "$TESTDATA_DIR
exit $CODE_FAIL
else
if $RASQL -q 'insert into '$TEST_GREY2' values inv_png($1)' -f $TESTDATA_DIR/mr2_1.png --user $USERNAME --passwd $PASSWORD
then
echo insert test data into collection $TEST_GREY2 successfully ... | tee -a $LOG
else
echo insert test data into collection $TEST_GREY2 unsuccessfully ... | tee -a $LOG
exit $CODE_FAIL
fi
fi
echo creating test collection $TEST_RGB2... | tee -a $LOG
$RASQL -q 'create collection '$TEST_RGB2' RGBSet' --user $USERNAME --passwd $PASSWORD || echo Error creating collection $TEST_RGB2| tee -a $LOG
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w test_rgb
then
echo create collection $TEST_RGB2 RGBSet successfully ... | tee -a $LOG
else
echo create collection $TEST_RGB2 RGBSet unsuccessfully ... | tee -a $LOG
fi
echo inserting MDD into collection $TEST_RGB2... | tee -a $LOG
if [ ! -f $TESTDATA_DIR/rgb.png ]
then
echo "there is no test data in "$TESTDATA_DIR
exit $CODE_FAIL
else
if $RASQL -q 'insert into '$TEST_RGB2' values inv_png($1)' --file $TESTDATA_DIR/rgb.png --user $USERNAME --passwd $PASSWORD
then
echo insert test data into collection $TEST_RGB2 successfully ... | tee -a $LOG
else
echo insert test data into collection $TEST_RGB2 unsuccessfully ... | tee -a $LOG
exit $CODE_FAIL
fi
fi
#==========================test by queries==================================================
if [ ! -f $QUERY_DIR/*.rasql ]
then
echo "there is no rasql for test in the "$QUERY_DIR
else
# initialation
rm tmp.unknown
# Query by query for extracting some aspects of tested data
for i in $QUERY_DIR/*.rasql
do
# Send query in query folder.
Q_ID=`basename $i`
echo -e "\n test query in " $Q_ID|tee -a $LOG
QUERY=`cat $i`
$RASQL -q "$QUERY" --out file --outfile tmp|tee -a $LOG
# if the result is a scalar, there will be no tmp file by rasql, here we output the Result element scalar into tmp.unknown
if [ ! -f tmp.unknown ]
then
$RASQL -q "$QUERY" --out string|grep Result > tmp.unknown
fi
mv tmp.unknown $Q_ID
# Compare the result byte by byte with the expected result in orale folder
cmp $ORACLE_DIR/$Q_ID $Q_ID
if [ $? != 0 ]
then
echo -e "\n Result error for the query."|tee -a $LOG
NUM_FAIL=$(($NUM_FAIL + 1))
else
echo -e "\n Result correct for the query."|tee -a $LOG
NUM_SUC=$(($NUM_SUC + 1))
fi
rm $Q_ID
done
fi
NUM_TOTAL=$(($NUM_SUC + $NUM_FAIL))
# drop collection after test
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w $TEST_GREY
then
echo dropping collection ... | tee -a $LOG
$RASQL -q 'drop collection '$TEST_GREY'' --user $USERNAME --passwd $PASSWORD | tee -a $LOG
fi
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w $TEST_GREY2
then
echo dropping collection ... | tee -a $LOG
$RASQL -q 'drop collection '$TEST_GREY2'' --user $USERNAME --passwd $PASSWORD | tee -a $LOG
fi
if $RASQL -q "select r from RAS_COLLECTIONNAMES as r" --out string|grep -w $TEST_RGB2
then
echo dropping collection ... | tee -a $LOG
$RASQL -q 'drop collection '$TEST_RGB2'' --user $USERNAME --passwd $PASSWORD | tee -a $LOG
fi
# Print the summary
echo "test done at "`date`|tee -a $LOG
echo "Total query number: "$NUM_TOTAL|tee -a $LOG
echo "Successful query number: "$NUM_SUC|tee -a $LOG
echo "Failed query number: "$NUM_FAIL|tee -a $LOG
echo "Detail test report is in "$LOG
if [ $NUM_TOTAL = $NUM_SUC ]
then
exit $CODE_OK 0
else
exit $CODE_FAIL 255
fi
|
