test_emc.cxx

Go to the documentation of this file.

// $Header: /bes/bes/BossCvs/Calibration/rdbModel/src/test/test_build.cxx,v 1.1.1.1 2005/10/17 06:10:53 maqm Exp $
// Test program for rdbModel primitive buiding blocks
 
#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 "TBufferFile.h"
#include <fstream>
#define TEST_SQL
 
int main(int argc, char** argv) {
  char *opt_host_name = "202.122.37.69";   
 char *opt_user_name = "maqm";   
 char *opt_password  = "";   
 unsigned int opt_port_num = 3306;   
 char *opt_socket_name = NULL;   
 char *opt_db_name = "offlinedb";
 /*char *opt_host_name=argv[1];
 unsigned int opt_port_num = 3306;
    //sscanf(agv[2],"%d",opt_port_name);
 char *opt_socket_name = NULL;
 char *opt_db_name = argv[3];
 char *opt_user_name = argv[4];
 char *opt_password = argv[5];
 
 char *opt_table_name = argv[7];
   */
 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");
  if(conn!=0){
    std::cout<<"connect the database ok\n"<<std::endl;
  }else{
    std::cout<<"can't connect to the db:"<<std::endl;
    return -1;
  }
  
unsigned long *lengths;
 
 MYSQL_RES *res_set;
 MYSQL_ROW row;
 
 char stmt1[200];//="select context from mytesttable where id = %d,";
 sprintf(stmt1,"select  DigiCalibConst from EmcCalConst where serno = 456");
 
 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); 
std::cout << "zzz: " << lengths[0] << std::endl;
// ofstream ofs("out.bin", std::ios::binary);
//ofs.write(row[0], lengths[0]);
//return 0;
 newHist->Streamer(rootBuffer2); 
   newHist->Print(); 
  int  nentri = newHist -> GetEntries();
   std::cout<<"nentri is:"<<nentri<<std::endl;
double rungain[7000];
newHist->SetBranchAddress("DigiCalibConst", rungain);
 for ( int i = 0; i < 6240; ++i ) {
   newHist->GetEntry(i);
   std::cout << "  rungain: " << rungain[i] << std::endl;
}
 
  return 0;
}