def get_todays_games(): games_db = session.query(Game).filter(Game.date == datetime.date.today()).all() while games_db == []: browser.visit(url) content = browser.html soup = BeautifulSoup(content, 'lxml') games = soup.findAll('article', {'class':'scoreboard'}) for i in range(len(games)): away = games[i].find('tr', {'class': 'away'}).find('span', {'class': 'sb-team-short'}) home = games[i].find('tr', {'class': 'home'}).find('span', {'class': 'sb-team-short'}) time = games[i].find('span', {'class': 'time'}) print ("{}@{} {}".format(away.text, home.text, time.text)) new_game = Game(date=datetime.date.today(), time=time.text, away_team=away.text, home_team=home.text) session.add(new_game) session.commit() session.close() games_db = session.query(Game).filter(Game.date == datetime.date.today()).all() return games_db
def main(): url = 'https://aoe2.net/api/matches' data = requests.get(url, params={'game':'aoe2de', 'count':10, 'since':1620693540}) myArray = json.loads(data.text) games = [] for game in myArray: print(game) myGame = Game(game) print(myGame) games.append(myGame) return games