from lib.db_manager import db_manager from lib.settings import * lm = db_manager(HOST, USERNAME, PASSWORD) lm.menu()
from lib.db_manager import db_manager
from lib.settings import *
__URL = "https://api.covid19api.com/summary"
db_object = db_manager(host, user, passwd, __URL, token)
covid_19_data = db_object.get_all_data()
db_object.save_all_data(covid_19_data)
class db_coron():
# ================ Заповнення бази =================
def zap(self, covid_19_data):
db_object.dell_corona()
for item in covid_19_data["Countries"]:
Country = item["Country"]
CountryCode = item["CountryCode"]
Slug = item["Slug"]
NewConfirmed = item["NewConfirmed"]
TotalConfirmed = item["TotalConfirmed"]
NewDeaths = item["NewDeaths"]
TotalDeaths = item["TotalDeaths"]
NewRecovered = item["NewRecovered"]
TotalRecovered = item["TotalRecovered"]
db_object.add_corona(Country, CountryCode, Slug, NewConfirmed,
TotalConfirmed, NewDeaths, TotalDeaths,
NewRecovered, TotalRecovered)
# ================ Вивід бази =================
def vyvid(self, vyb_Country, con, coc):
cor = db_object.vyvid_corona()
# return cor
from lib.db_manager import db_manager
from lib.settings import *
__URL = "https://api.covid19api.com/summary"
db_object = db_manager(host, user, passwd, database, __URL)
def menu():
exit = False
while not exit:
choice = int(input("1. Update covid19 database\n0.Exit \n===>"))
if choice == 1:
covid_19_data = db_object.get_all_data()
db_object.save_all_data(covid_19_data)
elif choice == 0:
exit = True
print("Bye...")
menu()
