JPrintDB.cc

Go to the documentation of this file.

#include <iostream>
#include <iomanip>
#include <vector>
#include <map>

#include "KM3NeTDBClient.h"
#include "JDB/JDB.hh"
#include "JDB/JSelector.hh"
#include "JDetector/JDetector.hh"

#include "Jeep/JParser.hh"
#include "Jeep/JMessage.hh"


/**
 * \file
 *
 * Example program to print data from data base.
 * \author mdejong
 */
int main(int argc, char **argv)
{
  using namespace std;
  using namespace KM3NETDB;

  string    usr;
  string    pwd;
  string    cookie;
  string    query;
  JSelector selector;
  int       width;
  int       debug;

  try {

    JParser<> zap("Example program to print data from data base.");
    
    zap['u'] = make_field(usr)        = "";
    zap['!'] = make_field(pwd)        = "";
    zap['C'] = make_field(cookie)     = "";
    zap['q'] = make_field(query)      = "";
    zap['@'] = make_field(selector)   = JPARSER::initialised();
    zap['W'] = make_field(width)      = 16;
    zap['d'] = make_field(debug)      = 1;

    zap(argc, argv);
  }
  catch(const exception &error) {
    FATAL(error.what() << endl);
  }

  DEBUG("Selection:" << endl << selector << endl);

  try {

    if      (usr != "" && pwd != "")
      JDB::reset(usr, pwd);
    else if (cookie != "")
      JDB::reset(cookie);
    else
      FATAL("Must provide either username (with passwrod) or cookie." << endl);

    ResultSet& rs  = JDB::get()->StreamDS(query.c_str(), selector);
    
    for (unsigned int i = 0; i != rs.FieldCount(); ++i) {
      cout << ' ' << setw(width) << left << rs.FieldName(i);
    }
    cout << endl;
    
    while (rs.Next()) {
      for (unsigned int i = 0; i != rs.FieldCount(); ++i) {
        cout << ' ' << setw(width) << left << rs.GetString(i);
      }
      cout << endl;
    }
  }
  catch(const exception& error) {
    FATAL(error.what() << endl);
  }
}