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()))