EcalDBConnection.h

Go to the documentation of this file.

#ifndef ECALDBCONNECTION_HH
#define ECALDBCONNECTION_HH

#include "OnlineDB/Oracle/interface/Oracle.h"
#include <string>
#include <stdexcept>
#include <iostream>

#include "OnlineDB/EcalCondDB/interface/DateHandler.h"


class EcalDBConnection {
 public:

  /******************\
  -  public methods  -
  \******************/

  EcalDBConnection( std::string host,
            std::string sid,
            std::string user,
            std::string pass,
            int port = 1521 )
    throw(std::runtime_error);



  EcalDBConnection( std::string sid,
            std::string user,
            std::string pass )
    throw(std::runtime_error);
  


  virtual ~EcalDBConnection() throw(std::runtime_error);

  inline oracle::occi::Statement* createStatement()
    {
      std::cout << "Creating statement" << std::endl;
      return conn->createStatement();
    }

  inline void terminateStatement(oracle::occi::Statement* stmt)
    {
      std::cout << "Creating statement" << std::endl;
      conn->terminateStatement(stmt);
    }

  inline void commit() { conn->commit(); }
  inline void rollback() { conn->rollback(); }

  inline oracle::occi::Clob getClobLocator()
    {
      return oracle::occi::Clob(conn);
    }

  oracle::occi::Environment* getEnv() const { return env; };
  oracle::occi::Connection* getConn() const { return conn; };

 protected:
  
  /***********************\
  -  protected variables  -
  \***********************/

  oracle::occi::Environment* env;
  oracle::occi::Connection* conn;
  oracle::occi::Statement* stmt;

  std::string host;
  int port;
  std::string sid;
  std::string user;
  std::string pass;

};

#endif