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()