mas01cr@487
|
1 #include "audioDB_API.h"
|
mas01cr@487
|
2 #include "test_utils_lib.h"
|
mas01ik@355
|
3
|
mas01ik@355
|
4
|
mas01ik@355
|
5 int main(int argc, char **argv){
|
mas01ik@355
|
6
|
mas01ik@355
|
7 int returnval=0;
|
mas01ik@355
|
8 adb_ptr mydbp={0};
|
mas01ik@355
|
9 int ivals[10];
|
mas01ik@355
|
10 double dvals[10];
|
mas01ik@355
|
11 adb_insert_t myinsert={0};
|
mas01ik@355
|
12 char * databasename="testdb";
|
mas01ik@355
|
13 adb_query_t myadbquery={0};
|
mas01ik@355
|
14 adb_queryresult_t myadbqueryresult={0};
|
mas01ik@355
|
15 int size=0;
|
mas01ik@355
|
16
|
mas01ik@355
|
17
|
mas01ik@355
|
18 /* remove old directory */
|
mas01ik@355
|
19 //if [ -f testdb ]; then rm -f testdb; fi
|
mas01ik@355
|
20 clean_remove_db(databasename);
|
mas01ik@355
|
21
|
mas01ik@355
|
22 /* create new db */
|
mas01ik@355
|
23 //${AUDIODB} -d testdb -N
|
mas01ik@355
|
24 mydbp=audiodb_create(databasename,0,0,0);
|
mas01ik@355
|
25
|
mas01ik@355
|
26 ///intstring 2 > testfeature01
|
mas01ik@355
|
27 ///floatstring 0 1 >> testfeature01
|
mas01ik@355
|
28 ///intstring 2 > testfeature10
|
mas01ik@355
|
29 ///floatstring 1 0 >> testfeature10
|
mas01ik@355
|
30 ivals[0]=2;
|
mas01ik@355
|
31 dvals[0]=0; dvals[1]=1;
|
mas01ik@355
|
32 maketestfile("testfeature01",ivals,dvals,2);
|
mas01ik@355
|
33 ivals[0]=2;
|
mas01ik@355
|
34 dvals[0]=1; dvals[1]=0;
|
mas01ik@355
|
35 maketestfile("testfeature10",ivals,dvals,2);
|
mas01ik@355
|
36
|
mas01ik@355
|
37 ///${AUDIODB} -d testdb -I -f testfeature01
|
mas01ik@355
|
38 ///${AUDIODB} -d testdb -I -f testfeature10
|
mas01ik@355
|
39
|
mas01ik@355
|
40 myinsert.features="testfeature01";
|
mas01ik@355
|
41 if (audiodb_insert(mydbp,&myinsert)){ returnval=-1; }
|
mas01ik@355
|
42
|
mas01ik@355
|
43 myinsert.features="testfeature10";
|
mas01ik@355
|
44 if (audiodb_insert(mydbp,&myinsert)){ returnval=-1; }
|
mas01ik@355
|
45
|
mas01ik@355
|
46 ///# sequence queries require L2NORM
|
mas01ik@355
|
47 ///${AUDIODB} -d testdb -L
|
mas01ik@355
|
48 if(audiodb_l2norm(mydbp)){ returnval=-1; };
|
mas01ik@355
|
49
|
mas01ik@355
|
50 ///echo "query point (0.0,0.5)"
|
mas01ik@355
|
51 ///intstring 2 > testquery
|
mas01ik@355
|
52 ///floatstring 0 0.5 >> testquery
|
mas01ik@355
|
53 ivals[0]=2;
|
mas01ik@355
|
54 dvals[0]=0; dvals[1]=0.5;
|
mas01ik@355
|
55 maketestfile("testquery",ivals,dvals,2);
|
mas01ik@355
|
56
|
mas01ik@355
|
57 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
|
mas01ik@355
|
58 ///echo testfeature01 0 0 0 > test-expected-output
|
mas01ik@355
|
59 ///echo testfeature10 2 0 0 >> test-expected-output
|
mas01ik@355
|
60 ///cmp testoutput test-expected-output
|
mas01ik@355
|
61 myadbquery.querytype="sequence";
|
mas01ik@355
|
62 myadbquery.feature="testquery";
|
mas01ik@355
|
63 myadbquery.sequencelength="1";
|
mas01ik@355
|
64 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
65 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
66
|
mas01ik@355
|
67 /* check the test values */
|
mas01ik@355
|
68 if (size != 2) {returnval = -1;};
|
mas01ik@355
|
69 if (testoneresult(&myadbqueryresult,0,"testfeature01",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
70 if (testoneresult(&myadbqueryresult,1,"testfeature10",2,0,0)) {returnval = -1;};
|
mas01ik@355
|
71
|
mas01ik@355
|
72 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -K /dev/null > testoutput
|
mas01ik@355
|
73 //cat /dev/null > test-expected-output
|
mas01ik@355
|
74 //cmp testoutput test-expected-output
|
mas01ik@355
|
75 myadbquery.querytype="sequence";
|
mas01ik@355
|
76 myadbquery.feature="testquery";
|
mas01ik@355
|
77 myadbquery.keylist="/dev/null";
|
mas01ik@355
|
78 myadbquery.sequencelength="1";
|
mas01ik@355
|
79 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
80 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
81 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
82
|
mas01ik@355
|
83 /* check the test values */
|
mas01ik@355
|
84 if (size != 0) {returnval = -1;};
|
mas01ik@355
|
85
|
mas01ik@355
|
86 ///echo testfeature01 > testkl.txt
|
mas01ik@355
|
87 makekeylistfile("testkl.txt","testfeature01");
|
mas01ik@355
|
88
|
mas01ik@355
|
89 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -K testkl.txt > testoutput
|
mas01ik@355
|
90 ///echo testfeature01 0 0 0 > test-expected-output
|
mas01ik@355
|
91 ///cmp testoutput test-expected-output
|
mas01ik@355
|
92 myadbquery.querytype="sequence";
|
mas01ik@355
|
93 myadbquery.feature="testquery";
|
mas01ik@355
|
94 myadbquery.keylist="testkl.txt";
|
mas01ik@355
|
95 myadbquery.sequencelength="1";
|
mas01ik@355
|
96 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
97
|
mas01ik@355
|
98 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
99 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
100
|
mas01ik@355
|
101 /* check the test values */
|
mas01ik@355
|
102 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
103 if (testoneresult(&myadbqueryresult,0,"testfeature01",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
104
|
mas01ik@355
|
105 ///echo testfeature10 > testkl.txt
|
mas01ik@355
|
106 makekeylistfile("testkl.txt","testfeature10");
|
mas01ik@355
|
107
|
mas01ik@355
|
108 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -K testkl.txt > testoutput
|
mas01ik@355
|
109 ///echo testfeature10 2 0 0 > test-expected-output
|
mas01ik@355
|
110 ///cmp testoutput test-expected-output
|
mas01ik@355
|
111 myadbquery.querytype="sequence";
|
mas01ik@355
|
112 myadbquery.feature="testquery";
|
mas01ik@355
|
113 myadbquery.keylist="testkl.txt";
|
mas01ik@355
|
114 myadbquery.sequencelength="1";
|
mas01ik@355
|
115 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
116
|
mas01ik@355
|
117 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
118 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
119
|
mas01ik@355
|
120 /* check the test values */
|
mas01ik@355
|
121 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
122 if (testoneresult(&myadbqueryresult,0,"testfeature10",2,0,0)) {returnval = -1;};
|
mas01ik@355
|
123
|
mas01ik@355
|
124 ///echo testfeature10 > testkl.txt
|
mas01ik@355
|
125 makekeylistfile("testkl.txt","testfeature10");
|
mas01ik@355
|
126
|
mas01ik@355
|
127 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -K testkl.txt -r 1 > testoutput
|
mas01ik@355
|
128 ///echo testfeature10 2 0 0 > test-expected-output
|
mas01ik@355
|
129 ///cmp testoutput test-expected-output
|
mas01ik@355
|
130 myadbquery.querytype="sequence";
|
mas01ik@355
|
131 myadbquery.feature="testquery";
|
mas01ik@355
|
132 myadbquery.keylist="testkl.txt";
|
mas01ik@355
|
133 myadbquery.sequencelength="1";
|
mas01ik@355
|
134 myadbquery.resultlength="1";
|
mas01ik@355
|
135 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
136
|
mas01ik@355
|
137 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
138 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
139
|
mas01ik@355
|
140 /* check the test values */
|
mas01ik@355
|
141 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
142 if (testoneresult(&myadbqueryresult,0,"testfeature10",2,0,0)) {returnval = -1;};
|
mas01ik@355
|
143
|
mas01ik@355
|
144 ///echo "query point (0.5,0.0)"
|
mas01ik@355
|
145 ///intstring 2 > testquery
|
mas01ik@355
|
146 ///floatstring 0.5 0 >> testquery
|
mas01ik@355
|
147 ivals[0]=2;
|
mas01ik@355
|
148 dvals[0]=0.5; dvals[1]=0.0;
|
mas01ik@355
|
149 maketestfile("testquery",ivals,dvals,2);
|
mas01ik@355
|
150
|
mas01ik@355
|
151 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
|
mas01ik@355
|
152 ///echo testfeature10 0 0 0 > test-expected-output
|
mas01ik@355
|
153 ///echo testfeature01 2 0 0 >> test-expected-output
|
mas01ik@355
|
154 ///cmp testoutput test-expected-output
|
mas01ik@355
|
155 myadbquery.querytype="sequence";
|
mas01ik@355
|
156 myadbquery.feature="testquery";
|
mas01ik@355
|
157 myadbquery.keylist=NULL;
|
mas01ik@355
|
158 myadbquery.sequencelength="1";
|
mas01ik@355
|
159 myadbquery.resultlength=NULL;
|
mas01ik@355
|
160 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
161
|
mas01ik@355
|
162 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
163 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
164
|
mas01ik@355
|
165 /* check the test values */
|
mas01ik@355
|
166 if (size != 2) {returnval = -1;};
|
mas01ik@355
|
167 if (testoneresult(&myadbqueryresult,0,"testfeature10",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
168 if (testoneresult(&myadbqueryresult,1,"testfeature01",2,0,0)) {returnval = -1;};
|
mas01ik@355
|
169
|
mas01ik@355
|
170 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -K /dev/null > testoutput
|
mas01ik@355
|
171 ///cat /dev/null > test-expected-output
|
mas01ik@355
|
172 ///cmp testoutput test-expected-output
|
mas01ik@355
|
173 myadbquery.querytype="sequence";
|
mas01ik@355
|
174 myadbquery.feature="testquery";
|
mas01ik@355
|
175 myadbquery.keylist="/dev/null";
|
mas01ik@355
|
176 myadbquery.sequencelength="1";
|
mas01ik@355
|
177 myadbquery.resultlength=NULL;
|
mas01ik@355
|
178 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
179
|
mas01ik@355
|
180 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
181 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
182
|
mas01ik@355
|
183 /* check the test values */
|
mas01ik@355
|
184 if (size != 0) {returnval = -1;};
|
mas01ik@355
|
185
|
mas01ik@355
|
186 ///echo testfeature10 > testkl.txt
|
mas01ik@355
|
187 makekeylistfile("testkl.txt","testfeature10");
|
mas01ik@355
|
188
|
mas01ik@355
|
189 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -K testkl.txt > testoutput
|
mas01ik@355
|
190 ///echo testfeature10 0 0 0 > test-expected-output
|
mas01ik@355
|
191 //cmp testoutput test-expected-output
|
mas01ik@355
|
192 myadbquery.querytype="sequence";
|
mas01ik@355
|
193 myadbquery.feature="testquery";
|
mas01ik@355
|
194 myadbquery.keylist="testkl.txt";
|
mas01ik@355
|
195 myadbquery.sequencelength="1";
|
mas01ik@355
|
196 myadbquery.resultlength=NULL;
|
mas01ik@355
|
197 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
198
|
mas01ik@355
|
199 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
200 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
201
|
mas01ik@355
|
202 /* check the test values */
|
mas01ik@355
|
203 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
204 if (testoneresult(&myadbqueryresult,0,"testfeature10",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
205
|
mas01ik@355
|
206
|
mas01ik@355
|
207 ///echo testfeature01 > testkl.txt
|
mas01ik@355
|
208 makekeylistfile("testkl.txt","testfeature01");
|
mas01ik@355
|
209
|
mas01ik@355
|
210 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -K testkl.txt > testoutput
|
mas01ik@355
|
211 ///echo testfeature01 2 0 0 > test-expected-output
|
mas01ik@355
|
212 ///cmp testoutput test-expected-output
|
mas01ik@355
|
213 myadbquery.querytype="sequence";
|
mas01ik@355
|
214 myadbquery.feature="testquery";
|
mas01ik@355
|
215 myadbquery.keylist="testkl.txt";
|
mas01ik@355
|
216 myadbquery.sequencelength="1";
|
mas01ik@355
|
217 myadbquery.resultlength=NULL;
|
mas01ik@355
|
218 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
219
|
mas01ik@355
|
220 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
221 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
222
|
mas01ik@355
|
223 /* check the test values */
|
mas01ik@355
|
224 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
225 if (testoneresult(&myadbqueryresult,0,"testfeature01",2,0,0)) {returnval = -1;};
|
mas01ik@355
|
226
|
mas01ik@355
|
227 ///echo testfeature01 > testkl.txt
|
mas01ik@355
|
228 makekeylistfile("testkl.txt","testfeature01");
|
mas01ik@355
|
229
|
mas01ik@355
|
230 ///${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -K testkl.txt -r 1 > testoutput
|
mas01ik@355
|
231 ///echo testfeature01 2 0 0 > test-expected-output
|
mas01ik@355
|
232 ///cmp testoutput test-expected-output
|
mas01ik@355
|
233 myadbquery.querytype="sequence";
|
mas01ik@355
|
234 myadbquery.feature="testquery";
|
mas01ik@355
|
235 myadbquery.keylist="testkl.txt";
|
mas01ik@355
|
236 myadbquery.sequencelength="1";
|
mas01ik@355
|
237 myadbquery.resultlength="1";
|
mas01ik@355
|
238 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
239
|
mas01ik@355
|
240 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
241 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
242
|
mas01ik@355
|
243 /* check the test values */
|
mas01ik@355
|
244 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
245 if (testoneresult(&myadbqueryresult,0,"testfeature01",2,0,0)) {returnval = -1;};
|
mas01ik@355
|
246
|
mas01ik@355
|
247
|
mas01ik@355
|
248
|
mas01ik@355
|
249 //printf("returnval:%d\n",returnval);
|
mas01ik@355
|
250
|
mas01ik@355
|
251 return(returnval);
|
mas01ik@355
|
252 }
|
mas01ik@355
|
253
|