#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> 

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");
  return 0;
}

void Test_sqlite3()
{

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

  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;


}