def team_visualize():
if g.user_type == "instructor":
teams = []
teams_sql = []
db = DatabaseConnection()
with db.get_connection().cursor() as cursor:
cursor.execute("SELECT * FROM tms.team")
teams_sql = cursor.fetchall()
db.get_connection().close()
for team_sql in teams_sql:
team = Team(team_sql[1])
team.team_number = team_sql[0]
team.set_max_team_size(team_sql[2])
team.set_min_team_size(team_sql[3])
team.num_team_members = team_sql[4]
teams.append(team)
return render_template("visualize-teams.html", teams=teams)
return redirect(url_for("dashboard"))
