ora::OraMainTable Class Reference

#include <OraDatabaseSchema.h>

Inheritance diagram for ora::OraMainTable:

Public Member Functions
void	create ()
void	drop ()
bool	exists ()
bool	getParameters (std::map< std::string, std::string > &destination)
std::string	name ()
	OraMainTable (coral::ISchema &dbSchema)
std::string	schemaVersion ()
void	setParameter (const std::string &paramName, const std::string &paramValue)
virtual	~OraMainTable ()
Public Member Functions inherited from ora::IMainTable
	IMainTable (coral::ISchema &schema)
virtual	~IMainTable ()
Public Member Functions inherited from ora::IDatabaseTable
	IDatabaseTable (coral::ISchema &schema)
coral::ISchema &	schema ()
virtual void	setAccessPermission (const std::string &principal, bool forWrite)
virtual	~IDatabaseTable ()

Static Public Member Functions
static std::string	parameterNameColumn ()
static std::string	parameterValueColumn ()
static std::string	tableName ()
static std::string	version ()
Static Public Member Functions inherited from ora::IMainTable
static std::string	userSchemaVersionParameterName ()
static std::string	versionParameterName ()

Detailed Description

Definition at line 10 of file OraDatabaseSchema.h.

Constructor & Destructor Documentation

ora::OraMainTable::OraMainTable ( coral::ISchema &  dbSchema )

explicit

Definition at line 36 of file OraDatabaseSchema.cc.

                                                     :
  IMainTable( dbSchema ){
}

ora::OraMainTable::~OraMainTable ( )

virtual

Definition at line 40 of file OraDatabaseSchema.cc.

                              {
}

Member Function Documentation

void ora::OraMainTable::create ( )

virtual

Implements ora::IDatabaseTable.

Definition at line 84 of file OraDatabaseSchema.cc.

References python.IdGenerator::schema, AlCaHLTBitMon_QueryRunRegistry::string, table, ora::throwException(), BeamSplash_cfg::version, and ora::IMainTable::versionParameterName().

                            {
  if( schema().existsTable( tableName() )){
    throwException( "ORA database main table already exists in this schema.",
                    "OraMainTable::create");
  }
  
  coral::TableDescription descr( "OraDb" );
  descr.setName( tableName() );
  descr.insertColumn( parameterNameColumn(),
                      coral::AttributeSpecification::typeNameForType<std::string>() );
  descr.insertColumn( parameterValueColumn(),
                      coral::AttributeSpecification::typeNameForType<std::string>() );
  descr.setNotNullConstraint( parameterNameColumn() );
  descr.setNotNullConstraint( parameterValueColumn() );
  descr.setPrimaryKey( std::vector<std::string>( 1, parameterNameColumn() ) );

  coral::ITable& table = schema().createTable( descr );

  coral::AttributeList dataToInsert;
  dataToInsert.extend<std::string>( parameterNameColumn());
  dataToInsert.extend<std::string>( parameterValueColumn());
  dataToInsert[ parameterNameColumn() ].data<std::string>() = IMainTable::versionParameterName();
  dataToInsert[ parameterValueColumn() ].data<std::string>() = version();
  table.dataEditor().insertRow( dataToInsert );
}

void ora::OraMainTable::drop ( )

virtual

Implements ora::IDatabaseTable.

Definition at line 110 of file OraDatabaseSchema.cc.

References python.IdGenerator::schema.

                          {
  schema().dropIfExistsTable( tableName() );
}

bool ora::OraMainTable::exists ( )

virtual

Implements ora::IDatabaseTable.

Definition at line 80 of file OraDatabaseSchema.cc.

References python.IdGenerator::schema.

Referenced by ora::OraDatabaseSchema::existsMainTable().

                            {
  return schema().existsTable( tableName() );
}

bool ora::OraMainTable::getParameters ( std::map< std::string, std::string > &  destination )

virtual

Implements ora::IMainTable.

Definition at line 56 of file OraDatabaseSchema.cc.

References o2o::query, run_regression::ret, python.IdGenerator::schema, and AlCaHLTBitMon_QueryRunRegistry::string.

                                                                      {
  bool ret = false;
  coral::ITable& mainTable = schema().tableHandle( tableName() );
  std::auto_ptr<coral::IQuery> query(mainTable.newQuery());
  coral::ICursor& cursor = query->execute();
  while ( cursor.next() ) {
    ret = true;
    const coral::AttributeList& row = cursor.currentRow();
    std::string paramName = row[ parameterNameColumn()].data< std::string >();
    std::string paramValue = row[ parameterValueColumn()].data< std::string >();
    dest.insert( std::make_pair( paramName, paramValue ) );
  }
  return ret;
}

std::string ora::OraMainTable::name ( )

virtual

Implements ora::IDatabaseTable.

Definition at line 76 of file OraDatabaseSchema.cc.

Referenced by cuy.divideElement::__init__(), cuy.plotElement::__init__(), cuy.additionElement::__init__(), cuy.superimposeElement::__init__(), cuy.graphElement::__init__(), config.CFG::__str__(), and Vispa.Views.PropertyView.Property::valueChanged().

                               {
  return tableName();
}

std::string ora::OraMainTable::parameterNameColumn ( )

static

Definition at line 26 of file OraDatabaseSchema.cc.

References AlCaHLTBitMon_QueryRunRegistry::string.

                                              {
  static const std::string s_column("PARAMETER_NAME");
  return s_column;
}

std::string ora::OraMainTable::parameterValueColumn ( )

static

Definition at line 31 of file OraDatabaseSchema.cc.

References AlCaHLTBitMon_QueryRunRegistry::string.

                                               {
  static const std::string s_column("PARAMETER_VALUE");
  return s_column;
}

std::string ora::OraMainTable::schemaVersion ( )

virtual

Implements ora::IMainTable.

Definition at line 71 of file OraDatabaseSchema.cc.

References BeamSplash_cfg::version.

                                        {
  // could be replaced by a call to getParameters in case of needs to distinguish between ora db schema versions...
  return version();
}

void ora::OraMainTable::setParameter ( const std::string &  paramName, const std::string &  paramValue  )

virtual

Implements ora::IMainTable.

Definition at line 43 of file OraDatabaseSchema.cc.

References python.IdGenerator::schema, AlCaHLTBitMon_QueryRunRegistry::string, and table.

Referenced by editorTools.UserCodeTool::__call__(), HiCoreTools.RestrictInputToAOD::__call__(), coreTools.RunOnData::__call__(), trackTools.MakeAODTrackCandidates::__call__(), runJetUncertainties.RunJetUncertainties::__call__(), metTools.AddMETCollection::__call__(), editorTools.ChangeSource::__call__(), HiCoreTools.RemoveMCMatching::__call__(), cmsswVersionTools.PickRelValInputFiles::__call__(), coreTools.RemoveMCMatching::__call__(), trackTools.MakePATTrackCandidates::__call__(), jetTools.AddJetCollection::__call__(), trigTools.SwitchOnTrigger::__call__(), HiCoreTools.RemoveAllPATObjectsBut::__call__(), runType1CaloMEtUncertainties.RunType1CaloMEtUncertainties::__call__(), HiCoreTools.RemoveSpecificPATObjects::__call__(), trigTools.SwitchOnTriggerStandAlone::__call__(), trackTools.MakeTrackCandidates::__call__(), runMVAMEtUncertainties.RunMVAMEtUncertainties::__call__(), tauTools.AddTauCollection::__call__(), jmeUncertaintyTools.JetMEtUncertaintyTools::__call__(), trigTools.SwitchOnTriggerMatching::__call__(), HiCoreTools.RemoveCleaning::__call__(), runType1PFMEtUncertainties.RunType1PFMEtUncertainties::__call__(), HiCoreTools.AddCleaning::__call__(), runNoPileUpMEtUncertainties.RunNoPileUpMEtUncertainties::__call__(), trigTools.SwitchOnTriggerMatchingStandAlone::__call__(), trigTools.SwitchOnTriggerMatchEmbedding::__call__(), jetTools.SwitchJetCollection::__call__(), jetTools.AddJetID::__call__(), and jetTools.SetTagInfos::__call__().

                                                                   {
  if( !paramName.empty() && !paramValue.empty() ){
    coral::ITable& table = schema().tableHandle( tableName() );
    coral::AttributeList dataToInsert;
    dataToInsert.extend<std::string>( parameterNameColumn());
    dataToInsert.extend<std::string>( parameterValueColumn());
    dataToInsert[ parameterNameColumn() ].data<std::string>() = paramName;
    dataToInsert[ parameterValueColumn() ].data<std::string>() = paramValue;
    table.dataEditor().insertRow( dataToInsert );
  }
}

std::string ora::OraMainTable::tableName ( )

static

Definition at line 21 of file OraDatabaseSchema.cc.

References AlCaHLTBitMon_QueryRunRegistry::string.

                                    {
  static const std::string s_name("ORA_DB");
  return s_name;
}

std::string ora::OraMainTable::version ( )

static

Definition at line 16 of file OraDatabaseSchema.cc.

References AlCaHLTBitMon_QueryRunRegistry::string.

                                  {
  static const std::string s_version("1.1.0");
  return s_version;
}