def update(id): card = get_card(id) if request.method == 'POST': title = request.form['title'] body = request.form['body'] tag = request.form['tag'] error = None if not title: error = 'Title is required.' if not body: error = 'Body is empty' if not tag: error = "Please add a tag to this card" if error is not None: flash(error) else: db = get_db() db.execute( 'UPDATE card SET title = ?, body = ?, tag = ?' ' WHERE id = ?', (title, body, tag, id)) db.commit() return redirect(url_for('cards.index')) return render_template('cards/update.html', card=card)
def get_card(id): card = get_db().execute('SELECT id, title, body, tag FROM card').fetchone() if card is None: abort(404, "Post id {0} doesn't exist.".format(id)) return card
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 user WHERE id = ?', (user_id, )).fetchone()
def login(): 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: session.clear() session['user_id'] = user['id'] return redirect(url_for('index')) flash(error) return render_template('auth/login.html')
def create(): if request.method == 'POST': title = request.form['title'] body = request.form['body'] tag = request.form['tag'] error = None if not title: error = 'Title is empty' if not body: error = 'Body is empty' if not tag: error = 'Please tag this card' if error is not None: flash(error) else: db = get_db() db.execute( 'INSERT INTO card (title, body, tag)' ' VALUES (?, ?, ?)', (title, body, tag)) db.commit() return redirect(url_for('cards.index')) return render_template('cards/create.html')
def delete(id): get_card(id) db = get_db() db.execute('DELETE FROM card WHERE id = ?', (id, )) db.commit() return redirect(url_for('cards.index'))
def index(): db = get_db() cards = db.execute('SELECT id, title, body, tag FROM card').fetchall() return render_template('cards/index.html', cards=cards)