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
