PamVMC_update/src/PamVMCSQLMgr.cxx

#include <iostream>
#include <TString.h>
#include "PamVMCSQLMgr.h"


using std::cout;
using std::endl;

PamVMCSQLMgr * PamVMCSQLMgr::fsql = 0;

PamVMCSQLMgr * PamVMCSQLMgr::Instance(){

  if(fsql == 0) {
    fsql = new PamVMCSQLMgr();
  }
  return fsql;
}
 
PamVMCSQLMgr::PamVMCSQLMgr(){
 
  TString G4WORKDIR=gSystem->Getenv("G4WORKDIR");
  TString PLATFORM=gSystem->Getenv("PLATFORM");
  TString PAM_VMC=gSystem->Getenv("PAM_VMC");  

  fpathtodata = PAM_VMC+"/lib/tgt_"+PLATFORM;
  fdbhost = gSystem->Getenv("PAM_DBHOST");
  fdbuser = gSystem->Getenv("PAM_DBUSER");
  fdbpsw = gSystem->Getenv("PAM_DBPSW");
  fdbc = TSQLServer::Connect(fdbhost.Data(),fdbuser.Data(),fdbpsw.Data());
  fglt = new GL_TABLES(fdbhost.Data(),fdbuser.Data(),fdbpsw.Data());
  fglparam = new GL_PARAM();
  fglroot = new GL_ROOT();
  fglcalo = new GL_CALO_CALIB();

  if(fdbc){
    //
    // Use UTC in the DB and make timeout bigger
    //
    stringstream myquery;
    myquery.str("");
    myquery << "SET time_zone='+0:00'";
    fdbc->Query(myquery.str().c_str());
    myquery.str("");
    myquery << "SET wait_timeout=173000;";
    fdbc->Query(myquery.str().c_str());
    //
  }

  if ( fglt->IsConnected(fdbc) ){
    cout<<"DB was connected.. Information:"<<endl
        <<"    SQL: "<<fdbc->GetDBMS()<<endl
        <<"VERSION: "<<fdbc->ServerInfo()<<endl
        <<"   HOST: "<<fdbc->GetHost()<<endl
        <<"   PORT: "<<fdbc->GetPort()<<endl;

  } else {
    cout<<"All paths to calibration files will be load from file"
        <<fpathtodata+"/calib_path.txt"<<endl;

    //Here I'll implement a possibility to load paths to detector
    //calibration files to use software in GRID (without DB)
    //in this case standard directory to keep all datafiles 
    //should be the library directory

  }
}
1	formato	1.1	#include <iostream>
2			#include <TString.h>
3			#include "PamVMCSQLMgr.h"
4
5
6			using std::cout;
7			using std::endl;
8
9			PamVMCSQLMgr * PamVMCSQLMgr::fsql = 0;
10
11			PamVMCSQLMgr * PamVMCSQLMgr::Instance(){
12
13			if(fsql == 0) {
14			fsql = new PamVMCSQLMgr();
15			}
16			return fsql;
17			}
18
19			PamVMCSQLMgr::PamVMCSQLMgr(){
20
21			TString G4WORKDIR=gSystem->Getenv("G4WORKDIR");
22			TString PLATFORM=gSystem->Getenv("PLATFORM");
23			TString PAM_VMC=gSystem->Getenv("PAM_VMC");
24
25			fpathtodata = PAM_VMC+"/lib/tgt_"+PLATFORM;
26			fdbhost = gSystem->Getenv("PAM_DBHOST");
27			fdbuser = gSystem->Getenv("PAM_DBUSER");
28			fdbpsw = gSystem->Getenv("PAM_DBPSW");
29			fdbc = TSQLServer::Connect(fdbhost.Data(),fdbuser.Data(),fdbpsw.Data());
30			fglt = new GL_TABLES(fdbhost.Data(),fdbuser.Data(),fdbpsw.Data());
31			fglparam = new GL_PARAM();
32			fglroot = new GL_ROOT();
33			fglcalo = new GL_CALO_CALIB();
34
35			if(fdbc){
36			//
37			// Use UTC in the DB and make timeout bigger
38			//
39			stringstream myquery;
40			myquery.str("");
41			myquery << "SET time_zone='+0:00'";
42			fdbc->Query(myquery.str().c_str());
43			myquery.str("");
44			myquery << "SET wait_timeout=173000;";
45			fdbc->Query(myquery.str().c_str());
46			//
47			}
48
49			if ( fglt->IsConnected(fdbc) ){
50			cout<<"DB was connected.. Information:"<<endl
51			<<" SQL: "<<fdbc->GetDBMS()<<endl
52			<<"VERSION: "<<fdbc->ServerInfo()<<endl
53			<<" HOST: "<<fdbc->GetHost()<<endl
54			<<" PORT: "<<fdbc->GetPort()<<endl;
55
56			} else {
57			cout<<"All paths to calibration files will be load from file"
58			<<fpathtodata+"/calib_path.txt"<<endl;
59
60			//Here I'll implement a possibility to load paths to detector
61			//calibration files to use software in GRID (without DB)
62			//in this case standard directory to keep all datafiles
63			//should be the library directory
64
65			}
66			}