mas01cr@487
|
1 #include "audioDB_API.h"
|
mas01cr@487
|
2 #include "test_utils_lib.h"
|
mas01ik@355
|
3
|
mas01ik@355
|
4 void maketimesfile(char * filename);
|
mas01ik@355
|
5
|
mas01ik@355
|
6 int main(int argc, char **argv){
|
mas01ik@355
|
7
|
mas01ik@355
|
8 int returnval=0;
|
mas01ik@355
|
9 adb_ptr mydbp={0};
|
mas01ik@355
|
10 int ivals[10];
|
mas01ik@355
|
11 double dvals[10];
|
mas01ik@355
|
12 adb_insert_t myinsert={0};
|
mas01ik@355
|
13 char * databasename="testdb";
|
mas01ik@355
|
14 adb_query_t myadbquery={0};
|
mas01ik@355
|
15 adb_queryresult_t myadbqueryresult={0};
|
mas01ik@355
|
16 int size=0;
|
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 > testfeature
|
mas01ik@355
|
27 //floatstring 0 0.5 >> testfeature
|
mas01ik@355
|
28 //floatstring 0.5 0 >> testfeature
|
mas01ik@355
|
29 ivals[0]=2;
|
mas01ik@355
|
30 dvals[0]=0; dvals[1]=0.5; dvals[2]=0.5; dvals[3]=0;
|
mas01ik@355
|
31 maketestfile("testfeature",ivals,dvals,4);
|
mas01ik@355
|
32
|
mas01ik@355
|
33
|
mas01ik@355
|
34 //cat > testtimes <<EOF
|
mas01ik@355
|
35 //0
|
mas01ik@355
|
36 //1
|
mas01ik@355
|
37 //2
|
mas01ik@355
|
38 //EOF
|
mas01ik@355
|
39 maketimesfile("testtimes");
|
mas01ik@355
|
40
|
mas01ik@355
|
41 //${AUDIODB} -d testdb -I -f testfeature -t testtimes
|
mas01ik@355
|
42 myinsert.features="testfeature";
|
mas01ik@355
|
43 if(audiodb_insert(mydbp,&myinsert)){
|
mas01ik@355
|
44 returnval=-1;
|
mas01ik@355
|
45 };
|
mas01ik@355
|
46
|
mas01ik@355
|
47 //# sequence queries require L2NORM
|
mas01ik@355
|
48 //${AUDIODB} -d testdb -L
|
mas01ik@355
|
49 if(audiodb_l2norm(mydbp)){
|
mas01ik@355
|
50 returnval=-1;
|
mas01ik@355
|
51 };
|
mas01ik@355
|
52
|
mas01ik@355
|
53 //echo "query point (0.0,0.5)"
|
mas01ik@355
|
54 //intstring 2 > testquery
|
mas01ik@355
|
55 //floatstring 0 0.5 >> testquery
|
mas01ik@355
|
56 ivals[0]=2;
|
mas01ik@355
|
57 dvals[0]=0; dvals[1]=0.5;
|
mas01ik@355
|
58 maketestfile("testquery",ivals,dvals,2);
|
mas01ik@355
|
59
|
mas01ik@355
|
60 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
|
mas01ik@355
|
61 //echo testfeature 1 0 0 > test-expected-output
|
mas01ik@355
|
62 //cmp testoutput test-expected-output
|
mas01ik@355
|
63 myadbquery.querytype="sequence";
|
mas01ik@355
|
64 myadbquery.feature="testquery";
|
mas01ik@355
|
65 myadbquery.sequencelength="1";
|
mas01ik@355
|
66 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
67 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
68
|
mas01ik@355
|
69 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
70 ///* check the test values */
|
mas01ik@355
|
71 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
72 if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};
|
mas01ik@355
|
73
|
mas01ik@355
|
74
|
mas01ik@355
|
75 ////${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
|
mas01ik@355
|
76 ////echo testfeature 0 0 0 > test-expected-output
|
mas01ik@355
|
77 ////cmp testoutput test-expected-output
|
mas01ik@355
|
78 myadbquery.querytype="sequence";
|
mas01ik@355
|
79 myadbquery.feature="testquery";
|
mas01ik@355
|
80 myadbquery.sequencelength="1";
|
mas01ik@355
|
81 myadbquery.numpoints="1";
|
mas01ik@355
|
82 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
83 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
84
|
mas01ik@355
|
85 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
86 ///* check the test values */
|
mas01ik@355
|
87 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
88 if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
89
|
mas01ik@355
|
90 ////echo "query point (0.5,0.0)"
|
mas01ik@355
|
91 ////intstring 2 > testquery
|
mas01ik@355
|
92 ////floatstring 0.5 0 >> testquery
|
mas01ik@355
|
93 ivals[0]=2;
|
mas01ik@355
|
94 dvals[0]=0.5; dvals[1]=0.0;
|
mas01ik@355
|
95 maketestfile("testquery",ivals,dvals,2);
|
mas01ik@355
|
96
|
mas01ik@355
|
97 ////${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
|
mas01ik@355
|
98 ////echo testfeature 1 0 1 > test-expected-output
|
mas01ik@355
|
99 ////cmp testoutput test-expected-output
|
mas01ik@355
|
100 myadbquery.querytype="sequence";
|
mas01ik@355
|
101 myadbquery.feature="testquery";
|
mas01ik@355
|
102 myadbquery.sequencelength="1";
|
mas01ik@355
|
103 myadbquery.numpoints=NULL;
|
mas01ik@355
|
104 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
105 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
106
|
mas01ik@355
|
107 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
108 ///* check the test values */
|
mas01ik@355
|
109 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
110 if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,1)) {returnval = -1;};
|
mas01ik@355
|
111
|
mas01ik@355
|
112
|
mas01ik@355
|
113 ////${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
|
mas01ik@355
|
114 ////echo testfeature 0 0 1 > test-expected-output
|
mas01ik@355
|
115 ////cmp testoutput test-expected-output
|
mas01ik@355
|
116 myadbquery.querytype="sequence";
|
mas01ik@355
|
117 myadbquery.feature="testquery";
|
mas01ik@355
|
118 myadbquery.sequencelength="1";
|
mas01ik@355
|
119 myadbquery.numpoints="1";
|
mas01ik@355
|
120 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
121 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
122
|
mas01ik@355
|
123 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
124 ///* check the test values */
|
mas01ik@355
|
125 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
126 if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,1)) {returnval = -1;};
|
mas01ik@355
|
127
|
mas01ik@355
|
128
|
mas01ik@355
|
129
|
mas01ik@355
|
130 //printf("returnval:%d\n",returnval);
|
mas01ik@355
|
131 return(returnval);
|
mas01ik@355
|
132 }
|
mas01ik@355
|
133
|
mas01ik@355
|
134 void maketimesfile(char * filename){
|
mas01ik@355
|
135
|
mas01ik@355
|
136 FILE * myfile;
|
mas01ik@355
|
137
|
mas01ik@355
|
138 myfile=fopen(filename,"w");
|
mas01ik@355
|
139 fprintf(myfile,"0\n");
|
mas01ik@355
|
140 fprintf(myfile,"1\n");
|
mas01ik@355
|
141 fprintf(myfile,"2\n");
|
mas01ik@355
|
142 fflush(myfile);
|
mas01ik@355
|
143 fclose(myfile);
|
mas01ik@355
|
144
|
mas01ik@355
|
145 }
|