def putDataToMongod(self, tablename, usr, password):
pgt = dw.getPGT(username = usr, password = password)
query = {"pgtIou":pgt, "table": tablename, "clientId": 2000, "pageSize": 1, "clientName": "sdemo"}
qr = req.get(dw.DAS_URL + "/memberSearch", params = query)
if qr is None or "result_sets" not in qr or len(qr.get("result_sets")) == 0:
return None
qr = qr.json()
print qr["result_sets"]
client = pmo.MongoClient()
db = client["sbdb"]
db["ms"].insert_one(qr["result_sets"])
print "No. of records/documents in ms collection: %d" % df["ms"].count()
#"query": "{and: [{memberId.eq: " + memberId + "}]}",
"fields": "[CareAlert, memberId]",
"phiCSDate": "01-07-2010",
"phiCEDate": "06-30-2015"
}
qr = req.get(url=dw.DAS_URL + "/memberSearch", params=query, verify=False)
return qr.json()
if __name__ == "__main__":
req.packages.urllib3.disable_warnings()
if not os.path.exists(
"./data_folder/mem_care_prod.dat") or not os.path.exists(
"./data_folder/care_prod.dat"):
log.info("Fetching records from API")
PGT = dw.getPGT("*****@*****.**", "Snehasish@123")
print PGT
qr = getMembers(1, 1)
N_MEMBERS = qr["summary"]["totalCounts"]
print "Members: %d" % N_MEMBERS
qr = getCareAlerts(None, 1, 1)
N_GAPS = qr["summary"]["totalCounts"]
print "Gaps: %d" % N_GAPS
qr = getMembers(N_MEMBERS, PAGE)
qr_g = getCareAlerts(None, N_GAPS, PAGE)
qr_gaps = dict()
for key, val in qr_g["result_sets"].items():
qr_gaps[val["memberId"]] = val
del qr_g["result_sets"][key]
del qr_g
pickle.dump(qr, open("./data_folder/mem_care_prod.dat", "wb"))
"page": page,
"clientName": dw.CLIENT_NAME,
#"query": "{and: [{memberId.eq: " + memberId + "}]}",
"fields": "[CareAlert, memberId]",
"phiCSDate": "01-07-2010",
"phiCEDate": "06-30-2015"
}
qr = req.get(url = dw.DAS_URL + "/memberSearch", params = query, verify = False)
return qr.json()
if __name__ == "__main__":
req.packages.urllib3.disable_warnings()
if not os.path.exists("./data_folder/mem_care_prod.dat") or not os.path.exists("./data_folder/care_prod.dat"):
log.info("Fetching records from API")
PGT = dw.getPGT("*****@*****.**", "Snehasish@123")
print PGT
qr = getMembers(1,1)
N_MEMBERS = qr["summary"]["totalCounts"]
print "Members: %d" % N_MEMBERS
qr = getCareAlerts(None, 1, 1)
N_GAPS = qr["summary"]["totalCounts"]
print "Gaps: %d" % N_GAPS
qr = getMembers(N_MEMBERS, PAGE)
qr_g = getCareAlerts(None, N_GAPS, PAGE)
qr_gaps = dict()
for key, val in qr_g["result_sets"].items():
qr_gaps[val["memberId"]] = val
del qr_g["result_sets"][key]
del qr_g
pickle.dump(qr, open("./data_folder/mem_care_prod.dat", "wb"))