def signup():
query = 'INSERT INTO signups(season_id, user_id) VALUES(?, ?)'
values = [Season.get_current_season_id(), current_user.get_id()]
try:
g.db.execute(query, values)
g.db.commit()
flash("Signed up")
except Exception as e:
print e # TODO what was I going to catch?
return redirect(request.referrer)
def usnignup():
query = 'DELETE FROM signups WHERE season_id = ? AND user_id = ?'
values = (Season.get_current_season_id(), current_user.get_id())
cur = g.db.execute(query, values)
if cur.rowcount:
g.db.commit()
flash("Signup removed")
else:
g.db.rollback()
flash("Failed to remove your signup")
return redirect(request.referrer)
def season_link():
query = """
SELECT id FROM seasons
ORDER BY id DESC
"""
cur = g.db.execute(query)
seasons = (x[0] for x in cur.fetchall())
links = []
for season_id in seasons:
links = links + [(url_for('season', id=season_id), 'season', 'Season %i'%season_id)]
return ('/', 'season', "Season %i" % Season.get_current_season_id())
def signups():
season_id = Season.get_current_season_id()
user_id = current_user.get_id()
signups = get_signups(season_id)
query = """
SELECT COUNT(*) as count FROM signups
WHERE season_id = ?
AND user_id = ?
"""
signedup = query_db(query, [season_id, user_id], True)['count']
return render_template('signups.html', signups=signups, signedup=signedup,
divisions=get_divisions(season_id))
def match_link():
if current_user.is_authenticated():
season_id = Season.get_current_season_id()
query = """
SELECT COUNT(*) as count FROM matches
LEFT JOIN match_players ON match_id = matches.id
WHERE season_id = ?
AND user_id = ?
"""
result = query_db(query, (season_id, current_user.get_id()), True)
if result['count']:
return ('matches/my', 'matches', "Matches (%i)" % result['count'])
return ('/matches', 'matches', "Matches")
def league():
return redirect(url_for('.signups', id=Season.get_current_season_id()))
