#include "TH1.h"
#include "TCanvas.h"
#include "TPad.h"
#include "TArrow.h"

#include "TROOT.h"
#include "TMath.h"
#include "TRandom.h"
#include "TRandom3.h"
#include "TSystem.h"
#include "TDirectory.h"
#include "TString.h"
#include "TMatrixD.h"

#include <iostream>
#include <fstream>
#include <iomanip>
#include <string>
#include <vector>
#include <map>
#include <cstdlib>

#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h> 

TH1F* hTNA = 0;


static int callback(void *data, int argc, char **argv, char **azColName){
  int i;
  fprintf(stderr, "%s: ", (const char*)data);
   
  for(i = 0; i<argc; i++){
    printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
  }
  printf("\n");
  
  hTNA->Fill(atof(argv[8]));    
  
  return 0;
}

void Test_sqlite3()
{

  hTNA = new TH1F("hTN1A", "Tricks for pair NS for any plays", 20, 0., 20.);



  sqlite3 *db;
  char *zErrMsg = 0;
  int rc;
  char *sql;
  const char* data = "Callback function called";

  /* Open database */
  rc = sqlite3_open("bridge.db", &db);

  if( rc ) {
    fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
    exit (EXIT_FAILURE);;
  } else {
    fprintf(stderr, "Opened database successfully\n");
  }

  /* Create SQL statement */
  sql = "select * from  PARTIE where ID <= 10" ; 

   /* Execute SQL statement */
   rc = sqlite3_exec(db, sql, callback, (void*)data, &zErrMsg);
   
   if( rc != SQLITE_OK ) {
     fprintf(stderr, "SQL error: %s\n", zErrMsg);
     sqlite3_free(zErrMsg);
   } else {
     fprintf(stdout, "Operation done successfully\n");
   }  

  sqlite3_close(db);


  
  TCanvas* CardStat  = new TCanvas("CardStat", "CardStat", 750, 750);
  //  TPad* pad;
  // pad = (TPad*)CardStat->cd(1);
  hTNA->Draw(""); 

  std::cout << " Test_sqlite3: ended " << std::endl;
}