def removeunTaggedPincode():
try:
session = Session()
pincodes, _ = getAllPincodeWithoutDistricts()
print("All pincodes without dist id ", pincodes['pincodes'])
for pin in pincodes['pincodes']:
print("Current Pin-> ", pin)
usersLst, _ = user_model.getUsersofPincode(pin.pincode)
print("total Users of this pincode-> ", usersLst['total'])
if usersLst['total'] < 1:
print("remove pincode ", pin.pincode,
" as no user is tagged to this pincode")
session.delete(pin)
except:
return "Failed to remove untagged Pincode", False
finally:
session.commit()
session.close()
def removeUnTaggedDistricts():
try:
session = Session()
alldist, _ = getAllDistricts()
print(alldist)
for dist in alldist['districts']:
print(dist.district_id)
allUsers, _ = user_model.getUserofDistID(dist.district_id)
print(allUsers)
if allUsers['total'] < 1:
print("Remove ", dist.district_id,
" as no user is tagged to this dist id")
session.delete(dist)
except:
return False
finally:
session.commit()
session.close()
def removeOutDatedSession():
try:
session = Session()
allSessions, _ = getAllSessions()
print("$" * 80)
print("Before deletion total ->", len(allSessions))
print("$" * 80)
currentDate_splitted = common_util.getDate().split("-")
cur_day, cur_mnth = int(currentDate_splitted[0]), int(
currentDate_splitted[1])
print("Current Date->", cur_day, "-", cur_mnth)
for s in allSessions:
date_splitted = s.date.split("-")
session_day, session_mnth = int(date_splitted[0]), int(
date_splitted[1])
print("session Date->", session_day, "-", session_mnth)
if cur_mnth > session_mnth:
# like cur date 1-06-2021 and session date 31-05-2021 then also remove
print("remove this session")
session.delete(s)
elif cur_mnth == session_mnth:
if cur_day - session_day >= 1:
print("Remove this Session ")
session.delete(s)
else:
print("Keep this session")
except Exception as e:
return "Failure to delete outdated Session", False
finally:
session.commit()
session.close()
lsts, _ = getAllSessions()
print("$" * 80)
print("After deletion total ->", len(lsts))
print("$" * 80)