db.execute("""CREATE TABLE posts AS SELECT ? AS content, "admin" AS author, FALSE AS published""", [flag]) db.execute("""CREATE TABLE posts AS SELECT ? AS content, "admin" AS author, FALSE AS published""", [flag]) @app.route("/publish", methods=["GET"]) defchallenge_publish(): if"username"notin flask.session: flask.abort(403, "Log in first!")
# https://www.sqlite.org/lang_update.html db.execute("UPDATE posts SET published = TRUE WHERE author = ?", [flask.session.get("username")]) return flask.redirect("/")