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/IQuery.h"
#include "RelationalAccess/ICursor.h"
#include <sstream>
#include <fstream>
#include <boost/filesystem.hpp>

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 (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	C_ID_COL ("C_ID")
static const std::string	COND_AUTHENTICATION_TABLE ("COND_AUTHENTICATION")
static const std::string	COND_AUTHORIZATION_TABLE ("COND_AUTHORIZATION")
static const std::string	COND_CREDENTIAL_TABLE ("COND_CREDENTIAL")
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")
const std::string	DEFAULT_DATA_SOURCE ("Cond_Default_Authentication")
bool	getNextSequenceValue (coral::ISchema &schema, const std::string &sequenceName, int &value)
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 (coral::ISchema &schema, int principalId, const std::string &role, const std::string &connectionString, AuthorizationData &destination)
bool	cond::selectConnection (coral::ISchema &schema, const std::string &connectionLabel, CredentialData &destination)
bool	cond::selectPrincipal (coral::ISchema &schema, const std::string &principal, PrincipalData &destination)
static const std::string	SEQUENCE_NAME_COL ("NAME")
static const std::string	SEQUENCE_TABLE_NAME ("COND_CREDENTIAL_SEQUENCE")
static const std::string	SEQUENCE_VALUE_COL ("VALUE")
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

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

Definition at line 739 of file CredentialStore.cc.

References SEQUENCE_NAME_COL(), SEQUENCE_TABLE_NAME(), SEQUENCE_VALUE_COL(), and AlCaHLTBitMon_QueryRunRegistry::string.

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

                                                               {
  // 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( SEQUENCE_TABLE_NAME ).dataEditor().insertRow( insertData );
}

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

static

Referenced by cond::CredentialStore::addUser(), cond::CredentialStore::createSchema(), cond::CredentialStore::installAdmin(), cond::selectPrincipal(), and cond::CredentialStore::updatePrincipal().

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

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::installAdmin(), cond::selectAuthorization(), and cond::CredentialStore::setPermission().

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

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::installAdmin(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), and cond::CredentialStore::setPermission().

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

static

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

static const std::string COND_AUTHENTICATION_TABLE ( "COND_AUTHENTICATION"  )

static

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

static const std::string COND_AUTHORIZATION_TABLE ( "COND_AUTHORIZATION"  )

static

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

static const std::string COND_CREDENTIAL_TABLE ( "COND_CREDENTIAL"  )

static

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

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

static

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

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

static

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

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

static

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

const std::string DEFAULT_DATA_SOURCE

(

"Cond_Default_Authentication"

)

bool getNextSequenceValue	(	coral::ISchema &	schema,
		const std::string &	sequenceName,
		int &	value
	)

Definition at line 356 of file CredentialStore.cc.

References o2o::query, runTheMatrix::ret, SEQUENCE_NAME_COL(), SEQUENCE_TABLE_NAME(), SEQUENCE_VALUE_COL(), and AlCaHLTBitMon_QueryRunRegistry::string.

Referenced by cond::CredentialStore::addUser(), cond::CredentialStore::installAdmin(), cond::CredentialStore::setPermission(), cond::CredentialStore::updateConnection(), and cond::CredentialStore::updatePrincipal().

                                                                                            {
  bool ret = false;
  std::auto_ptr< coral::IQuery > query( schema.tableHandle( SEQUENCE_TABLE_NAME ).newQuery() );
  query->limitReturnedRows( 1, 0 );
  query->addToOutputList( SEQUENCE_VALUE_COL );
  query->defineOutputType( SEQUENCE_VALUE_COL, coral::AttributeSpecification::typeNameForType<int>() );
  query->setForUpdate();
  std::string whereClause( SEQUENCE_NAME_COL + " = :" + SEQUENCE_NAME_COL );
  coral::AttributeList rowData;
  rowData.extend<std::string>( SEQUENCE_NAME_COL );
  rowData.begin()->data< std::string >() = sequenceName;
  query->setCondition( whereClause, rowData );
  coral::ICursor& cursor = query->execute();
  if ( cursor.next() ) {
    value = cursor.currentRow().begin()->data<int>()+1;
    ret = true;
  } else {
    return false;
  }
  // update...
  coral::AttributeList updateData;
  updateData.extend<std::string>( SEQUENCE_NAME_COL );
  updateData.extend<int>( SEQUENCE_VALUE_COL );
  std::string setClause( SEQUENCE_VALUE_COL + " = :" +  SEQUENCE_VALUE_COL );
  std::string whClause( SEQUENCE_NAME_COL  + " = :" + SEQUENCE_NAME_COL );
  coral::AttributeList::iterator iAttribute = updateData.begin();
  iAttribute->data< std::string >() = sequenceName;
  ++iAttribute;
  iAttribute->data< int >() = value;
  schema.tableHandle( SEQUENCE_TABLE_NAME ).dataEditor().updateRows( setClause,whClause,updateData );
  return ret;
}

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

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::installAdmin(), cond::CredentialStore::removePrincipal(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::setPermission(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

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

static

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

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

static

Referenced by cond::CredentialStore::addUser(), cond::CredentialStore::createSchema(), cond::CredentialStore::installAdmin(), cond::CredentialStore::removePrincipal(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), and cond::CredentialStore::updatePrincipal().

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

static

Referenced by cond::CredentialStore::addUser(), cond::CredentialStore::createSchema(), cond::CredentialStore::installAdmin(), cond::selectPrincipal(), and cond::CredentialStore::updatePrincipal().

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

static

Referenced by cond::CredentialStore::addUser(), cond::CredentialStore::createSchema(), cond::CredentialStore::installAdmin(), cond::CredentialStore::listPrincipals(), cond::CredentialStore::selectPermissions(), cond::selectPrincipal(), and cond::CredentialStore::updatePrincipal().

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

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::installAdmin(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::setPermission(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

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

static

Referenced by cond::CredentialStore::createSchema(), cond::CredentialStore::exportAll(), cond::CredentialStore::installAdmin(), cond::selectAuthorization(), cond::CredentialStore::selectForUser(), cond::CredentialStore::selectPermissions(), cond::CredentialStore::setPermission(), cond::CredentialStore::startSession(), and cond::CredentialStore::unsetPermission().

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

static

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

static const std::string SEQUENCE_TABLE_NAME ( "COND_CREDENTIAL_SEQUENCE"  )

static

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

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

static

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

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

static

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

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

static

Referenced by cond::CredentialStore::addUser(), cond::CredentialStore::createSchema(), cond::CredentialStore::installAdmin(), cond::selectPrincipal(), and cond::CredentialStore::updatePrincipal().

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

static

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

Variable Documentation

const std::string serviceName = "CondAuthenticationService"

static

Definition at line 30 of file CredentialStore.cc.

Referenced by 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().