harpoGetRunList.cxx

Go to the documentation of this file.

//
// Demo code for harpo database manipulation
//

#include "HarpoDB.h"
#include "TSQLServer.h"
#include "TSQLResult.h"
#include "TSQLRow.h"
#include "TString.h"
#include <iostream>
#include <stdlib.h>
#include <unistd.h>


int main(int argc, char **argv)
{
  //  std::cout << "Connecting to server" << std::endl; 
  TString dbUrl = TString("mysql://llrharpo.in2p3.fr/harpo");
  TString dbuser = TString("reader");
  TString dbpw  = TString("ro");
  TSQLServer *db = TSQLServer::Connect(dbUrl.Data(),dbuser.Data(), dbpw.Data());
  if ( db == NULL )
    return false; // server not opened
  
  TSQLRow *mrow;
  TSQLResult *res;
  
  TString sql;
  TString cut;// = TString("Beam LIKE 'NSBeam'");
  
  if(argc>1) cut = TString(argv[1]);
  else cut = TString("1");

  sql += "SELECT t0.run FROM `runconfig` t0 left join `NSBeam` t1 on t0.run = t1.run WHERE ";
  sql += cut;
  sql +=";";
  //  std::cout << "SQL : " << sql << std::endl;
  
  // // query database and print results
  // //if ( db->SelectDataBase("harpo") != 0 ) return rec_found;
  res = db->Query(sql.Data());
  
  int nfields = res->GetFieldCount();
  if(nfields != 1) return 0;
  int nrows = res->GetRowCount();
    

  for(Int_t row = 0; row<nrows; row++){
    mrow = res->Next();
    std::cout << mrow->GetField(0) << "  ";
  }
  std::cout << std::endl;
  
  //  std::cout << "NROWS : " << nrows << std::endl;
  return 0;

}