ConnectionManager Class Reference

#include <ConnectionManager.h>

Public Member Functions
bool	connect ()
	ConnectionManager ()
void	disconnect ()
oracle::occi::Statement *	getStatement (const std::string &query)

Private Attributes
oracle::occi::Connection *	conn
oracle::occi::Environment *	env

Detailed Description

Definition at line 14 of file ConnectionManager.h.

Constructor & Destructor Documentation

ConnectionManager::ConnectionManager

(

)

Definition at line 9 of file ConnectionManager.cc.

                                     : env(0), conn(0) {
}

Member Function Documentation

bool ConnectionManager::connect

(

)

Definition at line 20 of file ConnectionManager.cc.

References clean, conn, env, f, keyFile(), alignCSCRings::s, AlCaHLTBitMon_QueryRunRegistry::string, and personalPlayback::username.

Referenced by Vispa.Gui.ZoomableScrollArea.ZoomableScrollArea::__init__(), Vispa.Views.PropertyView.BooleanProperty::__init__(), Vispa.Gui.FindDialog.FindDialog::_addScript(), Vispa.Gui.FindDialog.FindDialog::_addStringProperty(), Vispa.Main.Application.Application::_connectSignals(), Vispa.Plugins.ConfigEditor.CodeTableView.CodeTableView::_createItem(), Vispa.Gui.BoxContentDialog.BoxContentDialog::addButton(), Vispa.Gui.ToolBoxContainer.ToolBoxContainer::addWidget(), Vispa.Views.PropertyView.PropertyView::append(), Vispa.Views.PropertyView.PropertyView::appendAddRow(), Vispa.Main.Application.Application::createAction(), Vispa.Views.PropertyView.TextEditWithButtonProperty::createButton(), Vispa.Views.LineDecayView.LineDecayView::createLineDecayContainer(), Vispa.Views.PropertyView.TextEditWithButtonProperty::createLineEdit(), Vispa.Views.LineDecayView.LineDecayContainer::createObject(), Vispa.Views.PropertyView.TextEditWithButtonProperty::createTextEdit(), Vispa.Plugins.Browser.BrowserTabController.BrowserTabController::filterDialog(), Vispa.Plugins.Browser.BrowserTabController.BrowserTabController::find(), HcalChannelQualityXml::getBaseLineFromOmds(), HcalChannelQualityXml::getIovsFromOmds(), HcalAssistant::getListOfChannelsFromDb(), HcalO2OManager::getListOfOmdsIovs(), HcalO2OManager::getListOfOmdsTags(), HcalChannelQualityXml::getTagsFromOmds(), Vispa.Gui.PortWidget.PortWidget::mouseMoveEvent(), Vispa.Views.PropertyView.BooleanProperty::setChecked(), Vispa.Main.SplitterTab.SplitterTab::setController(), Vispa.Plugins.Browser.BrowserTab.BrowserTab::setController(), Vispa.Views.PropertyView.BooleanProperty::setReadOnly(), Vispa.Views.PropertyView.DropDownProperty::setReadOnly(), Vispa.Views.PropertyView.TextEditWithButtonProperty::setReadOnly(), Vispa.Plugins.Browser.BrowserTabController.BrowserTabController::setTab(), Vispa.Views.PropertyView.IntegerProperty::setValue(), Vispa.Plugins.Browser.BrowserTabController.BrowserTabController::switchCenterView(), Vispa.Plugins.EdmBrowser.EdmBrowserTabController.EdmBrowserTabController::updateViewMenu(), and Vispa.Plugins.ConfigEditor.ConfigEditorTabController.ConfigEditorTabController::updateViewMenu().

                                {
  if (env!=0) return true;
  std::string username,password,database;

  char s[100];
  FILE* f=fopen(keyFile.c_str(),"r");
  s[0]=0; fgets(s,100,f); clean(s); username=s;
  s[0]=0; fgets(s,100,f); clean(s); password=s;
  s[0]=0; fgets(s,100,f); clean(s); database=s;
  fclose(f);

  //  printf("'%s' '%s' '%s'\n",username.c_str(),password.c_str(),database.c_str());
  try {
    env = oracle::occi::Environment::createEnvironment (oracle::occi::Environment::DEFAULT);
    conn = env->createConnection (username, password, database);
  } catch (...) {
    return false;
  }
  return true;
}

void ConnectionManager::disconnect

(

)

Definition at line 44 of file ConnectionManager.cc.

References conn, and env.

Referenced by Vispa.Views.LineDecayView.LineDecayView::createLineDecayContainer(), HcalChannelQualityXml::getBaseLineFromOmds(), HcalChannelQualityXml::getIovsFromOmds(), HcalAssistant::getListOfChannelsFromDb(), HcalO2OManager::getListOfOmdsIovs(), HcalO2OManager::getListOfOmdsTags(), HcalChannelQualityXml::getTagsFromOmds(), Vispa.Views.PropertyView.BooleanProperty::setChecked(), Vispa.Views.PropertyView.BooleanProperty::setReadOnly(), Vispa.Views.PropertyView.DropDownProperty::setReadOnly(), Vispa.Views.PropertyView.TextEditWithButtonProperty::setReadOnly(), Vispa.Views.PropertyView.IntegerProperty::setValue(), Vispa.Plugins.EdmBrowser.EdmBrowserTabController.EdmBrowserTabController::updateViewMenu(), and Vispa.Plugins.ConfigEditor.ConfigEditorTabController.ConfigEditorTabController::updateViewMenu().

                                   {
  if (env==0) return;
  env->terminateConnection(conn);
  oracle::occi::Environment::terminateEnvironment(env);
  env=0; conn=0;
}

oracle::occi::Statement * ConnectionManager::getStatement

(

const std::string &

query

)

Definition at line 40 of file ConnectionManager.cc.

References conn, and env.

Referenced by HcalChannelQualityXml::getBaseLineFromOmds(), HcalChannelQualityXml::getIovsFromOmds(), HcalAssistant::getListOfChannelsFromDb(), HcalO2OManager::getListOfOmdsIovs(), HcalO2OManager::getListOfOmdsTags(), and HcalChannelQualityXml::getTagsFromOmds().

                                                                           {
  if (env==0) return 0;
  return conn->createStatement(query);
}

Member Data Documentation

oracle::occi::Connection* ConnectionManager::conn

private

Definition at line 22 of file ConnectionManager.h.

Referenced by connect(), disconnect(), and getStatement().

oracle::occi::Environment* ConnectionManager::env

private

Definition at line 21 of file ConnectionManager.h.

Referenced by connect(), disconnect(), and getStatement().