mas01ik@355: #include <stdio.h>
mas01ik@355: #include <stdlib.h>
mas01ik@355: #include <string.h>
mas01ik@355: #include <sysexits.h>
mas01ik@355: #include <fcntl.h>
mas01ik@355: #include <dirent.h>
mas01ik@355: #include <unistd.h>
mas01ik@355: #include <sys/stat.h>
mas01ik@355: /*
mas01ik@355:  *  * #define NDEBUG
mas01ik@355:  *   * */
mas01ik@355: #include <assert.h>
mas01ik@355: 
mas01ik@355: #include "../../audioDB_API.h"
mas01ik@355: #include "../test_utils_lib.h"
mas01ik@355: 
mas01ik@355: 
mas01ik@355: int main(int argc, char **argv){
mas01ik@355: 
mas01ik@355:     int returnval=0;
mas01ik@355:     adb_ptr mydbp={0};
mas01ik@355:     int ivals[10];
mas01ik@355:     double dvals[10];
mas01ik@355:     char * databasename="testdb";
mas01ik@355:     adb_query_t myadbquery={0};
mas01ik@355:     adb_queryresult_t myadbqueryresult={0};
mas01ik@355:     int size=0;
mas01ik@355:     adb_insert_t ins1[2]={{0},{0}};
mas01ik@355: 
mas01ik@355: 
mas01ik@355:     /* remove old directory */
mas01ik@355:     //if [ -f testdb ]; then rm -f testdb; fi
mas01ik@355:     clean_remove_db(databasename);
mas01ik@355: 
mas01ik@355:     /* create new db */
mas01ik@355:     //${AUDIODB} -d testdb -N
mas01ik@355:     mydbp=audiodb_create(databasename,0,0,0);
mas01ik@355: 
mas01ik@355: //intstring 2 > testfeature
mas01ik@355: //floatstring 0 1 >> testfeature
mas01ik@355: //floatstring 1 0 >> testfeature
mas01ik@355:     ivals[0]=2;
mas01ik@355:     dvals[0]=0; dvals[1]=1; dvals[2]=1; dvals[3]=0;
mas01ik@355:     maketestfile("testfeature",ivals,dvals,4);
mas01ik@355: 
mas01ik@355: //intstring 1 > testpower
mas01ik@355: //floatstring -0.5 >> testpower
mas01ik@355: //floatstring -1 >> testpower
mas01ik@355:     ivals[0]=1;
mas01ik@355:     dvals[0]=-0.5; dvals[1]=-1;
mas01ik@355:     maketestfile("testpower",ivals,dvals,2);
mas01ik@355: 
mas01ik@355: //echo testfeature > testFeatureList.txt
mas01ik@355: //echo testpower > testPowerList.txt
mas01ik@355:     ins1[0].features="testfeature";
mas01ik@355:     ins1[0].power="testpower";
mas01ik@355: 
mas01ik@355: //expect_clean_error_exit ${AUDIODB} -d testdb -B -F testFeatureList.txt -W testPowerList.txt
mas01ik@355:     if(!audiodb_batchinsert(mydbp,ins1,1)){
mas01ik@355:         returnval=-1;
mas01ik@355:     };
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -P
mas01ik@355:     if(audiodb_power(mydbp)){
mas01ik@355:         returnval=-1;
mas01ik@355:     };
mas01ik@355: 
mas01ik@355: //expect_clean_error_exit ${AUDIODB} -d testdb -B -F testFeatureList.txt
mas01ik@355:     ins1[0].features="testfeature";
mas01ik@355:     ins1[0].power=NULL;
mas01ik@355:     if(!audiodb_batchinsert(mydbp,ins1,1)){
mas01ik@355:         returnval=-1;
mas01ik@355:     };
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -B -F testFeatureList.txt -W testPowerList.txt
mas01ik@355:     ins1[0].features="testfeature";
mas01ik@355:     ins1[0].power="testpower";
mas01ik@355:     if(audiodb_batchinsert(mydbp,ins1,1)){
mas01ik@355:         returnval=-1;
mas01ik@355:     };
mas01ik@355: 
mas01ik@355: //# sequence queries require L2NORM
mas01ik@355: //${AUDIODB} -d testdb -L
mas01ik@355:     if(audiodb_l2norm(mydbp)){
mas01ik@355:         returnval=-1;
mas01ik@355:     };
mas01ik@355: 
mas01ik@355: //# queries without power files should run as before
mas01ik@355: //echo "query point (0.0,0.5)"
mas01ik@355: //intstring 2 > testquery
mas01ik@355: //floatstring 0 0.5 >> testquery
mas01ik@355:     ivals[0]=2;
mas01ik@355:     dvals[0]=-0.0; dvals[1]=0.5;
mas01ik@355:     maketestfile("testquery",ivals,dvals,2);
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
mas01ik@355: //echo testfeature 1 0 0 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
mas01ik@355: //echo testfeature 0 0 0 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.numpoints="1";
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //echo "query point (0.5,0.0)"
mas01ik@355: //intstring 2 > testquery
mas01ik@355: //floatstring 0.5 0 >> testquery
mas01ik@355:     ivals[0]=2;
mas01ik@355:     dvals[0]=0.5; dvals[1]=0.0;
mas01ik@355:     maketestfile("testquery",ivals,dvals,2);
mas01ik@355: 
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
mas01ik@355: //echo testfeature 1 0 1 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,1)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
mas01ik@355: //echo testfeature 0 0 1 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.numpoints="1";
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,1)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //# queries with power files might do something different
mas01ik@355: //echo "query point (0.0,0.5), p=-0.5"
mas01ik@355: //intstring 2 > testquery
mas01ik@355: //floatstring 0 0.5 >> testquery
mas01ik@355:     ivals[0]=2;
mas01ik@355:     dvals[0]=0.0; dvals[1]=0.5;
mas01ik@355:     maketestfile("testquery",ivals,dvals,2);
mas01ik@355: 
mas01ik@355: //intstring 1 > testquerypower
mas01ik@355: //floatstring -0.5 >> testquerypower
mas01ik@355:     ivals[0]=1;
mas01ik@355:     dvals[0]=-0.5;
mas01ik@355:     maketestfile("testquerypower",ivals,dvals,1);
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-1.4 > testoutput
mas01ik@355: //echo testfeature 1 0 0 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.absolute_threshold=-1.4;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.6 > testoutput
mas01ik@355: //echo testfeature 0 0 0 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.absolute_threshold=-0.6;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.2 > testoutput
mas01ik@355: //cat /dev/null > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.absolute_threshold=-0.2;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 0) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=1 > testoutput
mas01ik@355: //audioDB -Q sequence -d testdb -f testquery -w testquerypower -l 1 --relative-threshold 1.000000
mas01ik@355: //echo testfeature 1 0 0 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.absolute_threshold=0.0;
mas01ik@355:     myadbquery.relative_threshold=1.0;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=0.2 > testoutput
mas01ik@355: //echo testfeature 0 0 0 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.absolute_threshold=0.0;
mas01ik@355:     myadbquery.relative_threshold=0.2;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: ////echo "query point (0.5,0.0), p=-0.5"
mas01ik@355: ////intstring 2 > testquery
mas01ik@355: ////floatstring 0.5 0 >> testquery
mas01ik@355:     ivals[0]=2;
mas01ik@355:     dvals[0]=0.5; dvals[1]=0.0;
mas01ik@355:     maketestfile("testquery",ivals,dvals,2);
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-1.4 > testoutput
mas01ik@355: //echo testfeature 1 0 1 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.absolute_threshold=-1.4;
mas01ik@355:     myadbquery.relative_threshold=0.0;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355: //    dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,1)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.6 > testoutput
mas01ik@355: //echo testfeature 2 0 0 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.absolute_threshold=-0.6;
mas01ik@355:     myadbquery.relative_threshold=0.0;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",2,0,0)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.2 > testoutput
mas01ik@355: //cat /dev/null > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.absolute_threshold=-0.2;
mas01ik@355:     myadbquery.relative_threshold=0.0;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 0) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=1 > testoutput
mas01ik@355: //echo testfeature 1 0 1 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.relative_threshold=1.0;
mas01ik@355:     myadbquery.absolute_threshold=0.0;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     //dump_query(&myadbquery,&myadbqueryresult);
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,1)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=0.2 > testoutput
mas01ik@355: //echo testfeature 2 0 0 > test-expected-output
mas01ik@355: //cmp testoutput test-expected-output
mas01ik@355:     myadbquery.querytype="sequence";
mas01ik@355:     myadbquery.feature="testquery";
mas01ik@355:     myadbquery.power="testquerypower";
mas01ik@355:     myadbquery.sequencelength="1";
mas01ik@355:     myadbquery.relative_threshold=0.2;
mas01ik@355:     myadbquery.absolute_threshold=0.0;
mas01ik@355:     myadbquery.numpoints=NULL;
mas01ik@355:     audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
mas01ik@355:     size=myadbqueryresult.sizeRlist;
mas01ik@355: 
mas01ik@355:     ///* check the test values */
mas01ik@355:     if (size != 1) {returnval = -1;};
mas01ik@355:     if (testoneresult(&myadbqueryresult,0,"testfeature",2,0,0)) {returnval = -1;};
mas01ik@355: 
mas01ik@355: 
mas01ik@355:     audiodb_close(mydbp);
mas01ik@355:     //fprintf(stderr,"returnval:%d\n",returnval);
mas01ik@355:       
mas01ik@355:     return(returnval);
mas01ik@355: }
mas01ik@355: