lab_app_afternoon.py

"""Musa 509 week 12 demo app"""
import io
import json
import logging

from flask import Flask, request, render_template, Response
from sqlalchemy import create_engine
from sqlalchemy.sql import text
import requests

# load credentials from a file
with open("pg-credentials.json", "r") as f_in:
    pg_creds = json.load(f_in)

# mapbox
with open("mapbox_token.json", "r") as mb_token:
    MAPBOX_TOKEN = json.load(mb_token)["token"]

app = Flask(__name__, template_folder="templates")

# load credentials from JSON file
HOST = pg_creds["HOST"]
USERNAME = pg_creds["USERNAME"]
PASSWORD = pg_creds["PASSWORD"]
DATABASE = pg_creds["DATABASE"]
PORT = pg_creds["PORT"]


def get_sql_engine():
    """Generates a SQLAlchemy engine"""
    return create_engine(f"postgresql://{USERNAME}:{PASSWORD}@{HOST}:{PORT}/{DATABASE}")


@app.route("/")
def index():
    """"""
    return Response(render_template("lab_input.html"), 200, mimetype="text/html")


def get_address(args):
    """Parses query strings"""
    text_address = args.get("address-text")
    dropdown_address = args.get("address-dropdown")
    if text_address != "":
        return text_address
    if text_address == "" and dropdown_address != "":
        return dropdown_address
    return False


@app.route("/whereami")
def whereami():
    """Landing page"""
    address = get_address(request.args)

    # Makes API call to Mapbox Geocoding API
    geocoding_call = f"https://api.mapbox.com/geocoding/v5/mapbox.places/{address}.json"
    resp = requests.get(geocoding_call, params={"access_token": MAPBOX_TOKEN})

    lng, lat = resp.json()['features'][0]['geometry']['coordinates']
    # return results
    return render_template(
        'whereami.html',
        lng=lng,
        lat=lat,
        address=address,
        html_map=render_template(
            'point_map.html',
            lat=lat,
            lng=lng,
            mapbox_token=MAPBOX_TOKEN
        )
    )


# 404 page example
@app.errorhandler(404)
def page_not_found(err):
    """404 page"""
    return f"404 ({err})"


if __name__ == "__main__":
    app.jinja_env.auto_reload = True
    app.config["TEMPLATES_AUTO_RELOAD"] = True
    app.run(debug=True, host="127.0.0.1", port=5002)