blog.py

"""
This will be a template for starting flask projects


"""

from flask import Flask, url_for, render_template, request, redirect
from werkzeug.security import generate_password_hash, check_password_hash
#import encryption as e
from hashlib import blake2b
from markupsafe import escape
import sqlite3
from create_post import *
from datetime import date
from manage_db import *
app = Flask(__name__)




@app.route('/test')
def test():
    return render_template('test.html')


      
    
@app.route('/')
def index():
    return render_template('index.html')

    
@app.route('/page2')
def page2():
    return render_template('page2.html')
   

#When a user clicks on a link to a post, there will have to be a way to determine which row to take from the database
#for now the page can always be /blog_post, but the vals array will be loaded with the data based on which article it is.  
@app.route('/blog_post<id>')
def blog_post(id):
    """Gets all relevant info from the database and renders a template with it. """
    conn = sqlite3.connect('blog.db')
    c = conn.cursor()
    c.execute("SELECT * from blog_posts;")
    vals = []
    vals = c.fetchall()
    c.close()
    index = int(id)
    return render_template('blog_post.html', title = vals[index][1] ,content = vals[index][3])
  

    
@app.route('/user')
def user():
    return render_template('user.html')
    
    
@app.route('/login',methods=['POST', 'GET'])
def login():
    error = None
    if request.method == 'POST':
        if request.form['username'] != 'admin' or request.form['password'] != 'flaskword':
            error = 'Invalid Credentials. Please try again.'
        else:
            return redirect(url_for('index'))
    return render_template('login.html', error=error)
 
 
 
@app.route('/register', methods=['POST', 'GET']) 
def register():
    error = None 
    if request.method == 'POST':
        conn = sqlite3.connect('blog.db')
        c = conn.cursor()
        username = request.form['username']
        password = request.form['password']
      
        pw = generate_password_hash(password)
        c.execute("INSERT INTO users VALUES ('{}','{}!')".format(username, pw))

        conn.commit()
        conn.close()
    return render_template('register.html', error=error)

    




@app.route('/create', methods=('GET', 'POST'))
def create():
    val = []
    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:
            conn = sqlite3.connect('blog.db')
            c = conn.cursor()
            c.execute("INSERT INTO posts VALUES(NULL, ?, ?, ?);", (title, date.today(), body))
            conn.commit()
            conn.close()

            
    return render_template('create.html')