app.py

from flask import Flask, render_template, request, redirect
from flask_sqlalchemy import SQLAlchemy
from datetime import datetime


app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///posts.db'
db = SQLAlchemy(app)

now = datetime.now()
dt_string = str(now.strftime('%m/%d/%y %H:%M:%S'))
print(dt_string)
date_time_obj = datetime.strptime(dt_string, '%m/%d/%y %H:%M:%S')


class BlogPost(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(100), nullable=False)
    content = db.Column(db.Text, nullable=False)
    author = db.Column(db.String(100), nullable=False, default="N/A")
    date_posted = db.Column(db.DateTime, nullable=False, default=date_time_obj)

    def __repr__(self):
        return "Blog Post " + str(self.id)


@app.before_first_request
def create_tables():
    db.create_all()


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


@app.route('/posts', methods=["GET", "POST"])
def posts():
    if request.method == "POST":
        post_title = request.form['title']
        post_content = request.form['content']
        post_author = request.form['author']
        new_post = BlogPost(
            title=post_title, content=post_content, author=post_author)
        db.session.add(new_post)
        db.session.commit()
        return redirect("/posts")
    else:
        all_posts = BlogPost.query.order_by(BlogPost.date_posted).all()
        total = len(all_posts)
        return render_template("posts.html", posts=all_posts, total=total)


@app.route("/posts/delete/<int:id>")
def delete(id):
    post = BlogPost.query.get_or_404(id)
    db.session.delete(post)
    db.session.commit()
    return redirect("/posts")


@app.route("/posts/edit/<int:id>", methods=["GET", "POST"])
def edit(id):
    post = BlogPost.query.get_or_404(id)
    if request.method == "POST":
        post.title = request.form['title']
        post.content = request.form['content']
        post.author = request.form['author']
        db.session.commit()
        return redirect("/posts")
    else:
        return render_template("edit.html", post=post)


@app.route('/posts/new', methods=["GET", "POST"])
def new_posts():
    if request.method == "POST":
        post_title = request.form['title']
        post_content = request.form['content']
        post_author = request.form['author']
        new_post = BlogPost(
            title=post_title, content=post_content, author=post_author)
        db.session.add(new_post)
        db.session.commit()
        return redirect("/posts")
    else:
        return render_template("new_post.html")


if __name__ == "__main__":
    app.run(debug=True)