Server-Side Scripting/Internet Data/Python (FastAPI)

routers/lesson8.py

# This program reads JSON data from Wikidata with countries
# and Celsius temperatures. It displays the data in Celsius
# and Fahrenheit sorted in decending order by temperature.
#
# References:
#   https://www.mathsisfun.com/temperature-conversion.html
#   https://en.wikibooks.org/wiki/Python_Programming
#   https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service

from fastapi import APIRouter, Request
from fastapi.responses import HTMLResponse
from fastapi.templating import Jinja2Templates

import json
import urllib.parse
import urllib.request

router = APIRouter(prefix="/lesson8")
templates = Jinja2Templates(directory="templates")

URL = "https://query.wikidata.org/sparql"
QUERY = """
SELECT DISTINCT ?Country ?MaximumTemperature WHERE {
  ?countryItem wdt:P31 wd:Q6256;
    p:P6591 ?maximumTemperatureRecord.
  ?maximumTemperatureRecord psv:P6591 ?maximumTemperatureValue.
  ?maximumTemperatureValue wikibase:quantityAmount ?maximumTemperatureQuantity;
    wikibase:quantityUnit ?temperatureUnit.
  {
    ?countryItem rdfs:label ?Country.
    FILTER((LANG(?Country)) = "en")
  }
  {
    ?temperatureUnit wdt:P5061 ?unitSymbol.
    FILTER((LANG(?unitSymbol)) = "en")
    FILTER(CONTAINS(?unitSymbol, "C"))
  }
  BIND(CONCAT(STR(?maximumTemperatureQuantity), " ", ?unitSymbol) AS ?MaximumTemperature)
}
ORDER BY (?Country)
"""

@router.get("/", response_class=HTMLResponse)
async def get_lesson8(request: Request):
    try:
        result = await get_data(URL, QUERY)
    except Exception as exception:
        result = exception

    return templates.TemplateResponse(
        "lesson8.html", 
        {   
            "request": request,
            "table": result
        }
    )

async def get_data(url, query):
    try:
        data = get_raw_data(url, query)
        records = get_records(data)
        records.sort(key=lambda x:x["celsius"], reverse=True)
        result = format_table(records)
        return result
    except Exception as exception:
        return str(exception)
        
def get_raw_data(url, query):
    url += "?query=" + urllib.parse.quote(query)
    url += "&format=json"
    data = urllib.request.urlopen(url).read().decode()
    data = json.loads(data)
    return data

def get_records(data):
    records = []
    for dictionary in data["results"]["bindings"]:
        record = get_record(dictionary)
        records.append(record)
    records.sort(key=lambda x:x["celsius"], reverse=True)
    return records 

def get_record(dictionary):
    country = dictionary["Country"]["value"]
    celsius = dictionary["MaximumTemperature"]["value"]

    index = celsius.find(" °C")
    if index < 0:
        raise ValueError("Invalid data format")

    try:
        celsius = float(celsius[0:index])
        fahrenheit = celsius * 9 / 5 + 32
    except:
        raise ValueError("Invalid temperature data")

    record = {}
    record["country"] = country
    record["celsius"] = celsius
    record["fahrenheit"] = fahrenheit
    return record

def format_table(records):
    result = "<table><tr><th>Country</th>"
    result += "<th>Celsius</th>"
    result += "<th>Fahrenheit</th></tr>"

    for record in records:
        result += f"<tr><td>{record['country']}</td>" 
        result += f"<td>{record['celsius']:.1f}° C</td>"
        result += f"<td>{record['fahrenheit']:.1f}° F</td></tr>"

    result += "</table>"
    return result

templates/lesson8.html

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <title>Lesson 8</title>
    <link rel="stylesheet" href="{{url_for('static', path='/styles.css')}}">
    <style>
        p {
            min-height: 1em;
        }
    </style>
</head>

<body>
    <h1>Temperature Conversion</h1>
    <h2>Wikidata</h2>
    {{table|safe}}
</body>

</html>

Try It

See Server-Side Scripting/Routes and Templates/Python (FastAPI) to create a test environment.

routers/lesson8.py

templates/lesson8.html

Try It

See Also