harpodbquery.cxx

Go to the documentation of this file.

//
// Demo code for harpo database arbitry query
//

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


int main(int /* argc*/ , char ** /* argv */)
{
  HarpoDB *db;

  db = new HarpoDB;
  db->Open();


  if (db->ExecQuery("SELECT * FROM qq;"))
    std::cout << "Query Ok." << std::endl;
  else
    std::cout << "Bad SELET QUERY"  << std::endl;


  dbResults run_list;

  if (db->ExecQuery("SELECT `run`,`IwLaser` FROM `NSBeam` WHERE `Palarisation` = 100;",&run_list) ) {
    //      std::cout << "Ok, size of rsult " << run_list.size() << std::endl;
  } else
    std::cout << "Bad SELET QUERY"  << std::endl;

  for(dbResults::iterator il=run_list.begin();il !=run_list.end();++il){
    std::cout << " ======================" << std::endl;
    for(dbFields::iterator im=il->begin();im != il->end();++im){
      std::cout << im->first << " = " << im->second << std::endl;
    }
  }
  db->Close();
  delete db;
  return 0;
}