def index(): db = get_database() posts = db.execute('SELECT p.id, title, body, created, author_id, username' ' FROM post p JOIN user u ON p.author_id = u.id' ' ORDER BY created DESC').fetchall() return render_template('blog/index.html', posts=posts)
def register(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] database = get_database() error = None if not username: error = 'Username is required' elif not password: error = 'Password is required' elif database.execute('SELECT id FROM user WHERE username = ?', (username, )).fetchone() is not None: error = 'Username {} already exists.'.format(username) if error is None: database.execute( 'INSERT INTO user (username, password) VALUES (?, ?)', (username, generate_password_hash(password))) database.commit() return redirect(url_for('auth.login')) flash(error) return render_template('auth/register.html')
def load_logged_in_user(): user_id = session.get('user_id') if user_id is None: g.user = None else: g.user = get_database().execute('SELECT * FROM user WHERE id = ?', (user_id, )).fetchone()
def create(): if request.method == 'POST': title = request.form['title'] body = request.form['body'] error = None if not title: error = 'Title is required' if error is not None: flash(error) else: db = get_database() db.execute( 'INSERT INTO post (title, body, author_id)' 'VALUES (?, ?, ?)', (title, body, g.user['id'])) db.commit() return redirect(url_for('blog.index')) return render_template('blog/create.html')
def update(id): post = get_post(id) if request.method == 'POST': title = request.form['title'] body = request.form['body'] error = None if not title: error = 'Title is required' if error is not None: flash(error) else: db = get_database() db.execute('UPDATE post SET title = ?, body = ?' ' WHERE id = ?', (title, body, id)) db.commit() return redirect(url_for('blog.index')) return render_template('blog/update.html', post=post)
def login(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] database = get_database() error = None user = database.execute('SELECT * FROM user WHERE username = ?', (username, )).fetchone() if username 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 delete(id): get_post(id) database = get_database() database.execute('DELETE FROM post WHERE id =? ', (id, )) database.commit() return redirect(url_for('blog.index'))