def connect(self): if self.args.db is None: self.args.db = 'pro' if self.args.db == 'dev' or self.args.db == 'oradev': db_service = dev_db_service elif self.args.db == 'orapro': db_service = adg_db_service elif self.args.db != 'onlineorapro' or self.args.db != 'pro': db_service = prod_db_service else: raise Exception("Database '%s' is not known." % args.db) if self.args.accessType not in db_service[1].keys(): raise Exception( 'The specified database connection %s does not support the requested action.' % db_service[0]) service = db_service[1][self.args.accessType] creds = auth.get_credentials(authPathEnvVar, service, self.args.auth) if creds is None: raise Exception("Could not find credentials for service %s" % service) (username, account, pwd) = creds connStr = '%s/%s@%s' % (username, pwd, db_service[0]) self.db = cx_Oracle.connect(connStr) logging.info('Connected to %s as user %s' % (db_service[0], username)) self.db.current_schema = schema_name
def get_readOnly_db_credentials(): creds = credentials.get_credentials(authPathEnvVar, db_machine) if not creds is None: (username, account, pwd) = creds return db_service, username, pwd else: raise Exception('Entry for service %s not found in .netrc' % db_machine)
def get_url(self, force_schema=False): if self.db_service == None: url = private_db else: authEntry = self.db_service[1] if force_schema and self.schema: authEntry = '%s/%s' % (self.db_service[0], self.schema) username, _, pwd = auth.get_credentials(authPathEnvVar, authEntry, self.authFile) url = sqlalchemy_tpl % (username, pwd, self.db_service[0]) return url
def get_url(self, force_schema=False): if self.db_service == None: url = private_db else: authEntry = self.db_service[1] if force_schema and self.schema: authEntry = '%s/%s' % (self.db_service[0], self.schema) username, _, pwd = auth.get_credentials(authPathEnvVar, authEntry, self.authFile) url = sqlalchemy_tpl % (username, pwd, self.db_service[0]) return url
def connect( self ): if self.args.db is None: self.args.db = 'pro' if self.args.db == 'dev' or self.args.db == 'oradev' : db_service = dev_db_service elif self.args.db == 'orapro': db_service = adg_db_service elif self.args.db != 'onlineorapro' or self.args.db != 'pro': db_service = prod_db_service else: raise Exception("Database '%s' is not known." %args.db ) if self.args.accessType not in db_service[1].keys(): raise Exception('The specified database connection %s does not support the requested action.' %db_service[0]) service = db_service[1][self.args.accessType] creds = auth.get_credentials( authPathEnvVar, service, self.args.auth ) if creds is None: raise Exception("Could not find credentials for service %s" %service) (username, account, pwd) = creds connStr = '%s/%s@%s' %(username,pwd,db_service[0]) self.db = cx_Oracle.connect(connStr) logging.info('Connected to %s as user %s' %(db_service[0],username)) self.db.current_schema = schema_name
def get_db_credentials(db_service, authFile): (username, account, pwd) = auth.get_credentials(authPathEnvVar, db_service[1], authFile) return username, pwd
destinations=cms.untracked.vstring("cout")) process.maxEvents = cms.untracked.PSet(input=cms.untracked.int32(1)) process.source = cms.Source("EmptySource", numberEventsInRun=cms.untracked.uint32(1), firstRun=cms.untracked.uint32(1)) process.load("OnlineDB.SiStripConfigDb.SiStripConfigDb_cfi") process.SiStripConfigDb.UsingDb = True process.SiStripConfigDb.TNS_ADMIN = os.environ["TNS_ADMIN"] process.SiStripConfigDb.Partitions = cms.untracked.PSet(_CFGLINES_) if 'CONFDB' not in os.environ: import CondCore.Utilities.credentials as auth user, _, passwd = auth.get_credentials('COND_AUTH_PATH', 'cms_omds_tunnel/cms_trk_r') process.SiStripConfigDb.ConfDb = '{user}/{passwd}@{path}'.format( user=user, passwd=passwd, path='cms_omds_tunnel') process.SiStripDetInfoFileReader = cms.Service("SiStripDetInfoFileReader") process.load("OnlineDB.SiStripO2O.SiStripO2OCalibrationFactors_cfi") process.SiStripCondObjBuilderFromDb = cms.Service( "SiStripCondObjBuilderFromDb", process.SiStripO2OCalibrationFactors) process.SiStripCondObjBuilderFromDb.UseFED = True process.SiStripCondObjBuilderFromDb.UseFEC = True process.SiStripCondObjBuilderFromDb.UseAnalysis = _USEANALYSIS_ process.SiStripCondObjBuilderFromDb.SkippedDevices = cms.untracked.VPSet( _SKIPPED_) process.SiStripCondObjBuilderFromDb.WhitelistedDevices = cms.untracked.VPSet( _WHITELISTED_)
def get_db_credentials( db_service, authPath): (username, account, pwd) = auth.get_credentials( db_service[1], authPath ) return username,pwd
def get_db_credentials( db_service, authFile ): (username, account, pwd) = auth.get_credentials( authPathEnvVar, db_service[1], authFile ) return username,pwd
destinations=cms.untracked.vstring("cout")) process.maxEvents = cms.untracked.PSet(input=cms.untracked.int32(1)) process.source = cms.Source("EmptySource", numberEventsInRun=cms.untracked.uint32(1), firstRun=cms.untracked.uint32(1)) process.load("OnlineDB.SiStripConfigDb.SiStripConfigDb_cfi") process.SiStripConfigDb.UsingDb = True process.SiStripConfigDb.TNS_ADMIN = os.environ["TNS_ADMIN"] process.SiStripConfigDb.Partitions = cms.untracked.PSet(_CFGLINES_) if 'CONFDB' not in os.environ: import CondCore.Utilities.credentials as auth user, _, passwd = auth.get_credentials('cms_omds_tunnel/cms_trk_r') process.SiStripConfigDb.ConfDb = '{user}/{passwd}@{path}'.format( user=user, passwd=passwd, path='cms_omds_tunnel') process.load("OnlineDB.SiStripO2O.SiStripO2OCalibrationFactors_cfi") process.SiStripCondObjBuilderFromDb = cms.Service( "SiStripCondObjBuilderFromDb", process.SiStripO2OCalibrationFactors) process.SiStripCondObjBuilderFromDb.UseFED = True process.SiStripCondObjBuilderFromDb.UseFEC = True process.SiStripCondObjBuilderFromDb.UseAnalysis = _USEANALYSIS_ process.SiStripCondObjBuilderFromDb.SiStripDetInfoFile = cms.FileInPath( "CalibTracker/SiStripCommon/data/SiStripDetInfo.dat") process.SiStripCondObjBuilderFromDb.SkippedDevices = cms.untracked.VPSet( _SKIPPED_) process.SiStripCondObjBuilderFromDb.WhitelistedDevices = cms.untracked.VPSet( _WHITELISTED_)
process.source = cms.Source( "EmptySource", numberEventsInRun = cms.untracked.uint32(1), firstRun = cms.untracked.uint32(1) ) process.load("OnlineDB.SiStripConfigDb.SiStripConfigDb_cfi") process.SiStripConfigDb.UsingDb = True process.SiStripConfigDb.TNS_ADMIN = os.environ["TNS_ADMIN"] process.SiStripConfigDb.Partitions = cms.untracked.PSet( _CFGLINES_ ) if 'CONFDB' not in os.environ: import CondCore.Utilities.credentials as auth user, _, passwd = auth.get_credentials('COND_AUTH_PATH', 'cms_omds_tunnel/cms_trk_r') process.SiStripConfigDb.ConfDb = '{user}/{passwd}@{path}'.format(user=user, passwd=passwd, path='cms_omds_tunnel') process.SiStripDetInfoFileReader = cms.Service("SiStripDetInfoFileReader") process.load("OnlineDB.SiStripO2O.SiStripO2OCalibrationFactors_cfi") process.SiStripCondObjBuilderFromDb = cms.Service( "SiStripCondObjBuilderFromDb", process.SiStripO2OCalibrationFactors ) process.SiStripCondObjBuilderFromDb.UseFED = True process.SiStripCondObjBuilderFromDb.UseFEC = True process.SiStripCondObjBuilderFromDb.UseAnalysis = _USEANALYSIS_ process.SiStripCondObjBuilderFromDb.SkippedDevices = cms.untracked.VPSet( _SKIPPED_ ) process.SiStripCondObjBuilderFromDb.WhitelistedDevices = cms.untracked.VPSet(
destinations=cms.untracked.vstring("cout")) process.maxEvents = cms.untracked.PSet(input=cms.untracked.int32(1)) process.source = cms.Source("EmptySource", numberEventsInRun=cms.untracked.uint32(1), firstRun=cms.untracked.uint32(1)) process.load("OnlineDB.SiStripConfigDb.SiStripConfigDb_cfi") process.SiStripConfigDb.UsingDb = True process.SiStripConfigDb.TNS_ADMIN = os.environ["TNS_ADMIN"] process.SiStripConfigDb.Partitions = cms.untracked.PSet(_CFGLINES_) if 'CONFDB' not in os.environ: import CondCore.Utilities.credentials as auth user, _, passwd = auth.get_credentials('cmsonr_lb/cms_trk_r') process.SiStripConfigDb.ConfDb = '{user}/{passwd}@{path}'.format( user=user, passwd=passwd, path='cmsonr_lb') process.load("OnlineDB.SiStripO2O.SiStripO2OCalibrationFactors_cfi") process.SiStripCondObjBuilderFromDb = cms.Service( "SiStripCondObjBuilderFromDb", process.SiStripO2OCalibrationFactors) process.SiStripCondObjBuilderFromDb.UseFED = True process.SiStripCondObjBuilderFromDb.UseFEC = True process.SiStripCondObjBuilderFromDb.UseAnalysis = _USEANALYSIS_ process.SiStripCondObjBuilderFromDb.SiStripDetInfoFile = cms.FileInPath( "CalibTracker/SiStripCommon/data/SiStripDetInfo.dat") process.SiStripCondObjBuilderFromDb.SkippedDevices = cms.untracked.VPSet( _SKIPPED_) process.SiStripCondObjBuilderFromDb.WhitelistedDevices = cms.untracked.VPSet( _WHITELISTED_)