dataPipeline with metadata options test

Test Objectives

• To test the metadata options in the dataPipeline command
  • -dbquery option
  • -dbntuple option
  • -dbspectrum option
  • -dbqualitychannel option

  Various combination of values for the options are tested: e.g.

  valid SQL vs SQL with no rows, push vs pass option, ligolw or wrapper for -datacondtarget

  APIs affected by this test

  • All APIs are exercised via dataPipeline commands.

  Setup

  • ligotools package is required for running this test. Check that it is mounted
  • Install the following tests script in a directory on your local machine or the ldas system

    • dbquery.tcl
    • dbtuple.tcl
    • dbspectrum.tcl
    • dbqchannel.tcl
  • S2 frame files must be mounted on ldas system and known to diskcacheAPI:

  Test Execution

  1. Login to site gateway box e.g. dev, as user ldas
  2. cd <your workdir directory>
  Usage: /ldas/testbin/dbquery.tcl >& dbquery.log &

  Usage: dbntuple.tcl [options] >& dbntuple.log &

  Usage: dbspectrum.tcl [options] >& dbspectrum.log &

  Usage: dbqualitychannel.tcl [options] >& dbqualitychannel.log &

  e.g. with globus sockets and using dbntuple as example:

          
     	dbntuple.tcl --site dev -debug 0 -verbose lpse --enable-globus 1 --enable-gsi 1 
      	--database dev_1 </dev/null >& descMetaData.log &

  and with tcl sockets:

  
     	dbntuple.tcl --site dev -debug 0 -verbose lpse --enable-globus 0 --enable-gsi 0 
          --database dev_1 </dev/null >& descMetaData.log &

  To enable debugging, set debug level to 1 or greater:

          
     	dbntuple.tcl --site dev -debug 1 -verbose lpse --enable-globus 1 --enable-gsi 1 
      	--database dev_1 --qa-debug-level 1 </dev/null >& descMetaData.log &

  No --database option is used as the tests automatically use ldas_tst database since non-standard DSO libldastrivial.so used in the tests can only insert into the test database.

  Test Validation:

  Expect all dataPipelines responses to match expectations and pass all the tests:

  	    dbntuple.tcl:   Total   15      Passed  15      Skipped 0       Failed  0
              dbqchannel.tcl: Total   28      Passed  28      Skipped 0       Failed  0
              dbquery.tcl:    Total   12      Passed  12      Skipped 0       Failed  0
              dbspectrum.tcl: Total   8       Passed  8       Skipped 0       Failed  0