def select_by_name(name): team = None sql = "SELECT * FROM teams WHERE name = %s" values = [name] result = run_sql(sql, values)[0] if result is not None: group_info = { "played": result['matches_played'], "won": result['won'], "drawn": result['drawn'], "lost": result['lost'], "for": result['goals_for'], "against": result['goals_against'], "difference": result['goal_difference'], "points": result['points'], "rank": result['group_rank'] } team = Team(result['name'], result['id']) team.group_info = group_info return team
def select_all(): teams = [] sql = "SELECT * FROM teams" results = run_sql(sql) for row in results: group_info = { "played": row['matches_played'], "won": row['won'], "drawn": row['drawn'], "lost": row['lost'], "for": row['goals_for'], "against": row['goals_against'], "difference": row['goal_difference'], "points": row['points'], "rank": row['group_rank'] } team = Team(row['name'], row['id']) team.group_info = group_info teams.append(team) return teams