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