def values():
values = query_db('select * from records')
return values
def get_cases_for_date(date):
values = query_db('select * from records where dateRep = ?',
[date[:2] + '/' + date[2:4] + '/' + date[4:8]])
print('select * from records where dateRep = ?',
date[:2] + '/' + date[2:4] + '/' + date[4:8])
return values
def get_country_cases_code(country_code):
values = query_db('select * from records where countryterritoryCode = ?',
[country_code])
print(country_code)
return values
def get_todays_cases():
values = query_db('select * from records where dateRep = ?',
[date.today().strftime("%d/%m/%Y")])
return values
def get_country_cases(country):
values = query_db(
'select * from records where countriesAndTerritories = ?', [country])
return values