#ifndef __CINT__
#include <TSQLServer.h>
#include <TSQLResult.h>
#include <TSQLRow.h>
#endif

void allrunlist() {

  const char* dbname = "mysql://jmysql/hapvdis";
  const char* username = "hapvdis";
  const char* userpass = "to<9uLkp";

  TSQLServer *db = TSQLServer::Connect(dbname, username, userpass);

  printf("Server info: %s\n", db->ServerInfo());

  cout<<"Database is: "<<db->GetDB()<<endl;

  TSQLRow *row;
  TSQLResult *res;

  TString outfilename = "runlist_all.txt";

  TString outonlyname = "runlist_runnumonly_all.txt";

  ofstream out(outfilename, ios::out);
  ofstream outonly(outonlyname, ios::out);



//   // list databases on server
//   cout<<endl<<"Listing all databases on server: "<<db->GetHost()<<endl;
//   res = db->GetDataBases();
//   while ((row = res->Next())) {
//     cout<<row->GetField(0)<<endl;
//     delete row;
//   }
//   delete res;

//   // list tables in database "hapvdis" 
//   cout<<endl<<"Listing all tables in database \"hapvdis\" "<<endl; 
//   res = db->GetTables("hapvdis");
//   while ((row = res->Next())) {
//     cout<<row->GetField(0)<<endl;
//     delete row;
//   }
//   delete res;

//   // list columns in table "runlist" in database "hapvdis"
//   cout<<endl<<"Listing all columns in table \"runlist\" in database \"hapvdis\""<<endl;
//   res = db->GetColumns("hapvdis", "runlist");
//   while ((row = res->Next())){
//     cout<<row->GetField(0)<<endl;
//     delete row;
//   }
//   delete res;

  for (slug = 1; slug <25; slug++) {

  TString sql = "select run_num, slug, production, HWP from runlist where slug = ";
  sql += slug;

  res = db->Query(sql);

  const Int_t nrows = res->GetRowCount();
  cout<<"total rows: "<<nrows<<endl;

  Int_t *runnum = new Int_t [nrows];
  Int_t *slugnum = new Int_t [nrows];
  Int_t *prod = new Int_t [nrows];
  Int_t *HWP = new Int_t [nrows];
  Int_t *leftlow = new Int_t [nrows];
  Int_t *lefthigh = new Int_t [nrows];
  Int_t *rightlow = new Int_t [nrows];
  Int_t *righthigh =new Int_t [nrows];

  //  Int_t nfields = res->GetFieldCount();
//   for (Int_t i = 0; i < nfields; i++)
//     cout<<res->GetFieldName(i)<<"\t";
//   cout<<endl;

  for (Int_t i = 0; i < nrows; i++) {
    row = res->Next();
    runnum[i] = atoi(row->GetField(0));
    slugnum[i] = atoi(row->GetField(1));
    prod[i] = atoi(row->GetField(2));
    HWP[i] = atoi(row->GetField(3));
    //    cout<<runnum[i]<<"\t"<<slugnum[i]<<"\t"<<prod[i]<<"\t"<<HWP[i]<<endl;
//     for (Int_t j = 0; j < nfields; j++) {
//       cout<<row->GetField(j)<<"\t";
//     }

    delete row;
  }
  delete res;

  for (Int_t i = 0; i < nrows; i++) {

    TString sqltmp = "select leftlow, lefthigh, rightlow, righthigh from cutlist where run_num = ";
    sqltmp += runnum[i];

    res = db->Query(sqltmp);
    if (res->GetRowCount() != 1)
      cout<<"Warning::query from cutlist returns not a single entry: runnum: "<<runnum[i]<<"  entries:"<<res->GetRowCount()<<endl;
    row = res->Next();
    leftlow[i] = atoi(row->GetField(0));
    lefthigh[i] = atoi(row->GetField(1));
    rightlow[i] = atoi(row->GetField(2));
    righthigh[i] = atoi(row->GetField(3));

    delete row;
    delete res;
  }

  for (Int_t i = 0; i < nrows; i++) {

    if (prod[i]) {
     
      out<<runnum[i]<<"\t"<<slugnum[i]<<"\t"<<HWP[i]<<"\t"<<leftlow[i]<<"\t"<<lefthigh[i]<<"\t"<<rightlow[i]<<"\t"<<righthigh[i]<<endl;
      
      outonly<<runnum[i]<<endl;
      
    }
  }

  delete [] runnum;
  delete [] slugnum;
  delete [] prod;
  delete [] HWP;
  delete [] leftlow;
  delete [] lefthigh;
  delete [] rightlow;
  delete [] righthigh;
  
  }
    delete db;
}