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"))