def store_team(data):
team = Team(id=data['key'])
team.team_number = data['team_number']
team.nickname = data['nickname']
team.name = data['name']
team.website = data['website']
team.rookie_year = data['rookie_year']
team.motto = data['motto']
team.city = data['city']
team.state_prov = data['state_prov']
team.country = data['country']
TeamManipulator.createOrUpdate(team)
return team
def store_team(data):
team = Team(id=data['key'])
team.team_number = data['team_number']
team.nickname = data['nickname']
team.name = data['name']
team.website = data['website']
team.rookie_year = data['rookie_year']
team.motto = data['motto']
team.city = data['city']
team.state_prov = data['state_prov']
team.country = data['country']
TeamManipulator.createOrUpdate(team)
return team
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"))
