import datetime

from flask import abort

from backend.common.decorators import cached_public
from backend.common.helpers.season_helper import SeasonHelper
from backend.common.models.keys import TeamNumber, Year
from backend.common.models.team import Team
from backend.common.queries.event_query import TeamYearEventsQuery
from backend.common.queries.team_query import (
    TeamListQuery,
    TeamQuery,
)
from backend.web.profiled_render import render_template
from backend.web.renderers.team_renderer import TeamRenderer

MAX_TEAM_NUMBER_EXCLUSIVE = (
    9000  # Support between Team 0 and Team MAX_TEAM_NUMBER_EXCLUSIVE - 1
)
TEAMS_PER_PAGE = 1000
VALID_PAGES = range(
    1, (MAX_TEAM_NUMBER_EXCLUSIVE // TEAMS_PER_PAGE) + 1
)  # + 1 to make range inclusive


@cached_public
def team_detail(team_number: TeamNumber, year: Year, is_canonical: bool = False) -> str:
    team_key = f"frc{team_number}"
    if not Team.validate_key_name(team_key):
        abort(404)
    if year not in SeasonHelper.get_valid_years():
        abort(404)
    team_future = TeamQuery(team_key=f"frc{team_number}").fetch_async()
    team = team_future.get_result()
    if not team:
        abort(404)

    template_values = TeamRenderer.render_team_details(team, year, is_canonical)
    if template_values is None:
        abort(404)
    return render_template("team_details.html", template_values)


@cached_public
def team_history(team_number: TeamNumber, is_canonical: bool = False) -> str:
    team_key = f"frc{team_number}"
    if not Team.validate_key_name(team_key):
        abort(404)
    team_future = TeamQuery(team_key=f"frc{team_number}").fetch_async()
    team = team_future.get_result()
    if not team:
        abort(404)

    teams = Team.query().fetch()
    print(f"all teams: {teams}")

    template_values = TeamRenderer.render_team_history(team, is_canonical)
    return render_template("team_history.html", template_values)


@cached_public
def team_canonical(team_number: TeamNumber) -> str:
    team_future = TeamQuery(team_key=f"frc{team_number}").fetch_async()
    team = team_future.get_result()
    if not team:
        abort(404)

    current_year = datetime.datetime.now().year
    events_future = TeamYearEventsQuery(
        team_key=team.key_name, year=current_year
    ).fetch_async()
    events = events_future.get_result()
    if not events:
        return team_history(team_number, is_canonical=True)

    return team_detail(team_number, current_year, is_canonical=True)


@cached_public
def team_list(page: int) -> str:
    page_labels = []
    cur_page_label = ""
    if page not in VALID_PAGES:
        abort(404)
    for curPage in VALID_PAGES:
        if curPage == 1:
            label = "1-999"
        else:
            label = f"{(curPage - 1) * TEAMS_PER_PAGE}'s"
        page_labels.append(label)
        if curPage == page:
            cur_page_label = label

    teams_1 = TeamListQuery(page=2 * (page - 1)).fetch_async()
    teams_2 = TeamListQuery(page=2 * (page - 1) + 1).fetch_async()
    teams = teams_1.get_result() + teams_2.get_result()

    num_teams = len(teams)
    middle_value = num_teams // 2
    if num_teams % 2 != 0:
        middle_value += 1
    teams_a, teams_b = teams[:middle_value], teams[middle_value:]

    template_values = {
        "teams_a": teams_a,
        "teams_b": teams_b,
        "num_teams": num_teams,
        "page_labels": page_labels,
        "cur_page_label": cur_page_label,
        "current_page": page,
    }
    return render_template("team_list.html", template_values)

@@ -1717,75 +1717,8 @@
 4)%0A%0A
-    teams = Team.query().fetch()%0A    print(f%22all teams: %7Bteams%7D%22)%0A%0A
     

Remove inefficient query