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
|
#!/bin/bash
set -uex
# A unique working directory
wd=$(pwd)
test_wd=$(pwd)/test_odb_sql_like
mkdir -p ${test_wd}
cd ${test_wd}
# In case we are resuming from a previous failed run, which has left output in the directory
rm *.odb || true
# Create some test data
cat > data.csv <<EOF
col1:STRING,col2:INTEGER
'abra',1
'cadabra',2
'czary',3
'mary',4
EOF
odc import data.csv data.odb
# Test select query
odc sql 'select col2 where col1 like "ra"' -i data.odb -f odb -o outfile.odb
cat > expect.csv <<EOF
col2:INTEGER
1
2
EOF
odc import expect.csv expect.odb
odc compare outfile.odb expect.odb
# Clean up
cd ${wd}
rm -rf ${test_wd}
|
