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 char * databasename="testdb";
|
mas01ik@355
|
12 adb_query_t myadbquery={0};
|
mas01ik@355
|
13 adb_queryresult_t myadbqueryresult={0};
|
mas01ik@355
|
14 adb_query_t myadbquery2={0};
|
mas01ik@355
|
15 adb_queryresult_t myadbqueryresult2={0};
|
mas01ik@355
|
16 adb_insert_t ins1[2]={{0},{0}};
|
mas01ik@355
|
17 int size=0;
|
mas01ik@355
|
18
|
mas01ik@355
|
19 /* remove old directory */
|
mas01ik@355
|
20 //if [ -f testdb ]; then rm -f testdb; fi
|
mas01ik@355
|
21 clean_remove_db(databasename);
|
mas01ik@355
|
22
|
mas01ik@355
|
23 /* create new db */
|
mas01ik@355
|
24 //${AUDIODB} -d testdb -N
|
mas01ik@355
|
25 mydbp=audiodb_create(databasename,0,0,0);
|
mas01ik@355
|
26
|
mas01ik@355
|
27 if (!mydbp){ returnval=-1;};
|
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
|
mas01ik@355
|
41 //cat > testfeaturefiles <<EOF
|
mas01ik@355
|
42 //testfeature01
|
mas01ik@355
|
43 //testfeature10
|
mas01ik@355
|
44 //EOF
|
mas01ik@355
|
45
|
mas01ik@355
|
46 ins1[0].features="testfeature01";
|
mas01ik@355
|
47 ins1[1].features="testfeature10";
|
mas01ik@355
|
48
|
mas01ik@355
|
49 //audioDB --BATCHINSERT -d testdb --featureList tempfeatures
|
mas01ik@355
|
50 //${AUDIODB} -d testdb -B -F testfeaturefiles
|
mas01ik@355
|
51
|
mas01ik@355
|
52 if(audiodb_batchinsert(mydbp,ins1,2)){
|
mas01ik@355
|
53 returnval=-1;
|
mas01ik@355
|
54 };
|
mas01ik@355
|
55
|
mas01ik@355
|
56
|
mas01ik@355
|
57 //# sequence queries require L2NORM
|
mas01ik@355
|
58 //${AUDIODB} -d testdb -L
|
mas01ik@355
|
59 if(audiodb_l2norm(mydbp)){
|
mas01ik@355
|
60 returnval=-1;
|
mas01ik@355
|
61 };
|
mas01ik@355
|
62
|
mas01ik@355
|
63 //echo "query point (0.0,0.5)"
|
mas01ik@355
|
64 //intstring 2 > testquery
|
mas01ik@355
|
65 //floatstring 0 0.5 >> testquery
|
mas01ik@355
|
66 ivals[0]=2;
|
mas01ik@355
|
67 dvals[0]=0; dvals[1]=0.5;
|
mas01ik@355
|
68 maketestfile("testquery",ivals,dvals,2);
|
mas01ik@355
|
69
|
mas01ik@355
|
70 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
|
mas01ik@355
|
71 //echo testfeature01 0 0 0 > test-expected-output
|
mas01ik@355
|
72 //echo testfeature10 2 0 0 >> test-expected-output
|
mas01ik@355
|
73 //cmp testoutput test-expected-output
|
mas01ik@355
|
74 myadbquery.querytype="sequence";
|
mas01ik@355
|
75 myadbquery.feature="testquery";
|
mas01ik@355
|
76 myadbquery.sequencelength="1";
|
mas01ik@355
|
77 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
78 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
79
|
mas01ik@355
|
80 //dump_query(&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
81 ///* check the test values */
|
mas01ik@355
|
82 if (size != 2) {returnval = -1;};
|
mas01ik@355
|
83 if (testoneresult(&myadbqueryresult,0,"testfeature01",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
84 if (testoneresult(&myadbqueryresult,1,"testfeature10",2,0,0)) {returnval = -1;};
|
mas01ik@355
|
85
|
mas01ik@355
|
86
|
mas01ik@355
|
87 //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -r 1 > testoutput
|
mas01ik@355
|
88 //echo testfeature01 0 0 0 > test-expected-output
|
mas01ik@355
|
89 //cmp testoutput test-expected-output
|
mas01ik@355
|
90 myadbquery.querytype="sequence";
|
mas01ik@355
|
91 myadbquery.feature="testquery";
|
mas01ik@355
|
92 myadbquery.sequencelength="1";
|
mas01ik@355
|
93 myadbquery.resultlength="1";
|
mas01ik@355
|
94 audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
|
mas01ik@355
|
95 size=myadbqueryresult.sizeRlist;
|
mas01ik@355
|
96
|
mas01ik@355
|
97 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
98 if (testoneresult(&myadbqueryresult,0,"testfeature01",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
99 //echo "query point (0.5,0.0)"
|
mas01ik@355
|
100 //intstring 2 > testquery
|
mas01ik@355
|
101 //floatstring 0.5 0 >> testquery
|
mas01ik@355
|
102 ivals[0]=2;
|
mas01ik@355
|
103 dvals[0]=0.5; dvals[1]=0;
|
mas01ik@355
|
104 maketestfile("testquery",ivals,dvals,2);
|
mas01ik@355
|
105
|
mas01ik@355
|
106 ////${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
|
mas01ik@355
|
107 ////echo testfeature10 0 0 0 > test-expected-output
|
mas01ik@355
|
108 ////echo testfeature01 2 0 0 >> test-expected-output
|
mas01ik@355
|
109 ////cmp testoutput test-expected-output
|
mas01ik@355
|
110 myadbquery2.querytype="sequence";
|
mas01ik@355
|
111 myadbquery2.feature="testquery";
|
mas01ik@355
|
112 myadbquery2.sequencelength="1";
|
mas01ik@355
|
113 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
|
mas01ik@355
|
114 size=myadbqueryresult2.sizeRlist;
|
mas01ik@355
|
115
|
mas01ik@355
|
116 if (size != 2) {returnval = -1;};
|
mas01ik@355
|
117 if (testoneresult(&myadbqueryresult2,0,"testfeature10",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
118 if (testoneresult(&myadbqueryresult2,1,"testfeature01",2,0,0)) {returnval = -1;};
|
mas01ik@355
|
119
|
mas01ik@355
|
120
|
mas01ik@355
|
121 ////${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -r 1 > testoutput
|
mas01ik@355
|
122 ////echo testfeature10 0 0 0 > test-expected-output
|
mas01ik@355
|
123 ////cmp testoutput test-expected-output
|
mas01ik@355
|
124 myadbquery2.querytype="sequence";
|
mas01ik@355
|
125 myadbquery2.feature="testquery";
|
mas01ik@355
|
126 myadbquery2.sequencelength="1";
|
mas01ik@355
|
127 myadbquery2.resultlength="1";
|
mas01ik@355
|
128 audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
|
mas01ik@355
|
129 size=myadbqueryresult2.sizeRlist;
|
mas01ik@355
|
130
|
mas01ik@355
|
131 if (size != 1) {returnval = -1;};
|
mas01ik@355
|
132 if (testoneresult(&myadbqueryresult2,0,"testfeature10",0,0,0)) {returnval = -1;};
|
mas01ik@355
|
133
|
mas01ik@355
|
134 audiodb_close(mydbp);
|
mas01ik@355
|
135 // fprintf(stderr,"returnval:%d\n",returnval);
|
mas01ik@355
|
136
|
mas01ik@355
|
137 return(returnval);
|
mas01ik@355
|
138 }
|
mas01ik@355
|
139
|