app.py

from flask import Flask, render_template, request, redirect,flash
from flask_sqlalchemy import SQLAlchemy
from datetime import datetime
from sqlalchemy import desc
from flask_login import LoginManager,UserMixin,login_user,logout_user,login_required
import os


app = Flask(__name__)

ENV='prod'
#ENV='dev'

if ENV == 'dev':
    app.debug = True
    app.config['SQLALCHEMY_DATABASE_URI'] = os.getenv('dev_db')
else:
    app.debug = False
    app.config['SQLALCHEMY_DATABASE_URI'] = os.getenv('prod_db')

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SECRET_KEY'] = os.getenv('secret_key')
db = SQLAlchemy(app)


class BlogPost(db.Model):
    __tablename__ = 'projects'
    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')
    github=db.Column(db.String(100), nullable=False)
    date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)

    def __init__(self,title,content,author,github):
        self.title=title
        self.content=content
        self.author=author
        self.github=github

class User(UserMixin,db.Model):
    __tablename__ = 'users'
    id=db.Column(db.Integer, primary_key=True)
    email=db.Column(db.String(100), unique=True)
    password=db.Column(db.String(100))
    name=db.Column(db.String(100))

login_manager=LoginManager()
login_manager.init_app(app)

@login_manager.user_loader
def load_user(user_id):
    return User.query.get(int(user_id))


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


@app.route('/posts', methods=['GET', 'POST'])
def posts():
    if request.method == 'POST':
        if(request.form['sort']=="date"):
            all_posts = BlogPost.query.order_by(desc(BlogPost.date_posted)).all()
        elif(request.form['sort']=="name"):
            all_posts = BlogPost.query.order_by(BlogPost.title).all()
        else:
            all_posts = BlogPost.query.order_by(BlogPost.author).all()
    else:
        all_posts = BlogPost.query.order_by(desc(BlogPost.date_posted)).all()
    return render_template('posts.html',posts=all_posts)

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


@app.route('/posts/edit/<int:id>', methods=['GET', 'POST'])
@login_required
def edit(id):
    
    post = BlogPost.query.get_or_404(id)

    if request.method == 'POST':
        post.title = request.form['title']
        post.author = request.form['author']
        post.content = request.form['content']
        post.github = request.form['github']
        db.session.commit()
        return redirect('/posts')

    return render_template('edit.html', post=post)

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

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

@app.route('/devlogin' , methods=['GET', 'POST'])
def devlogin():
    if request.method == 'POST':
        name=request.form['dev_id']
        password=request.form['dev_key']
        user=User.query.filter_by(name=name).first()
        if not user :
            flash('Invalid Username !', 'danger') 
            return render_template('devlogin.html')
        elif not (password==user.password):
            flash('Your Password is incorrect !', 'danger') 
            return render_template('devlogin.html')

        login_user(user)

        return render_template('index.html')
    else:
        return render_template('devlogin.html')

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


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