def get_religiousness_by_state():
query = get_query()
data = get_from_cache(query)
print("DB Query: " + query)
if data is None:
data = execute_query(query)
add_to_cache(query, data)
return data
def get_funding_aggregated_by_state(start_year, end_year, states):
query = get_query(start_year, end_year, states)
data = get_from_cache(query)
print("DB Query: " + query)
if data is None:
data = execute_query(query)
add_to_cache(query, data)
return collect_by_state(data)
def get_teen_pregnancy_by_ethnicity(year):
query = get_query(year)
data = get_from_cache(query)
print("DB Query: " + query)
if data is None:
data = execute_query(query)
add_to_cache(query, data)
return data
def get_teen_pregnancy_world_wide(start_year, end_year, countries):
query = get_query(start_year, end_year, countries)
data = get_from_cache(query)
print("DB Query: " + query)
if data is None:
data = execute_query(query)
add_to_cache(query, data)
return collect_by_country(data)
def get_funding_by_state(year):
query = get_query(year)
data = get_from_cache(query)
print("DB Query: " + query)
if data is None:
data = execute_query(query)
add_to_cache(query, data)
for d in data:
if d['total'] != 0:
d['abstinence rate'] = round(d['abstinence only'] / d['total'], 3)
d['comprehensive rate'] = round(d['comprehensive sex education'] / d['total'], 3)
else:
d['abstinence rate'] = 0
d['comprehensive rate'] = 0
return data