view libtests/0004/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};
    adb_status_t mystatus={0};
    int ivals[10];
    double dvals[10];
    FILE * myfile;
    int ret=0;
    adb_insert_t myinsert={0};
    unsigned int myerr=0;
    adb_query_t myadbquery={0};
    adb_queryresult_t myadbqueryresult={0};
    adb_query_t myadbquery2={0};
    adb_queryresult_t myadbqueryresult2={0};
    char * databasename="testdb";
    int i=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);

    /* turn on l2norm */
    //${AUDIODB} -d testdb -L
    audiodb_l2norm(mydbp);

    /* make a test file */
    //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);


    /* insert */ 
    //${AUDIODB} -d testdb -I -f testfeature
    myinsert.features="testfeature";
    myerr=audiodb_insert(mydbp,&myinsert);   

    /* testquery */ 
    //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; dvals[2]=0; dvals[3]=0;
    maketestfile("testquery", ivals,dvals,4);

    /* query 1 */
    //${AUDIODB} -d testdb -Q point -f testquery > testoutput
    //echo testfeature 0.5 0 0 > test-expected-output
    //echo testfeature 0 0 1 >> test-expected-output
    //cmp testoutput test-expected-output
    myadbquery.querytype="point"; 
    myadbquery.feature="testquery"; 
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;
    
    /* check the test values */
    if (size != 2) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",.5,0,0)) {returnval = -1;};   
    if (testoneresult(&myadbqueryresult,1,"testfeature",0,0,1)) {returnval = -1;};   
    
    /* query 2 - same but only first result */
//${AUDIODB} -d testdb -Q point -f testquery -n 1 > testoutput
//echo testfeature 0.5 0 0 > test-expected-output
//cmp testoutput test-expected-output
    myadbquery.numpoints="1"; 
    audiodb_query(mydbp,&myadbquery,&myadbqueryresult);
    size=myadbqueryresult.sizeRlist;

    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult,0,"testfeature",.5,0,0)) {returnval = -1;};   


    /* testquery2 */ 
    //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; dvals[2]=0; dvals[3]=0;
    maketestfile("testquery", ivals,dvals,4);

    /* query 3 */ 
    //${AUDIODB} -d testdb -Q point -f testquery > testoutput
    //echo testfeature 0.5 0 1 > test-expected-output
    //echo testfeature 0 0 0 >> test-expected-output
    //cmp testoutput test-expected-output
    myadbquery2.querytype="point"; 
    myadbquery2.feature="testquery"; 
    myadbquery2.numpoints=NULL; 
    audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
    size=myadbqueryresult2.sizeRlist;

    /* check the test values */
    if (size != 2) {returnval = -1;};
    if (testoneresult(&myadbqueryresult2,0,"testfeature",.5,0,1)) {returnval = -1;};   
    if (testoneresult(&myadbqueryresult2,1,"testfeature",0,0,0)) {returnval = -1;};   
     
    /* query 4 - same as 3 but only first result */
    //${AUDIODB} -d testdb -Q point -f testquery -n 1 > testoutput
    //echo testfeature 0.5 0 1 > test-expected-output
    //cmp testoutput test-expected-output
    myadbquery2.numpoints="1"; 
    audiodb_query(mydbp,&myadbquery2,&myadbqueryresult2);
    size=myadbqueryresult2.sizeRlist;


    if (size != 1) {returnval = -1;};
    if (testoneresult(&myadbqueryresult2,0,"testfeature",.5,0,1)) {returnval = -1;};   

    audiodb_close(mydbp);


    return(returnval);
}