def index():
"""Show all the games, most recent first."""
db = get_db()
games = db.execute("SELECT p.id, title, body, tipoff, author_id, username"
" FROM game p JOIN user u ON p.author_id = u.id"
" ORDER BY tipoff DESC").fetchall()
return render_template("gamelist/index.html", games=games)
def get_game(id, check_author=True):
"""Get a game and its author by id.
Checks that the id exists and optionally that the current user is
the author.
:param id: id of game to get
:param check_author: require the current user to be the author
:return: the game with author information
:raise 404: if a game with the given id doesn't exist
:raise 403: if the current user isn't the author
"""
game = (get_db().execute(
"SELECT p.id, title, body, tipoff, author_id, username"
" FROM game p JOIN user u ON p.author_id = u.id"
" WHERE p.id = ?",
(id, ),
).fetchone())
if game is None:
abort(404, f"Game id {id} doesn't exist.")
if check_author and g.user["admin"] == 0:
abort(403)
return game
def register():
"""Register a new user.
Validates that the username is not already taken. Hashes the
password for security.
"""
if request.method == "POST":
username = request.form["username"]
password = request.form["password"]
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 user WHERE username = ?",
(username, )).fetchone() is not None):
error = f"User {username} is already registered."
if error is None:
# the name is available, store it in the database and go to
# the login page
db.execute(
"INSERT INTO user (username, password, points) VALUES (?, ?, 100)",
(username, generate_password_hash(password)),
)
db.commit()
return redirect(url_for("auth.login"))
flash(error)
return render_template("auth/register.html")
def load_logged_in_user():
"""If a user id is stored in the session, load the user object from
the database into ``g.user``."""
user_id = session.get("user_id")
if user_id is None:
g.user = None
else:
g.user = (get_db().execute("SELECT * FROM user WHERE id = ?",
(user_id, )).fetchone())
def delete(id):
"""Delete a game.
Ensures that the game exists and that the logged in user is the
author of the game.
"""
get_game(id)
db = get_db()
db.execute("DELETE FROM game WHERE id = ?", (id, ))
db.commit()
return redirect(url_for("gamelist.index"))
def show_user(id):
"""Get user by id.
Checks that the id exists
:param id: id of user to get
:param check_author: require the current user to be the author
:return: the user with information
:raise 404: if a game with the given id doesn't exist
:raise 403: if the current user isn't the author
"""
user = (get_db().execute(
" SELECT id, username, points, assets "
" FROM user "
" WHERE id = ?",
(id, ),
).fetchone())
if user is None:
abort(404, f"User id {id} doesn't exist.")
return render_template("auth/user.html", user=user)
def create():
"""Create a new game for the current user."""
if request.method == "POST":
title = request.form["title"]
tipoff = request.form["tipoff"]
body = request.form["body"]
error = None
if not title:
error = "Title is required."
if error is not None:
flash(error)
else:
db = get_db()
db.execute(
"INSERT INTO game (title, tipoff, body, author_id) VALUES (?, ?, ?, ?)",
(title, tipoff, body, g.user["id"]),
)
db.commit()
return redirect(url_for("gamelist.index"))
return render_template("gamelist/create.html")
def update(id):
"""Update a game if the current user is the author."""
game = get_game(id)
if request.method == "POST":
title = request.form["title"]
body = request.form["body"]
tipoff = request.form["tipoff"]
error = None
if not title:
error = "Title is required."
if error is not None:
flash(error)
else:
db = get_db()
db.execute(
"UPDATE game SET title = ?, body = ?, tipoff = ? WHERE id = ?",
(title, body, tipoff, id))
db.commit()
return redirect(url_for("gamelist.index"))
return render_template("gamelist/update.html", game=game)
def login():
"""Log in a registered user by adding the user id to the session."""
if request.method == "POST":
username = request.form["username"]
password = request.form["password"]
db = get_db()
error = None
user = db.execute("SELECT * FROM user 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:
# store the user id in a new session and return to the index
session.clear()
session["user_id"] = user["id"]
return redirect(url_for("index"))
flash(error)
return render_template("auth/login.html")