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.

References keyFile(), and AlCaHLTBitMon_QueryRunRegistry::string.

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

Member Function Documentation

bool ConnectionManager::connect

(

)

Definition at line 20 of file ConnectionManager.cc.

References clean(), conn, SiStripPI::DEFAULT, env, f, keyFile(), EcalCondDBWriter_cfi::password, 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(), HcalAssistant::getListOfChannelsFromDb(), 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(), o2o_db_cfgmap.DbManagerDAQ::update_hashmap(), Vispa.Plugins.EdmBrowser.EdmBrowserTabController.EdmBrowserTabController::updateViewMenu(), and Vispa.Plugins.ConfigEditor.ConfigEditorTabController.ConfigEditorTabController::updateViewMenu().

                                {
  if (env != nullptr)
    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 55 of file ConnectionManager.cc.

References conn, and env.

Referenced by Vispa.Views.LineDecayView.LineDecayView::createLineDecayContainer(), HcalAssistant::getListOfChannelsFromDb(), 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 == nullptr)
    return;
  env->terminateConnection(conn);
  oracle::occi::Environment::terminateEnvironment(env);
  env = nullptr;
  conn = nullptr;
}

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

(

const std::string &

query

)

Definition at line 50 of file ConnectionManager.cc.

References conn, and env.

Referenced by HcalAssistant::getListOfChannelsFromDb().

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

Member Data Documentation

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

private

Definition at line 23 of file ConnectionManager.h.

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

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

private

Definition at line 22 of file ConnectionManager.h.

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