def handle_get(http_server, database_manager, ip, account, api_key): query_params = http_server.get_query_parameters() if "code" not in query_params: raise ApiParamNoCountryCodeProvidedError raw_country_code_string = query_params["code"] country_code_string = raw_country_code_string.upper() if country_code_string is None: raise ApiParamInvalidCountryCodeError match = re.match(r'^[A-Za-z]{2}$', country_code_string) if match is None: raise ApiParamInvalidCountryCodeError country = Country.fetch_by_code(database_manager, country_code_string) if country is None: raise ApiParamInvalidCountryCodeError country_name = country.name if country.code == "US": country_name = "United States" county_total = GenderCounty.fetch_by_country_name(database_manager, country_name.upper()) subscription_plan = SubscriptionPlan.fetch_by_id( database_manager, account.subscription_plan_id) for header in eligible_headers: eligible_headers[header] = get_is_eligible(subscription_plan, header) zip_totals = {} for header, is_eligible in eligible_headers.items(): if is_eligible is True: zip_totals[header] = 0 total = getattr(county_total, header) if total is None: total = 0 zip_totals[header] = (round(total)) years = [str(year) for year in range(2000, 2010)] raw_output_data = OrderedDict({}) totals = {} for year in years: output_year = {} for header, value in zip_totals.items(): if year in header: output_year[header[:-len(year) - 1]] = value if len(output_year) > 0: raw_output_data[year] = output_year if year not in totals: if year in raw_output_data: totals[year] = sum( [v for k, v in raw_output_data[year].items()]) # get percentages output_data = OrderedDict({}) notes = [] for year in raw_output_data: output_data[year] = {"breakdown": {}} for key, value in raw_output_data[year].items(): output_data[year]["breakdown"][key] = 100 * value / totals[year] if get_is_eligible(subscription_plan, "totals") is True: output_data[year]['total'] = totals[year] else: notes.append("Upgrade to a paid plan for totals") if len(output_data) == 1: notes.append("Upgrade plan for historical data") notes = list(set(notes)) output = OrderedDict({ "gender_breakdown": output_data, "units": "percent", "location": { "country": { "name": "United States of America", "code": "US", } }, "notes": notes }) http_server.print_headers() http_server.print_json(output)
def handle_get(http_server, database_manager, ip, account, api_key): query_params = http_server.get_query_parameters() if "city" not in query_params: raise ApiParamNoCityProvidedError if "state" not in query_params: raise ApiParamNoStateCodeProvidedError raw_city_string = query_params["city"] raw_state_code_string = query_params["state"] city_string = raw_city_string.title() state_code_string = raw_state_code_string.upper() match = re.match(r'^[A-Z]{2}$', state_code_string) if match is None: raise ApiParamInvalidStateCodeError zip_conditions = [ { 'column': 'city', 'equivalence': '=', 'value': city_string.upper() }, { 'column': 'state_code', 'equivalence': '=', 'value': state_code_string } ] zip_codes = database_manager.fetch_by( ZipCode(database_manager), zip_conditions ) if len(zip_codes) == 0: raise ApiParamInvalidStateCodeError state = UsState.fetch_by_code(database_manager, state_code_string) zip_code_counties_conditions = [{ 'column': 'zip', 'equivalence': ' IN ', 'value': [z.zip_code for z in zip_codes] }] county_percentages = database_manager.fetch_by( county2zipCode(database_manager), zip_code_counties_conditions ) county_fips = [] if len(county_percentages) > 0: county_fips = [c.get_state_county_fips() for c in county_percentages] county_fips = list(set(county_fips)) subscription_plan = SubscriptionPlan.fetch_by_id( database_manager, account.subscription_plan_id ) for header in eligible_headers: eligible_headers[header] = get_is_eligible( subscription_plan, header ) zip_totals = {} if len(county_fips) > 0: voting_county_conditions = [{ "column": "county_code", "equivalence": "IN", "value": county_fips }] county_totals = database_manager.fetch_by( VotesCounty(database_manager), voting_county_conditions ) else: raise ApiParamInvalidStateCodeError for header, is_eligible in eligible_headers.items(): if is_eligible is True: zip_totals[header] = 0 for county_total in county_totals: for county_percentage in county_percentages: if county_percentage.get_state_county_fips() == \ county_total.county_code: total = getattr( county_total, header ) if total is None: total = 0 zip_totals[header] += ( round( total * county_percentage.zip_population_percent ) ) break years = [str(x) for x in range(1980, 2010)] raw_output_data = OrderedDict({}) totals = {} for year in years: output_year = {} for header, value in zip_totals.items(): if year in header: output_year[header[:-len(year)-1]] = value if len(output_year) > 0: raw_output_data[year] = output_year if year not in totals: if year in raw_output_data: totals[year] = raw_output_data[year]["total"] # get percentages output_data = OrderedDict({}) notes = [] for year in raw_output_data: output_data[year] = {"breakdown":{}} for key, value in raw_output_data[year].items(): if key != "total": output_data[year]["breakdown"][key] = 100 * value / totals[year] if get_is_eligible(subscription_plan, "totals") is True: output_data[year]['total_votes'] = totals[year] else: notes.append("Upgrade to a paid plan for totals") if len(output_data) == 1: notes.append("Upgrade plan for historical data") notes = list(set(notes)) state_name = "" state_code = "" if state.code is not None: state_code = state.code if state.name is not None: state_name = state.name output = OrderedDict({ "voting_ranges": output_data, "units": "percent", "location": { "city": { "name": city_string, }, "state": { "name": state_name, "code": state_code.upper(), "api_endpoint": '/v1/race/state?code={}'.format(state_code.upper()), }, "country": { "name": "United States of America", "code": "US", "api_endpoint": '/v1/race/country?code=US', } }, "notes": notes }) http_server.print_headers() http_server.print_json(output)
def handle_get(http_server, database_manager, ip, account, api_key): query_params = http_server.get_query_parameters() if "zip" not in query_params: raise ApiParamNoZipCodeProvidedError raw_zip_code_string = query_params["zip"] zip_code_string = raw_zip_code_string if "-" in raw_zip_code_string: dash_position = raw_zip_code_string.find("-") zip_code_string = raw_zip_code_string[0:dash_position] match = re.match(r'^\d+$', zip_code_string) if match is None: raise ApiParamInvalidZipCodeError zip_code_int = int(zip_code_string) zip_code = ZipCode.fetch_by_zip_int(database_manager, zip_code_int, is_decommisioned=False) if zip_code is None: raise ApiParamInvalidZipCodeError state = UsState.fetch_by_id(database_manager, zip_code.state_id) city_name = zip_code.city if zip_code.city is not None: city_name = zip_code.city.title() county_percentages = zip_code.get_county_percentages() county_fips = [] if len(county_percentages) > 0: county_fips = [c.get_state_county_fips() for c in county_percentages] county_fips = list(set(county_fips)) subscription_plan = SubscriptionPlan.fetch_by_id( database_manager, account.subscription_plan_id) for header in eligible_headers: eligible_headers[header] = get_is_eligible(subscription_plan, header) zip_totals = {} if len(county_fips) > 0: population_county_conditions = [{ "column": "county_code", "equivalence": "IN", "value": county_fips }] county_totals = database_manager.fetch_by( PopulationCounty(database_manager), population_county_conditions) else: raise ApiParamInvalidZipCodeError for header, is_eligible in eligible_headers.items(): if is_eligible is True: zip_totals[header] = 0 for county_total in county_totals: for county_percentage in county_percentages: if county_percentage.get_state_county_fips() == \ county_total.county_code: total = getattr(county_total, header) if total is None: total = 0 zip_totals[header] += (round( total * county_percentage.zip_population_percent)) break years = [str(x) for x in range(1930, 2011)] raw_output_data = OrderedDict({}) totals = {} for year in years: output_year = {} for header, value in zip_totals.items(): if year in header: output_year[header[:-len(year) - 1]] = value if len(output_year) > 0: raw_output_data[year] = output_year # get percentages output_data = OrderedDict({}) notes = [] for year in raw_output_data: output_data[year] = None for key, value in raw_output_data[year].items(): output_data[year] = value if len(output_data) == 1: notes.append("Upgrade plan for historical data") notes = list(set(notes)) state_name = "" state_code = "" if state.code is not None: state_code = state.code if state.name is not None: state_name = state.name output = OrderedDict({ "population_estimates": output_data, "units": "people", "location": { "city": { "name": city_name, "api_endpoint": '/v1/population/city?city={}&state={}'.format( requote_uri(city_name), state_code.upper()), }, "state": { "name": state_name, "code": state_code.upper(), "api_endpoint": '/v1/population/state?code={}'.format(state_code.upper()), }, "country": { "name": "United States of America", "code": "US", "api_endpoint": '/v1/population/country?code=US', } }, "notes": notes }) http_server.print_headers() http_server.print_json(output)
def handle_get(http_server, database_manager, ip, account, api_key): query_params = http_server.get_query_parameters() if "code" not in query_params: raise ApiParamNoStateCodeProvidedError raw_state_code_string = query_params["code"] state_code_string = raw_state_code_string.upper() match = re.match(r'^[A-Za-z]{2}$', state_code_string) if match is None: raise ApiParamInvalidStateCodeError state = UsState.fetch_by_code(database_manager, state_code_string) if state is None: raise ApiParamInvalidStateCodeError county_total = AncestryCounty.fetch_by_state_name(database_manager, state.name.upper()) subscription_plan = SubscriptionPlan.fetch_by_id( database_manager, account.subscription_plan_id) for header in eligible_headers: eligible_headers[header] = get_is_eligible(subscription_plan, header) zip_totals = {} for header, is_eligible in eligible_headers.items(): if is_eligible is True: zip_totals[header] = 0 total = getattr(county_total, header) if total is None: total = 0 zip_totals[header] = (round(total)) years = [str(x) for x in range(1980, 2010)] raw_output_data = OrderedDict({}) totals = {} for year in years: output_year = {} for header, value in zip_totals.items(): if year in header: output_year[header[:-len(year) - 1]] = value if len(output_year) > 0: raw_output_data[year] = output_year if year not in totals: totals[year] = 0 else: totals[year] += value # get percentages output_data = OrderedDict({}) notes = [] for year in raw_output_data: output_data[year] = {"breakdown": {}} for key, value in raw_output_data[year].items(): output_data[year]["breakdown"][key] = value / totals[year] if get_is_eligible(subscription_plan, "totals") is True: output_data[year]['total'] = totals[year] else: notes.append("Upgrade to a paid plan for totals") if len(output_data) == 1: notes.append("Upgrade plan for historical data") notes = list(set(notes)) output = { "ancestry_ranges": output_data, "units": "percent", "location": { "state": { "name": state.name, "code": state.code.upper(), }, "country": { "name": "United States of America", "code": "US", "api_endpoint": '/v1/ancestry/country?code=US', } }, "notes": notes } http_server.print_headers() http_server.print_json(output)
def handle_get(http_server, database_manager, session, account): keys = { "current_page": "register" } template = fetch_template("account/confirm.jinja.htm") query_parameters = http_server.get_query_parameters() if "code" not in query_parameters: keys["no_code_provided"] = True output = template.render(keys) # http_server.set_status(400) http_server.print_headers() print(output) else: code = query_parameters["code"] registration = AccountRegistration.fetch_by_confirmation_code( database_manager, code ) if registration is None: keys["invalid_code"] = True output = template.render(keys) # http_server.set_status(400) http_server.print_headers() print(output) else: existing_account = Account.fetch_by_from_registration_id( database_manager, registration.id ) if existing_account is not None: keys["already_confirmed"] = True output = template.render(keys) # http_server.set_status(400) http_server.print_headers() print(output) else: account = Account.from_registration(registration) account.insert() if account.id is None or account.id < 1: account = Account.fetch_by_from_registration_id( database_manager, registration.id ) subscription = SubscriptionPlan.fetch_by_id( database_manager, account.subscription_plan_id ) if subscription is None: subscription = SubscriptionPlan.fetch_by_name( database_manager, "free" ) new_api_key = ApiKey(database_manager) new_api_key.generate_key() new_api_key.generate_secret() new_api_key.account_id = account.id new_api_key.update_plan(subscription) new_api_key.insert() # log in ip_string = http_server.get_remote_address() session = Session(database_manager) session.set_expiration_days_from_now( settings["confirm_page"]["session_timeout_days"] ) session_slug = session.generate_slug() session.account_id = account.id session.ip_address = ip_string session.slug = session_slug session.insert() http_server.set_cookie("session_id", session_slug) output = template.render(keys) http_server.print_headers() print(output)
def handle_get(http_server, database_manager, ip, account, api_key): query_params = http_server.get_query_parameters() if "code" not in query_params: raise ApiParamNoStateCodeProvidedError raw_state_code_string = query_params["code"] state_code_string = raw_state_code_string.upper() match = re.match(r'^[A-Za-z]{2}$', state_code_string) if match is None: raise ApiParamInvalidStateCodeError state = UsState.fetch_by_code(database_manager, state_code_string) if state is None: raise ApiParamInvalidStateCodeError county_total = EducationCounty.fetch_by_state_name(database_manager, state.name.upper()) subscription_plan = SubscriptionPlan.fetch_by_id( database_manager, account.subscription_plan_id) for header in eligible_headers: eligible_headers[header] = get_is_eligible(subscription_plan, header) zip_totals = {} for header, is_eligible in eligible_headers.items(): if is_eligible is True: zip_totals[header] = 0 total = getattr(county_total, header) if total is None: total = 0 zip_totals[header] = (round(total)) years = ["1980", "1990", "2000", "2009"] raw_output_data = OrderedDict({}) totals = {} for year in years: output_year = {} for header, value in zip_totals.items(): if "num_adults" not in header: if year in header: ending = year end = len(ending) + 1 if "_2005_" in header: ending = "2005_{}".format(year) end = len(ending) + 1 output_year[header[:-end]] = 100 * value / zip_totals[ "num_adults_{}".format(ending)] if len(output_year) > 0: raw_output_data[year] = output_year if year not in totals: if year in raw_output_data: ending = year if year == "2009": ending = "2005_2009" totals[year] = zip_totals["num_adults_{}".format(ending)] # get percentages output_data = OrderedDict({}) notes = [] for year in raw_output_data: output_data[year] = {"breakdown": {}} for key, value in raw_output_data[year].items(): output_data[year]["breakdown"][key] = value if get_is_eligible(subscription_plan, "totals") is True: output_data[year]['total_adults'] = totals[year] else: notes.append("Upgrade to a paid plan for totals") notes = list(set(notes)) state_name = "" state_code = "" if state.code is not None: state_code = state.code if state.name is not None: state_name = state.name output = { "education_ranges": output_data, "location": { "state": { "name": state.name, "code": state.code.upper(), }, "country": { "name": "United States of America", "code": "US", "api_endpoint": '/v1/education/country?code=US', } }, "notes": notes } http_server.print_headers() http_server.print_json(output)
def handle_get(http_server, database_manager, ip, account, api_key): query_params = http_server.get_query_parameters() if "zip" not in query_params: raise ApiParamNoZipCodeProvidedError raw_zip_code_string = query_params["zip"] zip_code_string = raw_zip_code_string if "-" in raw_zip_code_string: dash_position = raw_zip_code_string.find("-") zip_code_string = raw_zip_code_string[0:dash_position] match = re.match(r'^\d+$', zip_code_string) if match is None: raise ApiParamInvalidZipCodeError zip_code_int = int(zip_code_string) zip_code = ZipCode.fetch_by_zip_int( database_manager, zip_code_int, is_decommisioned=False ) if zip_code is None: raise ApiParamInvalidZipCodeError state = UsState.fetch_by_id(database_manager, zip_code.state_id) city_name = zip_code.city if zip_code.city is not None: city_name = zip_code.city.title() county_percentages = zip_code.get_county_percentages() county_fips = [] if len(county_percentages) > 0: county_fips = [c.get_state_county_fips() for c in county_percentages] county_fips = list(set(county_fips)) subscription_plan = SubscriptionPlan.fetch_by_id( database_manager, account.subscription_plan_id ) for header in eligible_headers: eligible_headers[header] = get_is_eligible( subscription_plan, header ) zip_totals = {} if len(county_fips) > 0: education_county_conditions = [{ "column": "county_code", "equivalence": "IN", "value": county_fips }] county_totals = database_manager.fetch_by( EducationCounty(database_manager), education_county_conditions ) else: raise ApiParamInvalidZipCodeError for header, is_eligible in eligible_headers.items(): if is_eligible is True: zip_totals[header] = 0 for county_total in county_totals: for county_percentage in county_percentages: if county_percentage.get_state_county_fips() == \ county_total.county_code: total = getattr( county_total, header ) if total is None: total = 0 zip_totals[header] = ( round( total * county_percentage.zip_population_percent ) ) break years = ["1980", "1990", "2000", "2009"] raw_output_data = OrderedDict({}) totals = {} for year in years: output_year = {} for header, value in zip_totals.items(): if "num_adults" not in header: if year in header: ending = year end = len(ending) + 1 if "_2005_" in header: ending = "2005_{}".format(year) end = len(ending) + 1 output_year[header[:-end]] = 100 * value / zip_totals[ "num_adults_{}".format(ending) ] if len(output_year) > 0: raw_output_data[year] = output_year if year not in totals: if year in raw_output_data: ending = year if year == "2009": ending = "2005_2009" totals[year] = zip_totals["num_adults_{}".format(ending)] # get percentages output_data = OrderedDict({}) notes = [] for year in raw_output_data: output_data[year] = {"breakdown":{}} for key, value in raw_output_data[year].items(): output_data[year]["breakdown"][key] = value if get_is_eligible(subscription_plan, "totals") is True: output_data[year]['total_adults'] = totals[year] else: notes.append("Upgrade to a paid plan for totals") if len(output_data) == 1: notes.append("Upgrade plan for historical data") notes = list(set(notes)) state_name = "" state_code = "" if state.code is not None: state_code = state.code if state.name is not None: state_name = state.name output = OrderedDict({ "education_ranges": output_data, "city": { "name": city_name, "api_endpoint": '/v1/education/city?city={}&state={}'.format( requote_uri(city_name), state_code.upper() ), }, "state": { "name": state_name, "code": state_code.upper(), "api_endpoint": '/v1/education/state?code={}'.format(state_code.upper()), }, "country": { "name": "United States of America", "code": "US", "api_endpoint": '/v1/education/country?code=US', } }) http_server.print_headers() http_server.print_json(output)