Python get_credentials 예제들

예제 #1

 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

예제 #2

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)

예제 #3

파일: o2o_db_manager.py 프로젝트: JanFSchulte/cmssw

 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

예제 #4

 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

예제 #5

파일: conddb_version_mgr.py 프로젝트: KyeongPil-Lee/cmssw

 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

예제 #6

파일: o2o.py 프로젝트: mikeissah/cmssw

def get_db_credentials(db_service, authFile):
    (username, account, pwd) = auth.get_credentials(authPathEnvVar,
                                                    db_service[1], authFile)
    return username, pwd

예제 #7

파일: SiStripO2O_cfg_template.py 프로젝트: archiesharma/muonPhase2

    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_)

예제 #8

def get_db_credentials( db_service, authPath):
    (username, account, pwd) = auth.get_credentials( db_service[1], authPath )
    return username,pwd

예제 #9

파일: o2olib.py 프로젝트: attikis/cmssw

def get_db_credentials( db_service, authFile ):
    (username, account, pwd) = auth.get_credentials( authPathEnvVar, db_service[1], authFile )
    return username,pwd

예제 #10

파일: SiStripO2O_cfg_template.py 프로젝트: p2l1pfp/cmssw

    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_)

예제 #11

파일: SiStripO2O_cfg_template.py 프로젝트: KyeongPil-Lee/cmssw

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(

예제 #12

파일: SiStripO2O_cfg_template.py 프로젝트: giovanni-mocellin/cmssw

    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_)