def games_manage(): game_list=Games.select() if session['umpire']: visible_games = [] for game in game_list: if game.Umpires: if session['username'] in game.Umpires: visible_games.append(game) if session['commissioner']: visible_games = game_list return render_template( 'manage/games_manage.html', game_list=visible_games )
def game_creation(form): season = form.season.data session = form.session.data if len(str(form.session.data)) == 1: session = '0' + str(form.session.data) prefix = str(season) + str(session) max_no = Games.select(fn.MAX(Games.Game_Number)).where(Games.Game_Number ** (prefix+"%")).tuples()[0][0] if max_no == None: game_number = prefix + '01' else: game_number = str(int(max_no)+1) game_id = form.away.data + form.home.data + str(form.session.data) game_dict = { 'Game_Number':game_number, 'Game_ID':game_id, 'Season':season, 'Session':session, 'Away':form.away.data, 'Home':form.home.data, 'Umpires':['dyslexda']} #hardcoded, need to fix with db.atomic(): Games.create(**game_dict) return(game_number)
def games(): game_list = Games.select() return render_template( 'games.html', game_list=game_list )