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 unsigned int myerr=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 adb_query_t myadbquery2={0};
|
mas01ik@355
|
17 adb_queryresult_t myadbqueryresult2={0};
|
mas01ik@355
|
18 int size=0;
|
mas01ik@355
|
19 adb_insert_t ins1[2]={0};
|
mas01ik@355
|
20
|
mas01ik@355
|
21 /* remove old directory */
|
mas01ik@355
|
22 //if [ -f testdb ]; then rm -f testdb; fi
|
mas01ik@355
|
23 clean_remove_db(databasename);
|
mas01ik@355
|
24
|
mas01ik@355
|
25 /* create new db */
|
mas01ik@355
|
26 //${AUDIODB} -d testdb -N
|
mas01ik@355
|
27 mydbp=audiodb_create(databasename,0,0,0);
|
mas01ik@355
|
28
|
mas01ik@355
|
29 //intstring 2 > testfeature01
|
mas01ik@355
|
30 //floatstring 0 1 >> testfeature01
|
mas01ik@355
|
31 //intstring 2 > testfeature10
|
mas01ik@355
|
32 //floatstring 1 0 >> testfeature10
|
mas01ik@355
|
33 ivals[0]=2;
|
mas01ik@355
|
34 dvals[0]=0; dvals[1]=1;
|
mas01ik@355
|
35 maketestfile("testfeature01",ivals,dvals,2);
|
mas01ik@355
|
36 ivals[0]=2;
|
mas01ik@355
|
37 dvals[0]=1; dvals[1]=0;
|
mas01ik@355
|
38 maketestfile("testfeature10",ivals,dvals,2);
|
mas01ik@355
|
39
|
mas01ik@355
|
40 //cat > testfeaturefiles <<EOF
|
mas01ik@355
|
41 //testfeature01
|
mas01ik@355
|
42 //testfeature10
|
mas01ik@355
|
43 //EOF
|
mas01ik@355
|
44 ins1[0].features="testfeature01";
|
mas01ik@355
|
45 ins1[1].features="testfeature10";
|
mas01ik@355
|
46
|
mas01ik@355
|
47
|
mas01ik@355
|
48 //${AUDIODB} -d testdb -B -F testfeaturefiles
|
mas01ik@355
|
49 returnval=audiodb_batchinsert(mydbp,ins1,2);
|
mas01ik@355
|
50
|
mas01ik@355
|
51 //# sequence queries require L2NORM
|
mas01ik@355
|
52 //${AUDIODB} -d testdb -L
|
mas01ik@355
|
53 audiodb_l2norm(mydbp);
|
mas01ik@355
|
54
|
mas01ik@355
|
55 //echo "exhaustive search"
|
mas01ik@355
|
56 //intstring 2 > testquery
|
mas01ik@355
|
57 //floatstring 0 0.5 >> testquery
|
mas01ik@355
|
58 //floatstring 0.5 0 >> testquery
|
mas01ik@355
|
59 ivals[0]=2;
|
mas01ik@355
|
60 dvals[0]=0; dvals[1]=0.5;
|
mas01ik@355
|
61 dvals[2]=0.5; dvals[3]=0;
|
mas01ik@355
|
62 maketestfile("testquery",ivals,dvals,4);
|
mas01ik@355
|
63
|
mas01ik@355
|
64 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -e > testoutput
|
mas01ik@355
|
65 //echo testfeature01 1 0 0 > test-expected-output
|
mas01ik@355
|
66 //echo testfeature10 1 1 0 >> test-expected-output
|
mas01ik@355
|
67 //cmp testoutput test-expected-output
|
mas01ik@355
|
68 myadbquery.querytype="sequence";
|
mas01ik@355
|
69 myadbquery.feature="testquery";
|
mas01ik@355
|
70 myadbquery.sequencelength="1";
|
mas01ik@355
|
71 myadbquery.exhaustive=1;
|
mas01ik@355
|
72 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
73 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
74
|
mas01ik@355
|
75 //printf("size:%d\n",size);
|
mas01ik@355
|
76 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
77 ///* check the test values */
|
mas01ik@355
|
78 if (size != 2) {returnval = -1;};
|
mas01ik@355
|
79 if (testoneresult(&myadbqueryresult,0,"testfeature01",1,0,0)) {returnval = -1;};
|
mas01ik@355
|
80 if (testoneresult(&myadbqueryresult,1,"testfeature10",1,1,0)) {returnval = -1;};
|
mas01ik@355
|
81
|
mas01ik@355
|
82 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 -e > testoutput
|
mas01ik@355
|
83 //echo testfeature01 0 0 0 > test-expected-output
|
mas01ik@355
|
84 //echo testfeature10 0 1 0 >> test-expected-output
|
mas01ik@355
|
85 //cmp testoutput test-expected-output
|
mas01ik@355
|
86 myadbquery.querytype="sequence";
|
mas01ik@355
|
87 myadbquery.feature="testquery";
|
mas01ik@355
|
88 myadbquery.sequencelength="1";
|
mas01ik@355
|
89 myadbquery.exhaustive=1;
|
mas01ik@355
|
90 myadbquery.numpoints="1";
|
mas01ik@355
|
91 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
92 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
93
|
mas01ik@355
|
94 //printf("size:%d\n",size);
|
mas01ik@355
|
95 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
96 ///* check the test values */
|
mas01ik@355
|
97 if (size != 2) {returnval = -1;};
|
mas01ik@355
|
98 if (testoneresult(&myadbqueryresult,0,"testfeature01",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
99 if (testoneresult(&myadbqueryresult,1,"testfeature10",0,1,0)) {returnval = -1;};
|
mas01ik@355
|
100
|
mas01ik@355
|
101
|
mas01ik@355
|
102 printf("returnval:%d\n",returnval);
|
mas01ik@355
|
103 return(returnval);
|
mas01ik@355
|
104 }
|
mas01ik@355
|
105
|