def apiToDB(self, apiMesuer):
mesureDB = dict()
if ("_id" in apiMesuer):
mesureDB["_id"] = apiMesuer["_id"]
misc.toDateTime(apiMesuer, "date")
mesureDB["date"] = apiMesuer["date"]
mesureDB["adm"] = apiMesuer["adm"]
mesureDB["source"] = source.getSource({"url": apiMesuer["source"]})
mesureDB["actions"] = list()
if (apiMesuer["border_control"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "border_control"}))
if (apiMesuer["home_office"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "home_office"}))
if (apiMesuer["closure_leisureandbars"]
in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "closure_leisureandbars"}))
if (apiMesuer["lockdown"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(action.getAction({"name": "lockdown"}))
if (apiMesuer["schools_closed"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "schools_closed"}))
if (apiMesuer["traveller_quarantine"]
in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "traveller_quarantine"}))
if (apiMesuer["primary_residence"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "primary_residence"}))
if (apiMesuer["test_limitations"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "test_limitations"}))
return mesureDB
def apiToDB(self, apiMesuer):
mesureDB = dict()
dbId = apiMesuer.get("_id", None)
if (not (dbId is None)):
mesureDB["_id"] = dbId
if ("date" in apiMesuer):
if not isinstance(apiMesuer["date"], datetime.datetime):
try:
apiMesuer["date"] = datetime.datetime.fromtimestamp(
int(apiMesuer["date"]))
except:
try:
apiMesuer["date"] = datetime.datetime.strptime(
apiMesuer["date"], '%Y-%m-%d')
except:
pass
#was not a timestamp
pass
mesureDB["date"] = apiMesuer["date"]
mesureDB["adm"] = apiMesuer["adm"]
mesureDB["source"] = source.getSource({"url": apiMesuer["source"]})
mesureDB["actions"] = list()
if (apiMesuer["border_control"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "border_control"}))
if (apiMesuer["home_office"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "home_office"}))
if (apiMesuer["closure_leisureandbars"]
in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "closure_leisureandbars"}))
if (apiMesuer["lockdown"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(action.getAction({"name": "lockdown"}))
if (apiMesuer["schools_closed"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "schools_closed"}))
if (apiMesuer["traveller_quarantine"]
in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "traveller_quarantine"}))
if (apiMesuer["primary_residence"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "primary_residence"}))
if (apiMesuer["test_limitations"] in ["TRUE", "true", "True", True]):
mesureDB["actions"].append(
action.getAction({"name": "test_limitations"}))
return mesureDB
def apiToDB(self, cases):
if ("source" in cases):
cases["source"] = source.getSource({"name": cases["source"]})
misc.toDateTime(cases, "date")
return cases
from DBConnection import DBConnection
import source
import pycountry
import datetime
connection = DBConnection.getConnection()
dataSource = source.getSource({"name": "UN PopulationByAgeSex_OtherVariants"})
rawDB = connection["raw"]
statistic = DBConnection.getStatisticDB()
popDatas = rawDB["unitedNation_PopulationByAgeSex_OtherVariants"].find({})
popsDB = list()
for pops in popDatas:
popDb = dict()
popDb["LocID"] = pops["LocID"]
popDb["adm"] = ["", "", ""]
try:
popDb["adm"][0] = pycountry.countries.get(
name=pops["Location"]).alpha_2
except:
popDb["adm"][0] = pops["Location"]
popDb["VarID"] = pops["VarID"]
popDb["Variant"] = pops["Variant"]
try:
popDb["Time"] = datetime.datetime.strptime(pops["Time"], '%Y')
except:
popDb["Time"] = "NaN"
try:
popDb["MidPeriod"] = float(pops["MidPeriod"])
except:
popDb["MidPeriod"] = "NaN"
try:
def apiToDB(self, cases):
if ("source" in cases):
cases["source"] = source.getSource({"name": cases["source"]})
return cases