CredentialStore.cc File Reference

#include "CondCore/CondDB/interface/CredentialStore.h"
#include "CondCore/CondDB/interface/Cipher.h"
#include "CondCore/CondDB/interface/Exception.h"
#include "CondCore/CondDB/interface/Auth.h"
#include "CoralBase/AttributeList.h"
#include "CoralBase/Attribute.h"
#include "CoralKernel/Context.h"
#include "CoralCommon/URIParser.h"
#include "RelationalAccess/AuthenticationCredentials.h"
#include "RelationalAccess/IBulkOperation.h"
#include "RelationalAccess/IConnection.h"
#include "RelationalAccess/ISession.h"
#include "RelationalAccess/IRelationalService.h"
#include "RelationalAccess/IRelationalDomain.h"
#include "RelationalAccess/ITransaction.h"
#include "RelationalAccess/ISchema.h"
#include "RelationalAccess/ITable.h"
#include "RelationalAccess/TableDescription.h"
#include "RelationalAccess/ITableDataEditor.h"
#include "RelationalAccess/ITablePrivilegeManager.h"
#include "RelationalAccess/IQuery.h"
#include "RelationalAccess/ICursor.h"
#include <filesystem>
#include <fstream>
#include <sstream>

Go to the source code of this file.

Classes
struct	cond::AuthorizationData
struct	cond::CredentialData
class	cond::CSScopedSession
struct	cond::PrincipalData

Namespaces
	cond

Functions
void	addSequence (const std::string &schemaVersion, coral::ISchema &schema, const std::string &name)
static const std::string	ADMIN_KEY_COL ("CRED2")
static const std::string	AUTH_ID_COL ("AUTH_ID")
static const std::string	AUTH_KEY_COL ("CRED3")
static const std::string	AUTHENTICATION_TABLE ("AUTHENTICATION")
static const std::string	AUTHORIZATION_TABLE ("AUTHORIZATION")
static const std::string	C_ID_COL ("C_ID")
static const std::string	CONNECTION_ID_COL ("CONN_ID")
static const std::string	CONNECTION_KEY_COL ("CRED7")
static const std::string	CONNECTION_LABEL_COL ("CONN_LABEL")
static const std::string	CREDENTIAL_TABLE ("CREDENTIAL")
const std::string	DEFAULT_DATA_SOURCE ("Cond_Default_Authentication")
size_t	cond::getAuthorizationEntries (const std::string &schemaVersion, coral::ISchema &schema, int principalId, const std::string &role, const std::string &connectionString)
bool	cond::getNextSequenceValue (const std::string &schemaVersion, coral::ISchema &schema, const std::string &sequenceName, int &value)
static const std::string	LEGACY_TABLE_PREFIX ("COND_")
static const std::string	P_ID_COL ("P_ID")
static const std::string	PASSWORD_COL ("CRED5")
static const std::string	PRINCIPAL_ID_COL ("P_ID")
static const std::string	PRINCIPAL_KEY_COL ("CRED1")
static const std::string	PRINCIPAL_NAME_COL ("P_NAME")
static const std::string	ROLE_COL ("C_ROLE")
static const std::string	SCHEMA_COL ("C_SCHEMA")
std::string	cond::schemaLabel (const std::string &serviceName, const std::string &userName)
std::string	cond::schemaLabelForCredentialStore (const std::string &connectionString)
bool	cond::selectAuthorization (const std::string &schemaVersion, coral::ISchema &schema, int principalId, const std::string &role, const std::string &connectionString, AuthorizationData &destination)
bool	cond::selectConnection (const std::string &schemaVersion, coral::ISchema &schema, const std::string &connectionLabel, CredentialData &destination)
bool	cond::selectPrincipal (const std::string &schemaVersion, coral::ISchema &schema, const std::string &principal, PrincipalData &destination)
static const std::string	SEQUENCE_NAME_COL ("NAME")
static const std::string	SEQUENCE_TABLE ("CREDENTIAL_SEQUENCE")
static const std::string	SEQUENCE_VALUE_COL ("VALUE")
bool	cond::setPermissionData (const std::string &schemaVersion, coral::ISchema &schema, int principalId, const std::string &principalKey, const std::string &role, const std::string &connectionString, int connectionId, const std::string &connectionKey, std::stringstream &log)
static const std::string	TABLE_PREFIX ("DB_")
std::string	tname (const std::string &tableName, const std::string &schemaVersion)
std::pair< int, std::string >	cond::updateConnectionData (const std::string &schemaVersion, coral::ISchema &schema, const std::string &adminKey, const std::string &connectionLabel, const std::string &userName, const std::string &password, bool forceUpdate, std::stringstream &log)
std::pair< int, std::string >	cond::updatePrincipalData (const std::string &schemaVersion, coral::ISchema &schema, const std::string &authenticationKey, const std::string &principalName, const std::string &adminKey, bool init, std::stringstream &log)
static const std::string	USERNAME_COL ("CRED4")
static const std::string	VERIFICATION_COL ("CRED0")
static const std::string	VERIFICATION_KEY_COL ("CRED6")

Variables
static const std::string	serviceName = "CondAuthenticationService"

Function Documentation

addSequence()

void addSequence	(	const std::string &	schemaVersion,
		coral::ISchema &	schema,
		const std::string &	name
	)

Definition at line 805 of file CredentialStore.cc.

                                                                                              {
  // Create the entry in the table
  coral::AttributeList insertData;
  insertData.extend<std::string>(SEQUENCE_NAME_COL);
  insertData.extend<int>(SEQUENCE_VALUE_COL);
  coral::AttributeList::iterator iAttribute = insertData.begin();
  iAttribute->data<std::string>() = name;
  ++iAttribute;
  iAttribute->data<int>() = -1;
  schema.tableHandle(tname(SEQUENCE_TABLE, schemaVersion)).dataEditor().insertRow(insertData);
}

References Skims_PA_cff::name, SEQUENCE_NAME_COL(), SEQUENCE_TABLE(), SEQUENCE_VALUE_COL(), AlCaHLTBitMon_QueryRunRegistry::string, and tname().

Referenced by cond::CredentialStore::createSchema().

ADMIN_KEY_COL()

static const std::string ADMIN_KEY_COL ( "CRED2"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::selectPrincipal(), and cond::updatePrincipalData().

AUTH_ID_COL()

static const std::string AUTH_ID_COL ( "AUTH_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::getAuthorizationEntries(), cond::selectAuthorization(), and cond::setPermissionData().

AUTH_KEY_COL()

static const std::string AUTH_KEY_COL ( "CRED3"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::getUserCredentials(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), and cond::setPermissionData().

AUTHENTICATION_TABLE()

static const std::string AUTHENTICATION_TABLE ( "AUTHENTICATION"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::drop(), cond::CredentialStore::listPrincipals(), cond::CredentialStore::removePrincipal(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), cond::CredentialStore::startSession(), and cond::updatePrincipalData().

AUTHORIZATION_TABLE()

static const std::string AUTHORIZATION_TABLE ( "AUTHORIZATION"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::drop(), cond::CredentialStore::exportAll(), cond::getAuthorizationEntries(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::removeConnection(), cond::CredentialStore::removePrincipal(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

C_ID_COL()

static const std::string C_ID_COL ( "C_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::removeConnection(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), and cond::CredentialStore::startSession().

CONNECTION_ID_COL()

static const std::string CONNECTION_ID_COL ( "CONN_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::removeConnection(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

CONNECTION_KEY_COL()

static const std::string CONNECTION_KEY_COL ( "CRED7"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

CONNECTION_LABEL_COL()

static const std::string CONNECTION_LABEL_COL ( "CONN_LABEL"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

CREDENTIAL_TABLE()

static const std::string CREDENTIAL_TABLE ( "CREDENTIAL"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::drop(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::CredentialStore::removeConnection(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

DEFAULT_DATA_SOURCE()

const std::string DEFAULT_DATA_SOURCE

(

"Cond_Default_Authentication"

)

LEGACY_TABLE_PREFIX()

static const std::string LEGACY_TABLE_PREFIX ( "COND_"  )

static

Referenced by tname().

P_ID_COL()

static const std::string P_ID_COL ( "P_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::getAuthorizationEntries(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::removePrincipal(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

PASSWORD_COL()

static const std::string PASSWORD_COL ( "CRED5"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

PRINCIPAL_ID_COL()

static const std::string PRINCIPAL_ID_COL ( "P_ID"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::removePrincipal(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), and cond::updatePrincipalData().

PRINCIPAL_KEY_COL()

static const std::string PRINCIPAL_KEY_COL ( "CRED1"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::selectPrincipal(), and cond::updatePrincipalData().

PRINCIPAL_NAME_COL()

static const std::string PRINCIPAL_NAME_COL ( "P_NAME"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::listPrincipals(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), and cond::updatePrincipalData().

ROLE_COL()

static const std::string ROLE_COL ( "C_ROLE"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::getAuthorizationEntries(), cond::CredentialStore::getUserCredentials(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

SCHEMA_COL()

static const std::string SCHEMA_COL ( "C_SCHEMA"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::getAuthorizationEntries(), cond::CredentialStore::getUserCredentials(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::setPermissionData(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

SEQUENCE_NAME_COL()

static const std::string SEQUENCE_NAME_COL ( "NAME"  )

static

Referenced by addSequence(), cond::CredentialStore::createSchema(), and cond::getNextSequenceValue().

SEQUENCE_TABLE()

static const std::string SEQUENCE_TABLE ( "CREDENTIAL_SEQUENCE"  )

static

Referenced by addSequence(), cond::CredentialStore::createSchema(), cond::CredentialStore::drop(), and cond::getNextSequenceValue().

SEQUENCE_VALUE_COL()

static const std::string SEQUENCE_VALUE_COL ( "VALUE"  )

static

Referenced by addSequence(), cond::CredentialStore::createSchema(), and cond::getNextSequenceValue().

TABLE_PREFIX()

static const std::string TABLE_PREFIX ( "DB_"  )

static

Referenced by tname().

tname()

std::string tname	(	const std::string &	tableName,
		const std::string &	schemaVersion
	)

Definition at line 150 of file CredentialStore.cc.

                                                                            {
  std::string prefix(TABLE_PREFIX);
  if (schemaVersion.empty())
    prefix = LEGACY_TABLE_PREFIX;
  return prefix + tableName;
}

References LEGACY_TABLE_PREFIX(), hcallasereventfilter2012_cfi::prefix, AlCaHLTBitMon_QueryRunRegistry::string, TABLE_PREFIX(), and HLT_Fake1_cff::tableName.

Referenced by addSequence(), HIPAlignmentAlgorithm::bookRoot(), clangcms::EDMPluginDumper::checkASTDecl(), HLTBitComputer::compute(), cond::CredentialStore::createSchema(), MEGeom::drawHist(), cond::CredentialStore::drop(), cond::CredentialStore::exportAll(), MELaserPrim::fill(), SiPixelActionExecutor::fillFEDErrorSummary(), SiPixelActionExecutor::fillSummary(), cond::getAuthorizationEntries(), cond::getNextSequenceValue(), cond::CredentialStore::getUserCredentials(), HLTBitComputer::HLTBitComputer(), cond::persistency::O2O_RUN::Table::insert(), cond::CredentialStore::listConnections(), cond::CredentialStore::listPrincipals(), HLTPerformanceInfo::Module::operator==(), HLTPerformanceInfo::Path::operator==(), cond::CredentialStore::removeConnection(), cond::CredentialStore::removePrincipal(), cond::selectAuthorization(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), MELaserPrim::setInt(), cond::setPermissionData(), MELaserPrim::setVal(), cond::CredentialStore::startSession(), AlignmentIORootBase::testFile(), AlignmentIORootBase::treeName(), cond::CredentialStore::unsetPermission(), cond::updateConnectionData(), and cond::updatePrincipalData().

USERNAME_COL()

static const std::string USERNAME_COL ( "CRED4"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

VERIFICATION_COL()

static const std::string VERIFICATION_COL ( "CRED0"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::selectPrincipal(), and cond::updatePrincipalData().

VERIFICATION_KEY_COL()

static const std::string VERIFICATION_KEY_COL ( "CRED6"  )

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::getUserCredentials(), cond::CredentialStore::listConnections(), cond::selectConnection(), cond::CredentialStore::selectForUser(), cond::CredentialStore::startSession(), and cond::updateConnectionData().

Variable Documentation

serviceName

const std::string serviceName = "CondAuthenticationService"

static

Definition at line 31 of file CredentialStore.cc.

Referenced by cond::auth::DecodingKey::addService(), cond::auth::DecodingKey::createFromInputFile(), cond::CredentialStore::importForPrincipal(), cond::persistency::parseConnectionString(), coral_bridge::AuthenticationCredentialSet::registerCredentials(), coral_bridge::AuthenticationCredentialSet::registerItem(), cond::schemaLabel(), cond::schemaLabelForCredentialStore(), cond::CredentialStore::setUpForConnectionString(), and cond::CredentialStore::setUpForService().