comparison libtests/0027/prog1.c @ 492:f6b126b018d8 api-inversion

Yet more audiodb_query() deletions. Also delete the libtests/notes file, with its misleading and wrong questions, to avoid further confusion.
author mas01cr
date Sat, 10 Jan 2009 15:33:07 +0000
parents f4dc8e47ee37
children
comparison
equal deleted inserted replaced
491:29d28cfe0222 492:f6b126b018d8
1 #include "audioDB_API.h" 1 #include "audioDB_API.h"
2 #include "test_utils_lib.h" 2 #include "test_utils_lib.h"
3 3
4 int main(int argc, char **argv) {
5 adb_t *adb;
4 6
5 int main(int argc, char **argv){ 7 clean_remove_db(TESTDB);
8 if(!(adb = audiodb_create(TESTDB, 0, 0, 0)))
9 return 1;
6 10
7 int returnval=0; 11 adb_datum_t feature = {2, 2, "testfeature", (double[4]){0, 1, 1, 0},
8 adb_ptr mydbp={0}; 12 (double[2]){-0.5, -1}};
9 int ivals[10]; 13 if(!audiodb_insert_datum(adb, &feature))
10 double dvals[10]; 14 return 1;
11 adb_insert_t myinsert={0}; 15 if(audiodb_power(adb))
12 unsigned int myerr=0; 16 return 1;
13 char * databasename="testdb"; 17 feature.power = NULL;
14 adb_query_t myadbquery={0}; 18 if(!audiodb_insert_datum(adb, &feature))
15 adb_queryresult_t myadbqueryresult={0}; 19 return 1;
16 adb_query_t myadbquery2={0}; 20 feature.power = (double[2]){-0.5, -1};
17 adb_queryresult_t myadbqueryresult2={0}; 21 if(audiodb_insert_datum(adb, &feature))
18 int size=0; 22 return 1;
19 23
24 if(audiodb_l2norm(adb))
25 return 1;
20 26
21 /* remove old directory */ 27 adb_datum_t query = {1, 2, "testquery", (double[2]) {0, 0.5}};
22 //if [ -f testdb ]; then rm -f testdb; fi 28 adb_query_id_t qid = {0};
23 clean_remove_db(databasename); 29 qid.datum = &query;
30 qid.sequence_length = 1;
31 qid.sequence_start = 0;
32 adb_query_parameters_t parms =
33 {ADB_ACCUMULATION_PER_TRACK, ADB_DISTANCE_EUCLIDEAN_NORMED, 10, 10};
34 adb_query_refine_t refine = {0};
35 refine.hopsize = 1;
24 36
25 /* create new db */ 37 adb_query_spec_t spec;
26 //${AUDIODB} -d testdb -N 38 spec.qid = qid;
27 mydbp=audiodb_create(databasename,0,0,0); 39 spec.params = parms;
40 spec.refine = refine;
28 41
29 //intstring 2 > testfeature 42 adb_query_results_t *results = audiodb_query_spec(adb, &spec);
30 //floatstring 0 1 >> testfeature 43 if(!results || results->nresults != 2) return 1;
31 //floatstring 1 0 >> testfeature 44 result_present_or_fail(results, "testfeature", 0, 0, 0);
32 ivals[0]=2; 45 result_present_or_fail(results, "testfeature", 2, 0, 1);
33 dvals[0]=0; dvals[1]=1; dvals[2]=1; dvals[3]=0; 46 audiodb_query_free_results(adb, &spec, results);
34 maketestfile("testfeature",ivals,dvals,4);
35 47
36 //intstring 1 > testpower 48 spec.params.npoints = 1;
37 //floatstring -0.5 >> testpower 49 results = audiodb_query_spec(adb, &spec);
38 //floatstring -1 >> testpower 50 if(!results || results->nresults != 1) return 1;
39 ivals[0]=1; 51 result_present_or_fail(results, "testfeature", 0, 0, 0);
40 dvals[0]=-0.5; dvals[1]=-1; 52 audiodb_query_free_results(adb, &spec, results);
41 maketestfile("testpower",ivals,dvals,2);
42 53
43 /* insert breaks because power flag off and power insert */ 54 spec.qid.datum->data = (double [2]) {0.5, 0};
44 //expect_clean_error_exit ${AUDIODB} -d testdb -I -f testfeature -w testpower 55 spec.params.npoints = 10;
45 myinsert.features="testfeature"; 56 results = audiodb_query_spec(adb, &spec);
46 myinsert.power="testpower"; 57 if(!results || results->nresults != 2) return 1;
47 if (!audiodb_insert(mydbp,&myinsert)){ returnval=-1; } 58 result_present_or_fail(results, "testfeature", 0, 0, 1);
59 result_present_or_fail(results, "testfeature", 2, 0, 0);
60 audiodb_query_free_results(adb, &spec, results);
61
62 spec.params.npoints = 1;
63 results = audiodb_query_spec(adb, &spec);
64 if(!results || results->nresults != 1) return 1;
65 result_present_or_fail(results, "testfeature", 0, 0, 1);
66 audiodb_query_free_results(adb, &spec, results);
48 67
49 68 /* queries with associated power data */
50 /* make sure power can be turned on */ 69 spec.qid.datum->data = (double [2]) {0, 0.5};
51 //${AUDIODB} -d testdb -P 70 spec.qid.datum->power = (double [1]) {-0.5};
52 if(audiodb_power(mydbp)){ returnval=-1; }; 71 spec.params.npoints = 10;
72 spec.refine.flags = ADB_REFINE_ABSOLUTE_THRESHOLD;
73 spec.refine.absolute_threshold = -1.4;
74 results = audiodb_query_spec(adb, &spec);
75 if(!results || results->nresults != 2) return 1;
76 result_present_or_fail(results, "testfeature", 0, 0, 0);
77 result_present_or_fail(results, "testfeature", 2, 0, 1);
78 audiodb_query_free_results(adb, &spec, results);
53 79
80 spec.refine.absolute_threshold = -0.6;
81 results = audiodb_query_spec(adb, &spec);
82 if(!results || results->nresults != 1) return 1;
83 result_present_or_fail(results, "testfeature", 0, 0, 0);
84 audiodb_query_free_results(adb, &spec, results);
54 85
55 /* inserts now require power also */ 86 spec.refine.absolute_threshold = -0.2;
56 ////expect_clean_error_exit ${AUDIODB} -d testdb -I -f testfeature 87 results = audiodb_query_spec(adb, &spec);
57 myinsert.features="testfeature"; 88 if(!results || results->nresults != 0) return 1;
58 myinsert.power=NULL; 89 audiodb_query_free_results(adb, &spec, results);
59 //myerr=audiodb_insert(mydbp,&myinsert);
60 if (!audiodb_insert(mydbp,&myinsert)){ returnval=-1; }
61 90
62 /* now make a real insert */ 91 spec.refine.absolute_threshold = 0;
63 //${AUDIODB} -d testdb -I -f testfeature -w testpower 92 spec.refine.flags = ADB_REFINE_RELATIVE_THRESHOLD;
64 myinsert.features="testfeature"; 93 spec.refine.relative_threshold = 1;
65 myinsert.power="testpower"; 94 results = audiodb_query_spec(adb, &spec);
66 //myerr=audiodb_insert(mydbp,&myinsert); 95 if(!results || results->nresults != 2) return 1;
67 if (audiodb_insert(mydbp,&myinsert)){ returnval=-1; } 96 result_present_or_fail(results, "testfeature", 0, 0, 0);
97 result_present_or_fail(results, "testfeature", 2, 0, 1);
98 audiodb_query_free_results(adb, &spec, results);
68 99
100 spec.refine.relative_threshold = 0.2;
101 results = audiodb_query_spec(adb, &spec);
102 if(!results || results->nresults != 1) return 1;
103 result_present_or_fail(results, "testfeature", 0, 0, 0);
104 audiodb_query_free_results(adb, &spec, results);
69 105
70 //# sequence queries require L2NORM 106 spec.qid.datum->data = (double [2]) {0.5, 0};
71 //${AUDIODB} -d testdb -L 107 spec.refine.flags = ADB_REFINE_ABSOLUTE_THRESHOLD;
72 if(audiodb_l2norm(mydbp)){ returnval=-1; }; 108 spec.refine.absolute_threshold = -1.4;
109 results = audiodb_query_spec(adb, &spec);
110 if(!results || results->nresults != 2) return 1;
111 result_present_or_fail(results, "testfeature", 0, 0, 1);
112 result_present_or_fail(results, "testfeature", 2, 0, 0);
113 audiodb_query_free_results(adb, &spec, results);
73 114
115 spec.refine.absolute_threshold = -0.6;
116 results = audiodb_query_spec(adb, &spec);
117 if(!results || results->nresults != 1) return 1;
118 result_present_or_fail(results, "testfeature", 2, 0, 0);
119 audiodb_query_free_results(adb, &spec, results);
74 120
75 //# queries without power files should run as before 121 spec.refine.absolute_threshold = -0.2;
76 //echo "query point (0.0,0.5)" 122 results = audiodb_query_spec(adb, &spec);
77 //intstring 2 > testquery 123 if(!results || results->nresults != 0) return 1;
78 //floatstring 0 0.5 >> testquery 124 audiodb_query_free_results(adb, &spec, results);
79 ivals[0]=2;
80 dvals[0]=-0; dvals[1]=0.5;
81 maketestfile("testquery",ivals,dvals,2);
82 125
126 spec.refine.absolute_threshold = 0;
127 spec.refine.flags = ADB_REFINE_RELATIVE_THRESHOLD;
128 spec.refine.relative_threshold = 1;
129 results = audiodb_query_spec(adb, &spec);
130 if(!results || results->nresults != 2) return 1;
131 result_present_or_fail(results, "testfeature", 0, 0, 1);
132 result_present_or_fail(results, "testfeature", 2, 0, 0);
133 audiodb_query_free_results(adb, &spec, results);
83 134
84 /* query 1 */ 135 spec.refine.relative_threshold = 0.2;
85 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput 136 results = audiodb_query_spec(adb, &spec);
86 //echo testfeature 1 0 0 > test-expected-output 137 if(!results || results->nresults != 1) return 1;
87 //cmp testoutput test-expected-output 138 result_present_or_fail(results, "testfeature", 2, 0, 0);
88 myadbquery.querytype="sequence"; 139 audiodb_query_free_results(adb, &spec, results);
89 myadbquery.feature="testquery";
90 myadbquery.sequencelength="1";
91 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
92 size=myadbqueryresult.sizeRlist;
93 140
94 /* check the test values */ 141 audiodb_close(adb);
95 if (size != 1) {returnval = -1;};
96 if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};
97 142
98 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput 143 return 104;
99 //echo testfeature 0 0 0 > test-expected-output
100 //cmp testoutput test-expected-output
101 myadbquery.querytype="sequence";
102 myadbquery.feature="testquery";
103 myadbquery.sequencelength="1";
104 myadbquery.numpoints="1";
105 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
106 size=myadbqueryresult.sizeRlist;
107
108 /* check the test values */
109 if (size != 1) {returnval = -1;};
110 if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};
111
112 //echo "query point (0.5,0.0)"
113 //intstring 2 > testquery
114 //floatstring 0.5 0 >> testquery
115 ivals[0]=2;
116 dvals[0]=0.5; dvals[1]=0.0;
117 maketestfile("testquery",ivals,dvals,2);
118
119 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
120 //echo testfeature 1 0 1 > test-expected-output
121 //cmp testoutput test-expected-output
122 myadbquery.querytype="sequence";
123 myadbquery.feature="testquery";
124 myadbquery.sequencelength="1";
125 myadbquery.numpoints=NULL;
126 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
127 size=myadbqueryresult.sizeRlist;
128
129 /* check the test values */
130 if (size != 1) {returnval = -1;};
131 if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,1)) {returnval = -1;};
132
133 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
134 //echo testfeature 0 0 1 > test-expected-output
135 //cmp testoutput test-expected-output
136 myadbquery.querytype="sequence";
137 myadbquery.feature="testquery";
138 myadbquery.sequencelength="1";
139 myadbquery.numpoints="1";
140 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
141 size=myadbqueryresult.sizeRlist;
142
143 /* check the test values */
144 if (size != 1) {returnval = -1;};
145 if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,1)) {returnval = -1;};
146
147
148
149 //# queries with power files might do something different
150 //echo "query point (0.0,0.5), p=-0.5"
151 //intstring 2 > testquery
152 //floatstring 0 0.5 >> testquery
153 //intstring 1 > testquerypower
154 //floatstring -0.5 >> testquerypower
155 ivals[0]=2;
156 dvals[0]=-0; dvals[1]=0.5;
157 maketestfile("testquery",ivals,dvals,2);
158 ivals[0]=1;
159 dvals[0]=-0.5;
160 maketestfile("testquerypower",ivals,dvals,1);
161
162 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-1.4 > testoutput
163 //echo testfeature 1 0 0 > test-expected-output
164 //cmp testoutput test-expected-output
165 myadbquery.querytype="sequence";
166 myadbquery.feature="testquery";
167 myadbquery.sequencelength="1";
168 myadbquery.power="testquerypower";
169 myadbquery.numpoints=NULL;
170 myadbquery.absolute_threshold=-1.4;
171 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
172 size=myadbqueryresult.sizeRlist;
173
174 /* check the test values */
175 if (size != 1) {returnval = -1;};
176 if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};
177
178 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.6 > testoutput
179 //echo testfeature 0 0 0 > test-expected-output
180 //cmp testoutput test-expected-output
181 myadbquery.querytype="sequence";
182 myadbquery.feature="testquery";
183 myadbquery.sequencelength="1";
184 myadbquery.power="testquerypower";
185 myadbquery.numpoints=NULL;
186 myadbquery.absolute_threshold=-0.6;
187 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
188 size=myadbqueryresult.sizeRlist;
189
190 /* check the test values */
191 if (size != 1) {returnval = -1;};
192 if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};
193
194
195 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.2 > testoutput
196 //cat /dev/null > test-expected-output
197 //cmp testoutput test-expected-output
198
199 myadbquery.querytype="sequence";
200 myadbquery.feature="testquery";
201 myadbquery.sequencelength="1";
202 myadbquery.power="testquerypower";
203 myadbquery.numpoints=NULL;
204 myadbquery.absolute_threshold=-0.2;
205 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
206 size=myadbqueryresult.sizeRlist;
207
208 /* check the test values */
209 if (size != 0) {returnval = -1;};
210
211
212
213 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=1 > testoutput
214 //echo testfeature 1 0 0 > test-expected-output
215 //cmp testoutput test-expected-output
216 myadbquery.querytype="sequence";
217 myadbquery.feature="testquery";
218 myadbquery.sequencelength="1";
219 myadbquery.power="testquerypower";
220 myadbquery.numpoints=NULL;
221 myadbquery.absolute_threshold=0;
222 myadbquery.relative_threshold=1;
223 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
224 size=myadbqueryresult.sizeRlist;
225
226 /* check the test values */
227 if (size != 1) {returnval = -1;};
228 if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};
229
230
231 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=0.2 > testoutput
232 //echo testfeature 0 0 0 > test-expected-output
233 //cmp testoutput test-expected-output
234 myadbquery.querytype="sequence";
235 myadbquery.feature="testquery";
236 myadbquery.sequencelength="1";
237 myadbquery.power="testquerypower";
238 myadbquery.numpoints=NULL;
239 myadbquery.absolute_threshold=0;
240 myadbquery.relative_threshold=0.2;
241 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
242 size=myadbqueryresult.sizeRlist;
243
244 /* check the test values */
245 if (size != 1) {returnval = -1;};
246 if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};
247
248
249 //echo "query point (0.5,0.0), p=-0.5"
250 //intstring 2 > testquery
251 //floatstring 0.5 0 >> testquery
252 ivals[0]=2;
253 dvals[0]=0.5; dvals[1]=0.0;
254 maketestfile("testquery",ivals,dvals,2);
255
256
257 //audioDB -Q sequence -d testdb -f testquery -w testquerypower -l 1 --absolute-threshold -1.400000
258 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-1.4 > testoutput
259 //echo testfeature 1 0 1 > test-expected-output
260 //cmp testoutput test-expected-output
261 myadbquery2.querytype="sequence";
262 myadbquery2.feature="testquery";
263 myadbquery2.sequencelength="1";
264 myadbquery2.power="testquerypower";
265 myadbquery2.numpoints=NULL;
266 myadbquery2.absolute_threshold=-1.4;
267 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
268 size=myadbqueryresult2.sizeRlist;
269
270 /* check the test values */
271 if (size != 1) {returnval = -1;};
272 if (testoneresult(&myadbqueryresult2,0,"testfeature",1,0,1)) {returnval = -1;};
273
274
275 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.6 > testoutput
276 //echo testfeature 2 0 0 > test-expected-output
277 //cmp testoutput test-expected-output
278 myadbquery2.querytype="sequence";
279 myadbquery2.feature="testquery";
280 myadbquery2.sequencelength="1";
281 myadbquery2.power="testquerypower";
282 myadbquery2.numpoints=NULL;
283 myadbquery2.absolute_threshold=-0.6;
284 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
285 size=myadbqueryresult2.sizeRlist;
286
287 /* check the test values */
288 if (size != 1) {returnval = -1;};
289 if (testoneresult(&myadbqueryresult2,0,"testfeature",2,0,0)) {returnval = -1;};
290
291
292 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.2 > testoutput
293 //cat /dev/null > test-expected-output
294 //cmp testoutput test-expected-output
295 myadbquery2.querytype="sequence";
296 myadbquery2.feature="testquery";
297 myadbquery2.sequencelength="1";
298 myadbquery2.power="testquerypower";
299 myadbquery2.numpoints=NULL;
300 myadbquery2.absolute_threshold=-0.2;
301 myadbquery2.relative_threshold=0.0;
302 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
303 size=myadbqueryresult2.sizeRlist;
304
305 /* check the test values */
306 if (size != 0) {returnval = -1;};
307
308
309 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=1 > testoutput
310 //echo testfeature 1 0 1 > test-expected-output
311 //cmp testoutput test-expected-output
312 myadbquery2.querytype="sequence";
313 myadbquery2.feature="testquery";
314 myadbquery2.sequencelength="1";
315 myadbquery2.power="testquerypower";
316 myadbquery2.numpoints=NULL;
317 myadbquery2.absolute_threshold=0.0;
318 myadbquery2.relative_threshold=1;
319 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
320 size=myadbqueryresult2.sizeRlist;
321
322 /* check the test values */
323 if (size != 1) {returnval = -1;};
324 if (testoneresult(&myadbqueryresult2,0,"testfeature",1,0,1)) {returnval = -1;};
325
326
327
328 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=0.2 > testoutput
329 //echo testfeature 2 0 0 > test-expected-output
330 //cmp testoutput test-expected-output
331 myadbquery2.querytype="sequence";
332 myadbquery2.feature="testquery";
333 myadbquery2.sequencelength="1";
334 myadbquery2.power="testquerypower";
335 myadbquery2.numpoints=NULL;
336 myadbquery2.absolute_threshold=-0.0;
337 myadbquery2.relative_threshold=0.1;
338 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
339 size=myadbqueryresult2.sizeRlist;
340
341 /* check the test values */
342 if (size != 1) {returnval = -1;};
343 if (testoneresult(&myadbqueryresult2,0,"testfeature",2,0,0)) {returnval = -1;};
344
345 // printf("returnval:%d\n",returnval);
346 return(returnval);
347 } 144 }
348