def findPod(datasets):
podnames = [];
edtnames = [];
edtsets = []
dads_db = stpydb.stpydb(os.environ['DADS_DB_SERVER'], os.environ['DADS_DB'])
opus_db = stpydb.stpydb(os.environ['OPUS_DB_SERVER'], os.environ['OPUS_DB'])
for dataset in datasets:
sql = edtSql % {"dataset": dataset[:8]}
result = {}
dads_db.query(sql)
hasEPC = False
if dads_db.execute(result):
edtname = result['osp_data_set_name']
edtsets.append(edtname)
hasEPC = True
if hasEPC:
continue
sql = podSql % {"dataset": dataset}
opus_db.query(sql)
while opus_db.execute(result):
podfile = result['podname']
podnames.append(podfile)
dads_db.close()
dads_db = stpydb.stpydb(os.environ['DADS_DB_SERVER'], os.environ['DADS_DB'])
for edtset in edtsets:
sql = edtSql2 % {"edtname": edtset}
result = {}
dads_db.query(sql);
if dads_db.execute(result):
edtfile = result['afi_data_set_name']
edtnames.append(edtfile)
return {"podfiles": podnames, "edtfiles": edtnames}
def readqueue():
queue_db = stpydb.stpydb(os.environ['SDPQ_DB_SERVER'], os.environ['SDPQ_DB'])
result = {}
dss = []
queue_db.query(queueSql)
while queue_db.execute(result):
ds = result['datasetName']
dss.append(ds)
return dss
def getExposures(datasets):
dads_db = stpydb.stpydb(os.environ['DADS_DB_SERVER'], os.environ['DADS_DB'])
expHash = {}
for dataset in datasets:
sql = exposureSql % {"asnId":dataset}
result = {}
dads_db.query(sql)
exps = []
while dads_db.execute(result):
exp=result['asm_member_name']
exps.append(exp)
if len(exps) == 0:
exps.append(dataset)
expHash[dataset] = exps
return expHash
