def register(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] nickname = request.form['nickname'] firstname = request.form['firstname'] surname = request.form['surname'] dob = request.form['dob'] gender = request.form['gender'] email = request.form['email'] phone = request.form['phone'] db = get_db() error = None if not username: error = 'Username is required.' elif not password: error = 'Password is required.' elif db.execute('SELECT id FROM players WHERE username = ?', (username, )).fetchone() is not None: error = 'Player {} is already registered.'.format(username) if error is None: db.execute( '''INSERT INTO players (username, password, nickname, firstname, surname, dob, gender, email, phone) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)''', (username, generate_password_hash(password), nickname, firstname, surname, dob, gender, email, phone)) db.commit() return redirect(url_for('auth.login')) flash(error) return render_template('auth/register.html')
def index(): db = get_db() team_players = db.execute('SELECT *' ' FROM all_team_players').fetchall() teams = db.execute('SELECT *' ' FROM all_teams').fetchall() return render_template('teams/index.html', teams=teams, team_players=team_players)
def load_logged_in_user(): user_id = session.get('user_id') if user_id is None: g.user = None else: g.user = get_db().execute('SELECT * FROM players WHERE id = ?', (user_id, )).fetchone()
def my_teams(): db = get_db() team_players = db.execute('SELECT *' ' FROM all_team_players' ' WHERE team_id in (' ' SELECT team_id' ' FROM plays_on' ' WHERE player_id = {})'.format( g.user['id'])).fetchall() teams = db.execute( 'SELECT *' ' FROM all_teams INNER JOIN plays_on on all_teams.id = plays_on.team_id' ' WHERE player_id = {}'.format(g.user['id'])).fetchall() return render_template('teams/index.html', teams=teams, team_players=team_players)
def login(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] db = get_db() error = None user = db.execute('SELECT * FROM players WHERE username = ?', (username, )).fetchone() if user is None: error = 'Incorrect username.' elif not check_password_hash(user['password'], password): error = 'Incorrect password.' if error is None: session.clear() session['user_id'] = user['id'] return redirect(url_for('index')) flash(error) return render_template('auth/login.html')
def register(): if request.method == 'POST': teamname = request.form['teamname'] night = request.form['night'] grade = request.form['grade'] division = request.form['division'] db = get_db() error = None if not teamname: error = 'A Team Name is required.' elif not night: error = 'A Night is required.' elif not grade: error = 'A Grade is required.' elif not division: error = 'A Division is required.' elif db.execute( 'SELECT id FROM teams' ' WHERE teamname = ?' ' AND night = ?', (teamname, night)).fetchone() is not None: error = 'The team {} on {} is already registered.'.format( teamname, night) if error is None: db.execute( 'INSERT INTO teams (teamname, night, grade, division)' ' VALUES (?, ?, ?, ?, ?)', (teamname, night, grade, division)) db.commit() return redirect(url_for('teams.index')) flash(error) return render_template('teams/newteam.html')