school summary for each city

school_summary.py

class SchoolData(BaseModel):
    total_schools: int
    percent_high_performing_schools: float
    percent_private: float
    percent_public: float
    percent_charter: float


async def get_school_summary(city: City):
    """Retrieve recommended cities for target city
    Fetch data from DB
    args:
    - city: The target city
    returns:
    - Dictionary that contains the requested data, which is converted
    by fastAPI to a json object.
    """

    city = validate_city(city)

    value = await select_all(city)

    full_data = SchoolData(city=city, **value)
    data = {**full_data.dict()}

    return data