app.py

from flask import Flask, render_template, request, flash, redirect, url_for
from flask import abort, session
import pymysql as sql 
import datetime

app = Flask(__name__)
app.secret_key = b"_!@#$%^kafhdkfj@#$%^&lksdjf!@#$%^"


HOST = 'localhost'
PORT = 3306
USERNAME = 'blog'
PASSWORD = 'blog'
DATABASE = 'Blog'



try:
    DB = sql.connect(host=HOST, port=PORT, user=USERNAME, password=PASSWORD, database=DATABASE)
    CURSOR = DB.cursor()
    print("_____________Data Base Connected Sucessfully______________")
except:
    print("_____________Check DATABASE Connectivity First____________________")
    exit(0)

@app.route("/")   
def index():
    if 'username' in session:
        return redirect(url_for('blog'))
    return render_template('index.html')

@app.route('/logout')
def logout():
    session.pop('username', None)
    return redirect(url_for('index'))

@app.route("/login", methods=['POST', 'GET'])
def login():
    if request.method == 'GET':
        abort(405)
    try:
        email = request.form['email']
        password = request.form['password']
        query = f"SELECT * FROM users WHERE email='{email}'"
        rows = CURSOR.execute(query)
        if rows == 0:
            flash("!! No Such Account Exists Please Signup !!")
            return redirect(url_for('signup'))
        else:
            row = CURSOR.fetchone()
            # ('username', 'email', 'password', 'first_name', 'last_name', 'ph_no', 'sex')
            upass = row[2]
            if upass == password:
                session['username'] = row[0]
                return redirect(url_for('blog'))
            else:
                flash("!! Error!! Invalid Password Try Again !!")
                return redirect(url_for('index'))
    except:
        flash( "!! Invalid Form Data !!")
        return redirect(url_for('index'))

@app.route("/blog")
def blog():
    DB.commit()
    query = "SELECT * FROM blogs ORDER BY date DESC LIMIT 10;"
    CURSOR.execute(query)
    result = CURSOR.fetchall()
    return render_template('blog.html', result=result)

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

@app.route('/do_signup', methods=['POST'])
def do_signup():
    try:
        data = {
        'email': request.form['email'],
        'password': request.form['password'],
        'fname' : request.form['first_name'],
        'lname' : request.form['last_name'],
        'username':  request.form['username'],
        'gender': request.form['sex'],
        'mobile': request.form['ph_no']
        }
    except: 
        data = {'error': 'Invalid Form Data'}
    if 'error' not in data:
        query = f"SELECT * FROM users WHERE email='{data['email']}';"
        rows = CURSOR.execute(query)
        if rows != 0:
            flash("!!! User Account Already Exists Please Login to Continue !!!")
            return redirect(url_for('index'))
        else:
            query = f"SELECT * FROM users WHERE username='{data['username']}'"
            rows = CURSOR.execute(query)
            if rows != 0:
                flash("!! Username Already Taken Please Choose Diffrent Username !!")
                return redirect(url_for('signup'))
            else:
                query = f"INSERT INTO users (username, email, password, first_name, last_name, ph_no, sex) values\
('{data['username']}', '{data['email']}', '{data['password']}', '{data['fname']}', '{data['lname']}',\
 '{data['mobile']}', '{data['gender']}');"
                try:
                    CURSOR.execute(query)
                    DB.commit()
                    flash("!!Account Sucessfully Created Please Login to Enjoy Services!!")
                    return redirect(url_for('index'))
                except:
                    flash("!! Error in Updating Database!!")
                    return redirect(url_for('signup'))
    else:
        flash(data['error'])
        return redirect(url_for('index'))

@app.errorhandler(404)
def page_not_found(error):
    return render_template("error.html", error_msg=error), 404

@app.errorhandler(405)
def page_not_found(error):
    return render_template("error.html", error_msg=error)

@app.route('/post_blog')
def post_blog():
    if 'username' in session:
        flash("Write Code to update Blog")
        return render_template('post_blog.html')
    else:
        flash("!!Please Sign-In to Post Blogs!!")
        return redirect(url_for('index'))

@app.route('/update_blog', methods=['POST'])
def update_blog():
    title = request.form['title']
    topic = request.form['topic']
    content = request.form['content']
    username = session['username']
    d = datetime.datetime.now()
    day = f"{d.day}".zfill(2)
    month = f"{d.month}".zfill(2)
    date = f"{d.year}-{month}-{day}"
    query = f'INSERT INTO blogs (username, topic, heading, content, date) values\
    ("{username}", "{topic}", "{title}", "{content}", "{date}");'
    try:
        CURSOR.execute(query)
        DB.commit()
    except Exception as e:
        flash(f"{e}\n{query}")
        return redirect(url_for('index'))
    else:
        flash("!!Blog Updated Sucessfully!!")
        return redirect(url_for('index'))


    return f"{title}, {topic}, {content}, {username}, {date}"
if __name__ == "__main__":
    
    app.run('0.0.0.0', 80, debug=True)