def getSchedule(sport):
games_list = []
connection, cursor = connect()
cursor.execute("SELECT * FROM schedule WHERE sport = ?;", (sport,))
for row in cursor:
game = ScheduledGame()
game.inflate(row)
games_list.append(game)
return games_list
def refresh_data(sport=None):
if sport:
database.clear('roster', sport)
url = urllib.request.urlopen(URL['ATHLETICS_URL']
+ URL['SCHEDULE_PATH'] + sport)
content = url.read().decode('utf8')
url.close()
soup = BeautifulSoup(content)
schedule = soup.find_all("div", "schedule_game")
scheduled_games = []
for game in schedule:
scheduled_game = ScheduledGame()
if (game.find("div", "schedule_game_opponent_name")):
scheduled_game.setSport(sport)
if game.find("div", "schedule_game_opponent_name").a.span:
scheduled_game.setTeam(game.find("div", "schedule_game_opponent_name").a.span.string)
else:
scheduled_game.setTeam(game.find("div", "schedule_game_opponent_name").get_text())
scheduled_game.setDate(game.find("div", "schedule_game_opponent_date").string)
scheduled_game.setTime(game.find("div", "schedule_game_opponent_time").string)
scheduled_game.setLocation(game.find("div", "schedule_game_middle").get_text())
scheduled_game.setTeam(game.find("div", "schedule_game_opponent_name").get_text())
scheduled_game.setImage(game.find("div", "schedule_game_opponent_logo").img['src'])
if (game.find("div", "schedule_game_results")):
scheduled_game.setScore(game.find("div", "schedule_game_results").contents[1].get_text())
database.save(scheduled_game)