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

#include "TTimeStamp.h"
#include "TRegexp.h"

#include "JDB/JDB.hh"
#include "JDB/JSelector.hh"
#include "JDB/JSelectorSupportkit.hh"
#include "JDB/JRuns.hh"
#include "JDB/JDBToolkit.hh"

#include "JLang/JLangToolkit.hh"
#include "JROOT/JRootPrinter.hh"
#include "JROOT/JRootToolkit.hh"

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


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

  JServer         server;
  string          usr;
  string          pwd;
  string          cookie;
  string          detid;
  TRegexp         regexp(".");
  vector<string>  format;
  JSelector       selection;
  string          option;
  int             debug;

  try {

    JParser<> zap("Example program to print run related data from data base.");
    
    zap['s'] = make_field(server)     = getServernames();
    zap['u'] = make_field(usr)        = "";
    zap['!'] = make_field(pwd)        = "";
    zap['C'] = make_field(cookie)     = "";
    zap['D'] = make_field(detid);
    zap['r'] = make_field(regexp,     "TRegexp for selection of run setup names.")         = JPARSER::initialised();
    zap['F'] = make_field(format,     "column names: " << JEEPZ() << getColumns<JRuns>())  = JPARSER::initialised();
    zap['@'] = make_field(selection)  = JPARSER::initialised();
    zap['O'] = make_field(option,     "print UNIX time as TTimeStamp::AsString(<option>)") = "";
    zap['d'] = make_field(debug)      = 2;

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


  if (format.empty()) {
    format = getColumns<JRuns>();
  }

  try {

    JDB::reset(usr, pwd, cookie);

    const int id = getDetector<int>(detid);

    selection += getSelector<JRuns>(id);

    ResultSet& rs = getResultSet(getTable<JRuns>(), selection);

    for (JRuns parameters; rs >> parameters && selection >> parameters; ) {

      if (TString(parameters.RUNSETUPNAME.c_str()).Contains(regexp)) {

	for (vector<string>::const_iterator i = format.begin(); i != format.end(); ++i) {

	  if      (option != "" && *i == "UNIXJOBSTART")
	    cout << ' ' << TTimeStamp((time_t) (parameters.UNIXJOBSTART /1000)).AsString(option.c_str());
	  else if (option != "" && *i == "UNIXJOBEND")
	    cout << ' ' << TTimeStamp((time_t) (parameters.UNIXJOBEND   /1000)).AsString(option.c_str());
	  else
	    JRootPrinter::print(cout, parameters, *i);
	}

	cout << endl;
      }
    }
  }
  catch(const exception& error) {
    FATAL(error.what() << endl);
  }
}