view libtests/0027/prog1.c @ 469:d3afc91d205d api-inversion

Move audioDB::query over to audioDB.cpp

At the same time, remove all the abstraction violations in
audioDB::query, which came in two flavours: use of dbH->numFiles, which
is dealt with by getting the database status instead (and is eventually
unnecessary, being only needed now because reporters are implemented in
terms of vectors indexed by ID), and use of fileTable in reporter's
report functions (dealt with by passing in the adb instead).

To actually implement reporting as of now, we continue to use stuff from
audioDB-internals.h; maybe someday we will be clean and shiny.

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sysexits.h>
#include <fcntl.h>
#include <dirent.h>
#include <unistd.h>
#include <sys/stat.h>
/*
 *  * #define NDEBUG
 *   * */
#include <assert.h>

#include "../../audioDB_API.h"
#include "../test_utils_lib.h"


int main(int argc, char **argv){

    int returnval=0;
    adb_ptr mydbp={0};
    int ivals[10];
    double dvals[10];
    adb_insert_t myinsert={0};
    unsigned int myerr=0;
    char * databasename="testdb";
    adb_query_t myadbquery={0};
    adb_queryresult_t myadbqueryresult={0};
    adb_query_t myadbquery2={0};
    adb_queryresult_t myadbqueryresult2={0};
    int size=0;


    /* remove old directory */
    //if [ -f testdb ]; then rm -f testdb; fi
    clean_remove_db(databasename);

    /* create new db */
    //${AUDIODB} -d testdb -N
    mydbp=audiodb_create(databasename,0,0,0);

    //intstring 2 > testfeature
    //floatstring 0 1 >> testfeature
    //floatstring 1 0 >> testfeature
    ivals[0]=2;
    dvals[0]=0; dvals[1]=1; dvals[2]=1; dvals[3]=0;
    maketestfile("testfeature",ivals,dvals,4);

    //intstring 1 > testpower
    //floatstring -0.5 >> testpower
    //floatstring -1 >> testpower
    ivals[0]=1;
    dvals[0]=-0.5; dvals[1]=-1;
    maketestfile("testpower",ivals,dvals,2);

    /* insert breaks because power flag off and power insert */
    //expect_clean_error_exit ${AUDIODB} -d testdb -I -f testfeature -w testpower
    myinsert.features="testfeature";
    myinsert.power="testpower";
    if (!audiodb_insert(mydbp,&myinsert)){ returnval=-1; } 
  
  
    /* make sure power can be turned on */
//${AUDIODB} -d testdb -P
    if(audiodb_power(mydbp)){ returnval=-1; };


    /* inserts now require power also */
////expect_clean_error_exit ${AUDIODB} -d testdb -I -f testfeature
    myinsert.features="testfeature";
    myinsert.power=NULL;
    //myerr=audiodb_insert(mydbp,&myinsert);   
    if (!audiodb_insert(mydbp,&myinsert)){ returnval=-1; } 

    /* now make a real insert */
//${AUDIODB} -d testdb -I -f testfeature -w testpower
    myinsert.features="testfeature";
    myinsert.power="testpower";
    //myerr=audiodb_insert(mydbp,&myinsert);   
    if (audiodb_insert(mydbp,&myinsert)){ returnval=-1; } 


    //# sequence queries require L2NORM
    //${AUDIODB} -d testdb -L
    if(audiodb_l2norm(mydbp)){ returnval=-1; };


    //# queries without power files should run as before
    //echo "query point (0.0,0.5)"
    //intstring 2 > testquery
    //floatstring 0 0.5 >> testquery
    ivals[0]=2;
    dvals[0]=-0; dvals[1]=0.5;
    maketestfile("testquery",ivals,dvals,2);


    /* query 1 */
    //${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
    //echo testfeature 1 0 0 > test-expected-output
    //cmp testoutput test-expected-output
    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};

//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
//echo testfeature 0 0 0 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    myadbquery.numpoints="1";
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};

//echo "query point (0.5,0.0)"
//intstring 2 > testquery
//floatstring 0.5 0 >> testquery
    ivals[0]=2;
    dvals[0]=0.5; dvals[1]=0.0;
    maketestfile("testquery",ivals,dvals,2);

//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery > testoutput
//echo testfeature 1 0 1 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    myadbquery.numpoints=NULL;
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,1)) {returnval = -1;};

//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -n 1 > testoutput
//echo testfeature 0 0 1 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    myadbquery.numpoints="1";
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,1)) {returnval = -1;};



//# queries with power files might do something different
//echo "query point (0.0,0.5), p=-0.5"
//intstring 2 > testquery
//floatstring 0 0.5 >> testquery
//intstring 1 > testquerypower
//floatstring -0.5 >> testquerypower
    ivals[0]=2;
    dvals[0]=-0; dvals[1]=0.5;
    maketestfile("testquery",ivals,dvals,2);
    ivals[0]=1;
    dvals[0]=-0.5;
    maketestfile("testquerypower",ivals,dvals,1);

//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-1.4 > testoutput
//echo testfeature 1 0 0 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    myadbquery.power="testquerypower";
    myadbquery.numpoints=NULL;
    myadbquery.absolute_threshold=-1.4;
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};

//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.6 > testoutput
//echo testfeature 0 0 0 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    myadbquery.power="testquerypower";
    myadbquery.numpoints=NULL;
    myadbquery.absolute_threshold=-0.6;
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};


//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.2 > testoutput
//cat /dev/null > test-expected-output
//cmp testoutput test-expected-output

    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    myadbquery.power="testquerypower";
    myadbquery.numpoints=NULL;
    myadbquery.absolute_threshold=-0.2;
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;
    //dump_query(&myadbquery,&myadbqueryresult);

    /* check the test values */
    if (size != 0) {returnval = -1;};



//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=1 > testoutput
//echo testfeature 1 0 0 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    myadbquery.power="testquerypower";
    myadbquery.numpoints=NULL;
    myadbquery.absolute_threshold=0;
    myadbquery.relative_threshold=1;
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",1,0,0)) {returnval = -1;};


//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=0.2 > testoutput
//echo testfeature 0 0 0 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery.querytype="sequence";
    myadbquery.feature="testquery";
    myadbquery.sequencelength="1";
    myadbquery.power="testquerypower";
    myadbquery.numpoints=NULL;
    myadbquery.absolute_threshold=0;
    myadbquery.relative_threshold=0.2;
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",0,0,0)) {returnval = -1;};


//echo "query point (0.5,0.0), p=-0.5"
//intstring 2 > testquery
//floatstring 0.5 0 >> testquery
    ivals[0]=2;
    dvals[0]=0.5; dvals[1]=0.0;
    maketestfile("testquery",ivals,dvals,2);


//audioDB -Q sequence -d testdb -f testquery -w testquerypower -l 1 --absolute-threshold -1.400000 
//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-1.4 > testoutput
//echo testfeature 1 0 1 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery2.querytype="sequence";
    myadbquery2.feature="testquery";
    myadbquery2.sequencelength="1";
    myadbquery2.power="testquerypower";
    myadbquery2.numpoints=NULL;
    myadbquery2.absolute_threshold=-1.4;
    audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
    size=myadbqueryresult2.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult2,0,"testfeature",1,0,1)) {returnval = -1;};


//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.6 > testoutput
//echo testfeature 2 0 0 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery2.querytype="sequence";
    myadbquery2.feature="testquery";
    myadbquery2.sequencelength="1";
    myadbquery2.power="testquerypower";
    myadbquery2.numpoints=NULL;
    myadbquery2.absolute_threshold=-0.6;
    audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
    size=myadbqueryresult2.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult2,0,"testfeature",2,0,0)) {returnval = -1;};


//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --absolute-threshold=-0.2 > testoutput
//cat /dev/null > test-expected-output
//cmp testoutput test-expected-output
    myadbquery2.querytype="sequence";
    myadbquery2.feature="testquery";
    myadbquery2.sequencelength="1";
    myadbquery2.power="testquerypower";
    myadbquery2.numpoints=NULL;
    myadbquery2.absolute_threshold=-0.2;
    myadbquery2.relative_threshold=0.0;
    audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
    size=myadbqueryresult2.sizeRlist;

    /* check the test values */
    if (size != 0) {returnval = -1;};


//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=1 > testoutput
//echo testfeature 1 0 1 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery2.querytype="sequence";
    myadbquery2.feature="testquery";
    myadbquery2.sequencelength="1";
    myadbquery2.power="testquerypower";
    myadbquery2.numpoints=NULL;
    myadbquery2.absolute_threshold=0.0;
    myadbquery2.relative_threshold=1;
    audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
    size=myadbqueryresult2.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult2,0,"testfeature",1,0,1)) {returnval = -1;};



//${AUDIODB} -d testdb -Q sequence -l 1 -f testquery -w testquerypower --relative-threshold=0.2 > testoutput
//echo testfeature 2 0 0 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery2.querytype="sequence";
    myadbquery2.feature="testquery";
    myadbquery2.sequencelength="1";
    myadbquery2.power="testquerypower";
    myadbquery2.numpoints=NULL;
    myadbquery2.absolute_threshold=-0.0;
    myadbquery2.relative_threshold=0.1;
    audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
    size=myadbqueryresult2.sizeRlist;

    /* check the test values */
    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult2,0,"testfeature",2,0,0)) {returnval = -1;};

//    printf("returnval:%d\n",returnval);
    return(returnval);
}