Classes
class	_Col

class	BoostRunMap

class	Connection

class	DbRef

class	GlobalTag

class	GlobalTagMap

class	IOV

class	Payload

class	RunInfo

class	Synchronization

class	Tag

class	TagAuthorization

class	TagLog

class	TagMetadata

class	TimeType

Functions
def	_exists

def	_getCMSFrontierConnectionString

def	_getCMSSQLAlchemyConnectionString

def	_inserted_before

def	connect

def	fq_col

def	fq_name

def	getPayload

def	getSchema

def	getSessionOnMasterDB

def	hash

def	listObject

def	make_dbtype

def	make_url

def	oracle_connection_string

Variables
string	__author__ = 'Miguel Ojeda'

string	__copyright__ = 'Copyright 2013, CERN'

list	__credits__ = ['Giacomo Govi', 'Miguel Ojeda', 'Andreas Pfeiffer']

string	__email__ = 'giacomo.govi@cern.ch'

string	__license__ = 'Unknown'

string	__maintainer__ = 'Giacomo Govi'

tuple	_Base = sqlalchemy.ext.declarative.declarative_base()

string	ARC = 'FrontierArc'

string	authPathEnvVar = 'COND_AUTH_PATH'

string	contact_help = 'If you need assistance, please write an email to %s and %s. If you need immediate/urgent assistance, you can call the Offline DB expert on call (%s).'

string	database_help

dictionary	db_models = {}

string	dbkey_filename = 'db.key'

tuple	dbkey_folder = os.path.join('.cms_cond',dbkey_filename)

string	dbreader_user_name = 'cms_cond_general_r'

string	dbuser_name = 'cms_conditions'

string	dbwriter_user_name = 'cms_cond_general_w'

int	description_length = 4000

string	DEV = 'FrontierPrep'

string	empty_label = '-'

tuple	hash_length = len(hash(''))

string	INT = 'FrontierInt'

tuple	logger = logging.getLogger(__name__)

int	name_length = 100

string	offline_db_experts_email = 'cms-offlinedb-exp@cern.ch'

string	offline_db_experts_phone = '+41 22 76 70817, or 70817 from CERN; check https://twiki.cern.ch/twiki/bin/viewauth/CMS/DBShifterHelpPage if it does not work; availability depends on the state of the LHC'

string	ONLINEORAINT = 'cmsintr_lb'

string	ONLINEORAPRO = 'cms_orcon_prod'

string	ORAARC = 'cmsarc_lb'

string	ORADEV = 'cms_orcoff_prep'

string	ORAINT = 'cms_orcoff_int'

string	ORAPRO = 'cms_orcon_adg'

string	PRO = 'PromptProd'

string	schema_name = 'cms_conditions'

tuple	synch_list = list(x.value for x in list(Synchronization))

string	web_experts_email = 'cms-cond-dev@cern.ch'

Detailed Description

CMS Conditions DB Python library.

Function Documentation

def conddblib._exists	(	session,
		primary_key,
		value
	)

private

Definition at line 609 of file conddblib.py.

References submitPVResolutionJobs.count, and alcazmumu_cfi.filter.

Referenced by listObject().

 
 def _exists(session, primary_key, value):
     ret = None
     try: 
         ret = session.query(primary_key).\
             filter(primary_key == value).\
             count() != 0
     except sqlalchemy.exc.OperationalError:
         pass
 
     return ret

conddblib._exists

def _exists

Definition: conddblib.py:609

alcazmumu_cfi.filter

tuple filter

Definition: alcazmumu_cfi.py:34

submitPVResolutionJobs.count

tuple count

Definition: submitPVResolutionJobs.py:352

def conddblib.connect	(	url,
		authPath = `None`,
		verbose = `0`,
		as_admin = `False`
	)

def conddblib.fq_col	(	schema,
		table,
		column
	)

def conddblib.listObject	(	session,
		name,
		snapshot = `None`
	)

def conddblib.make_dbtype	(	backendName,
		schemaName,
		baseType
	)

def conddblib.make_url	(	database = `'pro'`,
		read_only = `True`
	)

def conddblib.oracle_connection_string	(	db_service,
		db_schema
	)

def conddblib.fq_name	(	schema_name,
		table_name
	)

def conddblib.getPayload	(	session,
		hash
	)

def conddblib.getSessionOnMasterDB	(	session1,
		session2
	)

Classes

Functions

Variables

Detailed Description

Function Documentation

Variable Documentation