pamVMC/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");
  
  fpathtodata = G4WORKDIR+"/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	pamelats	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
24			fpathtodata = G4WORKDIR+"/lib/tgt_"+PLATFORM;
25			fdbhost = gSystem->Getenv("PAM_DBHOST");
26			fdbuser = gSystem->Getenv("PAM_DBUSER");
27			fdbpsw = gSystem->Getenv("PAM_DBPSW");
28			fdbc = TSQLServer::Connect(fdbhost.Data(),fdbuser.Data(),fdbpsw.Data());
29			fglt = new GL_TABLES(fdbhost.Data(),fdbuser.Data(),fdbpsw.Data());
30			fglparam = new GL_PARAM();
31			fglroot = new GL_ROOT();
32			fglcalo = new GL_CALO_CALIB();
33
34			if(fdbc){
35			//
36			// Use UTC in the DB and make timeout bigger
37			//
38			stringstream myquery;
39			myquery.str("");
40			myquery << "SET time_zone='+0:00'";
41			fdbc->Query(myquery.str().c_str());
42			myquery.str("");
43			myquery << "SET wait_timeout=173000;";
44			fdbc->Query(myquery.str().c_str());
45			//
46			}
47
48			if ( fglt->IsConnected(fdbc) ){
49			cout<<"DB was connected.. Information:"<<endl
50			<<" SQL: "<<fdbc->GetDBMS()<<endl
51			<<"VERSION: "<<fdbc->ServerInfo()<<endl
52			<<" HOST: "<<fdbc->GetHost()<<endl
53			<<" PORT: "<<fdbc->GetPort()<<endl;
54
55			} else {
56			cout<<"All paths to calibration files will be load from file"
57			<<fpathtodata+"/calib_path.txt"<<endl;
58
59			//Here I'll implement a possibility to load paths to detector
60			//calibration files to use software in GRID (without DB)
61			//in this case standard directory to keep all datafiles
62			//should be the library directory
63
64			}
65			}