view tests/0018/run-test.sh @ 199:72a037f2b1e4

Alter timesTable handling.

Instead of inserting N boundary points per track, insert N (start,end)
pairs.  Since N boundaries define only N-1 intervals, we were losing
information on insert -- this means that dump/restore cycles of existing
times-enabled databases WILL NOT WORK.

The input format for times files is still the same, albeit a little
tighter: there must be exactly N+1 floats in the file.

- make times table default length twice as big (done!)
- ensure exactly n+1 times read in from timesFile (done!)
- store (beginning, end) in times table (done!)
- update file format version (done!)
- ensure dump exactly n+1 times (done!)
- adjust uses of timesTable to read at 2k and 2k+1 (done!)
- timesdata[x] in sequence query is duration of sequence of
  appropriate length from point [x] (done!)
- dbdurs calculation (done!)
- don't decrement j when using times in sequence query (done!)
- tests! (NOT DONE)

#! /bin/sh

. ../test-utils.sh

if [ -f testdb ]; then rm -f testdb; fi

${AUDIODB} -d testdb -N

intstring 2 > testfeature01
floatstring 0 1 >> testfeature01
intstring 2 > testfeature10
floatstring 1 0 >> testfeature10

${AUDIODB} -d testdb -I -f testfeature01
${AUDIODB} -d testdb -I -f testfeature10

# sequence queries require L2NORM
${AUDIODB} -d testdb -L

start_server ${AUDIODB} 10018

echo "query point (0.0,0.5)"
intstring 2 > testquery
floatstring 0 0.5 >> testquery

${AUDIODB} -c localhost:10018 -d testdb -Q sequence -l 1 -f testquery > testoutput
echo testfeature01 0 0 0 > test-expected-output
echo testfeature10 2 0 0 >> test-expected-output
cmp testoutput test-expected-output
${AUDIODB} -c localhost:10018 -d testdb -Q sequence -l 1 -f testquery -r 1 > testoutput
echo testfeature01 0 0 0 > test-expected-output
cmp testoutput test-expected-output

check_server $!

echo "query point (0.5,0.0)"
intstring 2 > testquery
floatstring 0.5 0 >> testquery

${AUDIODB} -c localhost:10018 -d testdb -Q sequence -l 1 -f testquery > testoutput
echo testfeature10 0 0 0 > test-expected-output
echo testfeature01 2 0 0 >> test-expected-output
cmp testoutput test-expected-output
${AUDIODB} -c localhost:10018 -d testdb -Q sequence -l 1 -f testquery -r 1 > testoutput
echo testfeature10 0 0 0 > test-expected-output
cmp testoutput test-expected-output

stop_server $!

exit 104