view libtests/0029/prog1.c @ 584:e3790284fd4a

Merged through librdf storage hooks and apache2 module.

Squashed commit of the following:

commit a6cfca8f04036e12e7d7fcd55c47224e802582f0
Author: Michael Jewell <mjewell@harrison.(none)>
Date:   Fri Jul 31 15:23:32 2009 +0100

    Removed leftover bits and bobs.

commit f1f0dd074d0767de3e24ba636779fd8701d73d9e
Author: Michael Jewell <mjewell@harrison.(none)>
Date:   Fri Jul 31 15:07:20 2009 +0100

    Simple test of database creation via librdf.

commit 90e6350538e004d8785137e5ff2ac878c22a5d42
Author: Michael Jewell <mjewell@harrison.(none)>
Date:   Fri Jul 31 15:05:10 2009 +0100

    Added the apache2 module which will hook into the librdf storage module

commit c75bf53763b7078c83ae97fcf247da2576baa79a
Author: Michael Jewell <mjewell@harrison.(none)>
Date:   Fri Jul 31 15:04:53 2009 +0100

    Added sparql librdf source - requires the librdf sources to compile.

commit 0646f0190112a73ddb2533537e2cc9832c066b52
Author: Michael Jewell <mjewell@harrison.(none)>
Date:   Mon Jul 27 12:12:26 2009 +0100

    Adding execution to mod_audiodb

commit 8f83f27ba4d917278bca0c7cb665d930e28c86df
Author: Michael Jewell <mjewell@harrison.(none)>
Date:   Wed Jul 22 12:15:57 2009 +0100

    Some initial returns for the sparql handler.

commit dc639aed11943a5b0c379eb47cf293f76908b1b7
Author: Michael Jewell <mjewell@harrison.(none)>
Date:   Wed Jul 22 12:06:20 2009 +0100

    Added a little setup.sh script to do libtoolize/autoconf etc.

commit 3a679da499db647fc82cf2797daeb5cc44ed7655
Author: Michael Jewell <mjewell@harrison.(none)>
Date:   Wed Jul 22 12:03:42 2009 +0100

    Adding initial bits for apache mod

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

int main(int argc, char **argv) {
  adb_t *adb;

  clean_remove_db(TESTDB);
  if(!(adb = audiodb_create(TESTDB, 0, 0, 0)))
    return 1;

  adb_datum_t feature = {4, 2, "testfeature", 
                         (double [8]) {0, 1, 1, 0, 1, 0, 0, 1},
                         (double [4]) {-0.5, -1, -1, -0.5}};
  if(!audiodb_insert_datum(adb, &feature))
    return 1;
  audiodb_power(adb);
  feature.power = NULL;
  if(!audiodb_insert_datum(adb, &feature))
    return 1;
  feature.power = (double [4]) {-0.5, -1, -1, -0.5};
  if(audiodb_insert_datum(adb, &feature))
    return 1;

  if(audiodb_l2norm(adb))
    return 1;

  adb_datum_t query = {3, 2, "testquery", 
                       (double [6]) {0, 0.5, 0, 0.5, 0.5, 0},
                       (double [3]) {-0.5, -1, -1}};
  adb_query_id_t qid = {0};
  qid.datum = &query;
  qid.sequence_length = 1;
  qid.sequence_start = 0;
  adb_query_parameters_t parms =
    {ADB_ACCUMULATION_PER_TRACK, ADB_DISTANCE_EUCLIDEAN_NORMED, 10, 10};
  adb_query_refine_t refine = {0};
  refine.hopsize = 1;

  adb_query_spec_t spec;
  spec.qid = qid;
  spec.params = parms;
  spec.refine = refine;

  adb_query_results_t *results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 4) return 1;
  result_present_or_fail(results, "testfeature", 0, 0, 0);
  result_present_or_fail(results, "testfeature", 2, 0, 1);
  result_present_or_fail(results, "testfeature", 2, 0, 2);
  result_present_or_fail(results, "testfeature", 0, 0, 3);
  audiodb_query_free_results(adb, &spec, results);

  spec.qid.sequence_start = 1;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 4) return 1;
  result_present_or_fail(results, "testfeature", 0, 1, 0);
  result_present_or_fail(results, "testfeature", 2, 1, 1);
  result_present_or_fail(results, "testfeature", 2, 1, 2);
  result_present_or_fail(results, "testfeature", 0, 1, 3);
  audiodb_query_free_results(adb, &spec, results);

  spec.qid.sequence_start = 2;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 4) return 1;
  result_present_or_fail(results, "testfeature", 2, 2, 0);
  result_present_or_fail(results, "testfeature", 0, 2, 1);
  result_present_or_fail(results, "testfeature", 0, 2, 2);
  result_present_or_fail(results, "testfeature", 2, 2, 3);
  audiodb_query_free_results(adb, &spec, results);

  spec.qid.sequence_length = 2;
  spec.qid.sequence_start = 0;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 3) return 1;
  result_present_or_fail(results, "testfeature", 1, 0, 0);
  result_present_or_fail(results, "testfeature", 2, 0, 1);
  result_present_or_fail(results, "testfeature", 1, 0, 2);
  audiodb_query_free_results(adb, &spec, results);

  spec.qid.sequence_start = 1;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 3) return 1;
  result_present_or_fail(results, "testfeature", 0, 1, 0);
  result_present_or_fail(results, "testfeature", 1, 1, 1);
  result_present_or_fail(results, "testfeature", 2, 1, 2);
  audiodb_query_free_results(adb, &spec, results);

  spec.refine.flags = ADB_REFINE_ABSOLUTE_THRESHOLD;
  spec.refine.absolute_threshold = -1.4;

  spec.qid.sequence_length = 2;
  spec.qid.sequence_start = 0;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 3) return 1;
  result_present_or_fail(results, "testfeature", 1, 0, 0);
  result_present_or_fail(results, "testfeature", 2, 0, 1);
  result_present_or_fail(results, "testfeature", 1, 0, 2);
  audiodb_query_free_results(adb, &spec, results);

  spec.qid.sequence_start = 1;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 3) return 1;
  result_present_or_fail(results, "testfeature", 0, 1, 0);
  result_present_or_fail(results, "testfeature", 1, 1, 1);
  result_present_or_fail(results, "testfeature", 2, 1, 2);
  audiodb_query_free_results(adb, &spec, results);

  spec.refine.absolute_threshold = -0.8;
  spec.qid.sequence_start = 0;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 2) return 1;
  result_present_or_fail(results, "testfeature", 1, 0, 0);
  result_present_or_fail(results, "testfeature", 1, 0, 2);
  audiodb_query_free_results(adb, &spec, results);

  spec.qid.sequence_start = 1;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 0) return 1;
  audiodb_query_free_results(adb, &spec, results);

  spec.refine.absolute_threshold = 0;
  spec.refine.flags = ADB_REFINE_RELATIVE_THRESHOLD;
  spec.refine.relative_threshold = 0.1;
  spec.qid.sequence_start = 0;
  results = audiodb_query_spec(adb, &spec);
  if(!results || results->nresults != 2) return 1;
  result_present_or_fail(results, "testfeature", 1, 0, 0);
  result_present_or_fail(results, "testfeature", 1, 0, 2);
  audiodb_query_free_results(adb, &spec, results);

  audiodb_close(adb);

  return 104;
}