test_dedxsim.cxx File Reference

#include <iostream>
#include <string>
#include <cstdlib>
#include <time.h>
#include <stdio.h>
#include <string.h>
#include <mysql/mysql.h>
#include "TFile.h"
#include "TTree.h"
#include "TH1F.h"
#include "TBufferFile.h"
#include <fstream>

Go to the source code of this file.

Macros
#define	TEST_SQL

Functions
int	main (int argc, char **argv)

Macro Definition Documentation

TEST_SQL

#define TEST_SQL

Definition at line 16 of file test_dedxsim.cxx.

Function Documentation

main()

int main	(	int	argc,
		char **	argv
	)

Definition at line 19 of file test_dedxsim.cxx.

                                {
  char *opt_host_name = "202.122.37.69";   
 char *opt_user_name = "maqm";   
 unsigned int opt_port_num = 3306;   
 char *opt_socket_name = NULL;   
 char *opt_db_name = "offlinedb";
   
 unsigned int opt_flags = 0;   
 MYSQL *conn;   
 
 
 
conn = mysql_init(NULL);   
     
 mysql_real_connect(conn, opt_host_name, opt_user_name, opt_password, 
           opt_db_name, opt_port_num, opt_socket_name, opt_flags);
 printf("connect the database ok\n");
 
unsigned long *lengths;
 
 MYSQL_RES *res_set;
 MYSQL_ROW row;
 
 
 //====================================
 //search in the MYSQL 
 //=====================================
 char stmt1[200];//="select context from mytesttable where id = %d,";
 sprintf(stmt1,"select  TH1F_col from DedxSim where serno = 38");
 
 printf("%s\n",stmt1);
 if(mysql_real_query(conn, stmt1, strlen(stmt1)) != 0)
  printf("query error\n");
 res_set = mysql_store_result (conn);
 mysql_field_seek (res_set, 0); 
 
 row = mysql_fetch_row (res_set);
 lengths = mysql_fetch_lengths(res_set);
 for(int i=0;i<5;i++){ 
   std::cout<<"lengths["<<i<<"]="<<lengths[i]<<std::endl;
   }
  
 //====================================
 //read the calibdata from the buffer
 //====================================
 //TTree* newHist= new TTree(); 
 //TBufferFile rootBuffer2(TBufferFile::kRead,lengths[0], row[0], kFALSE); 
 TBufferFile rootBuffer2(TBufferFile::kRead,lengths[0], row[0], kFALSE); 
 TTree tree;
 
 tree.Streamer(rootBuffer2);
 //gROOT->cd();
 
 tree.Print();
 
 
 // ofstream ofs("out.bin", std::ios::binary);
 //ofs.write(row[0], lengths[0]);
 //return 0;
 /*maqm newHist->Streamer(rootBuffer2); 
   newHist->Print(); 
   int  nentri = newHist -> GetEntries();
   std::cout<<"nentri is:"<<nentri<<std::endl;*/
 //*runcalib
 int    runno;
 double rungain;
 /*maqm newHist->SetBranchAddress("runno", &runno);
   newHist->SetBranchAddress("rungain", &rungain);
   for ( int i = 0; i < 10; ++i ) {
   newHist->GetEntry(i);
   std::cout << "runno: " << runno << "  rungain: " << rungain << std::endl;
   }
  */
 //print values of wiregain
 /*  double gwire[6796];
     newHist->SetBranchAddress("wireg", &gwire);
     newHist->GetEntry(0);
     for(int i=0;i<200;i++)
     std::cout<<"gwire: ["<<i<<"] = "<<gwire[i]<<std::endl;
  */
 /*   double gwire[7000];
      gwire=newHist->GetEntry(0);
      for(int i=0;i<200;i++)
      std::cout<<"gwire: ["<<i<<"] = "<<gwire[i]<<std::endl;*/
 
 return 0;
}