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