#include <iostream>
#include <fstream>
#include <string>
#include <iomanip>
#include <math.h>
#include <time.h>
#include <stdio.h>
#include <stdlib.h>

#include <TH1F.h>
#include <TH2F.h>
#include <TH3F.h>
#include <TFile.h>
#include <TTree.h>
#include <TNtuple.h>
#include <TView.h>
#include <TCanvas.h>
#include <TGraph.h>
#include <TAxis.h>
#include <TF1.h>
#include <TRandom.h>
#include <TObject.h>
#include <TNamed.h>
#include <TStyle.h>
#include <TROOT.h>

#include "SqlRoot.h"

using namespace std;

void testfitroot(int w, int h, int XMIN, int XMAX, int YMIN, int YMAX, int emin, int emax ){

  int tmp_x,tmp_y;
  int entries;

  SqlRoot * sql = new SqlRoot("mysql://eagle.phys.klte.hu:3306/astro","muser","muser12");

  TH1F * temph = new TH1F("temph","temph",emax-emin, emin, emax);

  cout << "Starting big loop" << endl;
  
  cout << "XMIN: " << XMIN << " , XMAX: " << XMAX << endl;
  cout << "YMIN: " << YMIN << " , YMAX: " << YMAX << endl;
  for(int i = 0; (tmp_x+w) <= XMAX; i++){     
    tmp_x = i * w + XMIN;
    tmp_y = 0;
    for(int j = 0; (tmp_y+h) <= YMAX; j++){
      //   temph->Reset();
      
      delete temph;
      temph = new TH1F("temph","temph",emax-emin, emin, emax);

      cout << "Empty temph? Entries: " << temph->GetEntries() << endl;
      tmp_y = j * h + YMIN;
      
      cout << "-------------------------------------------" << endl;
      cout << "-------------------------------------------" << endl;
      cout << "tmp_x: " << tmp_x << " , tmp_y: " << tmp_y << endl;
      
       //       cout << "tmp_x: " << tmp_xc << " , tmp_y: " << tmp_yc << endl;

       temph->Add(sql->Getdxdy_subhisto(tmp_x,tmp_x + w,tmp_y,tmp_y + h, emin, emax),1);
 
       entries = (int)temph->GetEntries();
       cout << "Entries: " << entries << endl;
    }
  }
}