Gather data from DB. More...

#include <DBInterface.h>

Public Member Functions
	DBInterface (const std::string &fDb, bool fVerbose=false)
	~DBInterface ()
Protected Member Functions
template<class T >
bool	getObjectGeneric (T *fObject, const std::string &fTag)
Protected Attributes
oracle::occi::Connection *	mConnect
oracle::occi::Environment *	mEnvironment
oracle::occi::Statement *	mStatement
bool	mVerbose

Detailed Description

Gather data from DB.

Author:: Gena Kukartsev

Definition at line 27 of file DBInterface.h.

Constructor & Destructor Documentation

DBInterface::DBInterface	(	const std::string &	fDb,
		bool	fVerbose = `false`
	)

Definition at line 16 of file DBInterface.cc.

References dtNoiseDBValidation_cfg::cerr, query::host, mConnect, mEnvironment, mStatement, AlCaHLTBitMon_QueryRunRegistry::string, and hcal_dqm_sourceclient-file_cfg::user.

  : mConnect (0),
    mVerbose (fVerbose)
{
  mEnvironment = oracle::occi::Environment::createEnvironment (oracle::occi::Environment::OBJECT);
  // decode connect string
  size_t ipass = fDb.find ('/');
  size_t ihost = fDb.find ('@');

  if (ipass == std::string::npos || ihost == std::string::npos) {
    std::cerr << "DBInterface::DBInterface-> Error in connection std::string format: " << fDb
              << " Expect user/password@db" << std::endl;
  }
  else {
    std::string user (fDb, 0, ipass);
    std::string pass (fDb, ipass+1, ihost-ipass-1);
    std::string host (fDb, ihost+1);
    //    std::cout << "DBInterface::DBInterface-> Connecting " << user << '/' << pass << '@' << host << std::endl;
    try {
      mConnect = mEnvironment->createConnection(user, pass, host);
      mStatement = mConnect->createStatement ();
    }
    catch (oracle::occi::SQLException& sqlExcp) {
      std::cerr << "DBInterface::DBInterface exception-> " << sqlExcp.getErrorCode () << ": " << sqlExcp.what () << std::endl;
    }
  }
}

DBInterface::~DBInterface ( )

Definition at line 44 of file DBInterface.cc.

References mConnect, mEnvironment, and mStatement.

                           {
  delete mStatement;
  mEnvironment->terminateConnection (mConnect);
  oracle::occi::Environment::terminateEnvironment (mEnvironment);
}