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
)