mas01ik@355
|
1 #include <stdio.h>
|
mas01ik@355
|
2 #include <stdlib.h>
|
mas01ik@355
|
3 #include <string.h>
|
mas01ik@355
|
4 #include <sysexits.h>
|
mas01ik@355
|
5 #include <fcntl.h>
|
mas01ik@355
|
6 #include <dirent.h>
|
mas01ik@355
|
7 #include <unistd.h>
|
mas01ik@355
|
8 #include <sys/stat.h>
|
mas01ik@355
|
9 /*
|
mas01ik@355
|
10 * * #define NDEBUG
|
mas01ik@355
|
11 * * */
|
mas01ik@355
|
12 #include <assert.h>
|
mas01ik@355
|
13
|
mas01ik@355
|
14 #include "../../audioDB_API.h"
|
mas01ik@355
|
15 #include "../test_utils_lib.h"
|
mas01ik@355
|
16
|
mas01ik@355
|
17
|
mas01ik@355
|
18 int main(int argc, char **argv){
|
mas01ik@355
|
19
|
mas01ik@355
|
20 int returnval=0;
|
mas01ik@355
|
21 adb_ptr mydbp={0};
|
mas01ik@355
|
22 int ivals[10];
|
mas01ik@355
|
23 double dvals[10];
|
mas01ik@355
|
24 adb_insert_t myinsert={0};
|
mas01ik@355
|
25 unsigned int myerr=0;
|
mas01ik@355
|
26 char * databasename="testdb";
|
mas01ik@355
|
27 adb_query_t myadbquery={0};
|
mas01ik@355
|
28 adb_queryresult_t myadbqueryresult={0};
|
mas01ik@355
|
29 adb_query_t myadbquery2={0};
|
mas01ik@355
|
30 adb_queryresult_t myadbqueryresult2={0};
|
mas01ik@355
|
31 int size=0;
|
mas01ik@355
|
32
|
mas01ik@355
|
33
|
mas01ik@355
|
34 /* remove old directory */
|
mas01ik@355
|
35 //if [ -f testdb ]; then rm -f testdb; fi
|
mas01ik@355
|
36 clean_remove_db(databasename);
|
mas01ik@355
|
37
|
mas01ik@355
|
38 /* create new db */
|
mas01ik@355
|
39 //${AUDIODB} -d testdb -N
|
mas01ik@355
|
40 mydbp=audiodb_create(databasename,0,0,0);
|
mas01ik@355
|
41
|
mas01ik@355
|
42 /* create testfeature file */
|
mas01ik@355
|
43 //intstring 2 > testfeature
|
mas01ik@355
|
44 //floatstring 0 1 >> testfeature
|
mas01ik@355
|
45 //floatstring 1 0 >> testfeature
|
mas01ik@355
|
46 ivals[0]=2;
|
mas01ik@355
|
47 dvals[0]=0; dvals[1]=1; dvals[2]=1; dvals[3]=0;
|
mas01ik@355
|
48 maketestfile("testfeature",ivals,dvals,4);
|
mas01ik@355
|
49
|
mas01ik@355
|
50
|
mas01ik@355
|
51 /* insert */
|
mas01ik@355
|
52 //${AUDIODB} -d testdb -I -f testfeature
|
mas01ik@355
|
53 myinsert.features="testfeature";
|
mas01ik@355
|
54 if(audiodb_insert(mydbp,&myinsert)){
|
mas01ik@355
|
55 returnval=-1;
|
mas01ik@355
|
56 };
|
mas01ik@355
|
57
|
mas01ik@355
|
58
|
mas01ik@355
|
59 /* turn on L2NORM */
|
mas01ik@355
|
60 //# sequence queries require L2NORM
|
mas01ik@355
|
61 //${AUDIODB} -d testdb -L
|
mas01ik@355
|
62 audiodb_l2norm(mydbp);
|
mas01ik@355
|
63
|
mas01ik@355
|
64 /* make a test query */
|
mas01ik@355
|
65 //echo "query point (0.0,0.5)"
|
mas01ik@355
|
66 //intstring 2 > testquery
|
mas01ik@355
|
67 //floatstring 0 0.5 >> testquery
|
mas01ik@355
|
68 ivals[0]=2;
|
mas01ik@355
|
69 dvals[0]=0; dvals[1]=0.5; dvals[2]=0; dvals[3]=0;
|
mas01ik@355
|
70 maketestfile("testquery",ivals,dvals,2);
|
mas01ik@355
|
71
|
mas01ik@355
|
72 /* test a sequence query */
|
mas01ik@355
|
73 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
|
mas01ik@355
|
74 //echo testfeature 1 0 0 > test-expected-output
|
mas01ik@355
|
75 //cmp testoutput test-expected-output
|
mas01ik@355
|
76 myadbquery.querytype="sequence";
|
mas01ik@355
|
77 myadbquery.feature="testquery";
|
mas01ik@355
|
78 myadbquery.sequencelength="1";
|
mas01ik@355
|
79 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
80 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
81
|
mas01ik@355
|
82 /* check the test values */
|
mas01ik@355
|
83 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
84 if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};
|
mas01ik@355
|
85
|
mas01ik@355
|
86
|
mas01ik@355
|
87 /* same but with limites */
|
mas01ik@355
|
88 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
|
mas01ik@355
|
89 //echo testfeature 0 0 0 > test-expected-output
|
mas01ik@355
|
90 //cmp testoutput test-expected-output
|
mas01ik@355
|
91 myadbquery.numpoints="1";
|
mas01ik@355
|
92 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
93 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
94
|
mas01ik@355
|
95 /* check the test values */
|
mas01ik@355
|
96 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
97 if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
98
|
mas01ik@355
|
99 /* make another query */
|
mas01ik@355
|
100 //echo "query point (0.5,0.0)"
|
mas01ik@355
|
101 //intstring 2 > testquery
|
mas01ik@355
|
102 //floatstring 0.5 0 >> testquery
|
mas01ik@355
|
103 ivals[0]=2;
|
mas01ik@355
|
104 dvals[0]=0.5; dvals[1]=0.0; dvals[2]=0; dvals[3]=0;
|
mas01ik@355
|
105 maketestfile("testquery",ivals,dvals,2);
|
mas01ik@355
|
106
|
mas01ik@355
|
107
|
mas01ik@355
|
108 /* test new query */
|
mas01ik@355
|
109 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
|
mas01ik@355
|
110 //echo testfeature 1 0 1 > test-expected-output
|
mas01ik@355
|
111 //cmp testoutput test-expected-output
|
mas01ik@355
|
112
|
mas01ik@355
|
113 myadbquery2.querytype="sequence";
|
mas01ik@355
|
114 myadbquery2.feature="testquery";
|
mas01ik@355
|
115 myadbquery2.sequencelength="1";
|
mas01ik@355
|
116 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
|
mas01ik@355
|
117 size=myadbqueryresult2.sizeRlist;
|
mas01ik@355
|
118
|
mas01ik@355
|
119 /* check the test values */
|
mas01ik@355
|
120 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
121 if (testoneresult(&myadbqueryresult2,0,"testfeature",1,0,1)) {returnval = -1;};
|
mas01ik@355
|
122
|
mas01ik@355
|
123
|
mas01ik@355
|
124 /* test new query with limits */
|
mas01ik@355
|
125 myadbquery2.numpoints="1";
|
mas01ik@355
|
126 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
|
mas01ik@355
|
127 size=myadbqueryresult2.sizeRlist;
|
mas01ik@355
|
128
|
mas01ik@355
|
129 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
|
mas01ik@355
|
130 //echo testfeature 0 0 1 > test-expected-output
|
mas01ik@355
|
131 //cmp testoutput test-expected-output
|
mas01ik@355
|
132
|
mas01ik@355
|
133
|
mas01ik@355
|
134 /* check the test values */
|
mas01ik@355
|
135 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
136 if (testoneresult(&myadbqueryresult2,0,"testfeature",0,0,1)) {returnval = -1;};
|
mas01ik@355
|
137
|
mas01ik@355
|
138
|
mas01ik@355
|
139
|
mas01ik@355
|
140 /* close */
|
mas01ik@355
|
141 audiodb_close(mydbp);
|
mas01ik@355
|
142
|
mas01ik@355
|
143 printf("returnval:%d\n",returnval);
|
mas01ik@355
|
144 return(returnval);
|
mas01ik@355
|
145 }
|
mas01ik@355
|
146
|
mas01ik@355
|
147
|