Blogging Website using Python-flask,MySql,Bootstrap 4
Project must be save in a folder
JSON :
Template for Html files
Static for Media /Javascript/any other files
Python code must be save as Main.py
main.py :
| | |
| from flask import Flask ,render_template ,request,session,redirect,flash from flask_sqlalchemy import SQLAlchemy from datetime import datetime | |
| import json | |
| from werkzeug.utils import secure_filename | |
| import os | |
| import math | |
| from flask_mail import Mail | |
| with open('config.json', 'r') as c : | |
| params =json.load(c)["params"] | |
| local_server=True | |
| app=Flask(__name__) | |
| app.secret_key = 'super-secret-key' | |
| app.config['UPLOAD_FOLDER'] = params['uploader location'] | |
| '''mail setup starts::::''' | |
| app.config.update( | |
| MAIL_SERVER = 'smtp.gmail.com' , | |
| MAIL_PORT = '465', | |
| MAIL_USE_SSL = True, | |
| MAIL_USERNAME = params['gmail_username'], | |
| MAIL_PASSWORD = params['gmail_password'] | |
| ) | |
| mail=Mail(app) | |
| '''json parameter setup''' | |
| if(local_server): | |
| #sqlalchemy starts here | |
| app.config['SQLALCHEMY_DATABASE_URI'] = params['local_uri'] | |
| else: | |
| app.config['SQLALCHEMY_DATABASE_URI'] = params['prod_uri'] | |
| db = SQLAlchemy(app) | |
| #class for defining the databse of the table | |
| class Contacts(db.Model): #also name of database | |
| '''sno,name,email,phone_num,msgs,date''' | |
| sno = db.Column(db.Integer, primary_key=True) | |
| name = db.Column(db.String(80), unique=False, nullable=False) | |
| email = db.Column(db.String(120), unique=False, nullable=False) | |
| phone_num = db.Column(db.String(20), unique=True, nullable=False) | |
| msgs = db.Column(db.String(120), unique=False, nullable=False) | |
| date = db.Column(db.String(12), unique=True, nullable=True) | |
| class Posts(db.Model): #also name of databse | |
| '''sno,title,slug,content,date''' | |
| sno = db.Column(db.Integer, primary_key=True) | |
| title = db.Column(db.String(50), unique=True, nullable=False) | |
| subtitle = db.Column(db.String(50), unique=False, nullable=False) | |
| slug = db.Column(db.String(25), unique=True, nullable=False) | |
| content = db.Column(db.String(120), unique=False, nullable=False) | |
| date = db.Column(db.String(12), unique=True, nullable=True) | |
| img_url =db.Column(db.String(30),unique=True,nullable=True) | |
| @app.route("/") | |
| def home(): | |
| posts=Posts.query.filter_by().all() | |
| #[0:params['post_number']] | |
| last=int(math.ceil(len(posts) / int(params['post_number']))) | |
| page = request.args.get('page') | |
| if(not str(page).isnumeric()): | |
| page=1 | |
| page = int(page) | |
| posts=posts[(page-1)*int(params['post_number']) : (page-1)*int(params['post_number']) + int(params['post_number']) ] | |
| if(page==1): | |
| prev="#" | |
| next="/?page=" + str(page+1) | |
| elif(page==last): | |
| prev = "/?page=" + str(page-1) | |
| next = "#" | |
| else: | |
| prev = "/?page=" + str(page-1) | |
| next = "/?page=" + str(page + 1) | |
| return render_template('index.html',params=params,posts=posts,prev=prev,next=next) | |
| @app.route("/about") | |
| def about(): | |
| return render_template('about.html',params=params) | |
| @app.route("/contact",methods=["GET","POST"]) | |
| def contact(): | |
| if(request.method=='POST'): | |
| '''add entry to the data base''' | |
| name = request.form.get('name') | |
| email = request.form.get('email') | |
| phone = request.form.get('phone') | |
| message = request.form.get('message') | |
| '''Set var to the db - input : sno,name,email,phone_num,msgs,date''' | |
| entry = Contacts(name=name , phone_num=phone ,email=email,date=datetime.now(), msgs=message ) | |
| db.session.add(entry) | |
| db.session.commit() | |
| '''send msgs through mail''' | |
| mail.send_message('New message from ' + name, | |
| sender='email', | |
| recipients=[params['gmail_username']], | |
| body = message + "\n" + phone ) | |
| return render_template('contact.html',params=params) | |
| @app.route("/post/<string:post_slug>",methods=['GET']) | |
| def post_route(post_slug): | |
| post=Posts.query.filter_by(slug=post_slug).first() | |
| return render_template('post.html',params=params,post=post) | |
| @app.route("/dashboard",methods=['GET','POST']) | |
| def dashboard(): | |
| if( 'user' in session and session['user']==params['admin_usr'] ): | |
| posts=Posts.query.filter_by().all() | |
| return render_template('dashboard.html',params=params,posts=posts) | |
| if request.method =='POST': | |
| username=request.form.get('username') | |
| password=request.form.get('password') | |
| posts=Posts.query.filter_by().all() | |
| if(username== params['admin_usr'] and password==params['admin_pass']): | |
| session['user']=username | |
| return render_template('dashboard.html',params=params,posts=posts) | |
| else: | |
| return render_template('login.html', params=params) | |
| return render_template('login.html',params=params) | |
| @app.route("/edit/<string:sno>",methods=['GET','POST']) | |
| def edit(sno): | |
| if ('user' in session and session['user'] == params['admin_usr']): | |
| if (request.method == 'POST'): | |
| box_title = request.form.get('title') | |
| subtitle=request.form.get('subtitle') | |
| slug = request.form.get('slug') | |
| content = request.form.get('content') | |
| img_url =request.form.get('img_url') | |
| date=datetime.now() | |
| if sno =='0': | |
| post = Posts(title=box_title,subtitle=subtitle,content=content,slug=slug,img_url=img_url,date=date) | |
| db.session.add(post) | |
| db.session.commit() | |
| else: | |
| post = Posts.query.filter_by(sno=sno).first() | |
| post.title=box_title | |
| post.subtitle=subtitle | |
| post.slug=slug | |
| post.img_url=img_url | |
| post.content=content | |
| post.date=date | |
| db.session.commit() | |
| return redirect('/edit/'+sno) | |
| post=Posts.query.filter_by(sno=sno).first() | |
| return render_template('add_post.html',params=params,post=post) | |
| @app.route("/uploader",methods=['GET','POST']) | |
| def uploader(): | |
| if ('user' in session and session['user'] == params['admin_usr']): | |
| if(request.method=='POST'): | |
| f=request.files['file1'] | |
| f.save(os.path.join(app.config['UPLOAD_FOLDER'],secure_filename(f.filename))) | |
| flash('Uploaded Sucessfully') | |
| return redirect('/dashboard') | |
| @app.route("/logout") | |
| def logout(): | |
| session.pop('user') | |
| return redirect('/dashboard') | |
| @app.route("/delete/<string:sno>",methods=['GET','POST']) | |
| def delete(sno): | |
| if ('user' in session and session['user'] == params['admin_usr']): | |
| post =Posts.query.filter_by(sno=sno).first() | |
| db.session.delete(post) | |
| db.session.commit() | |
| return redirect('/dashboard') | |
| app.run(debug=True) | |
| { | |
| "params": | |
| { | |
| "local_server":"True", | |
| "local_uri": "mysql+pymysql://root:@localhost/blog", | |
| "prod_uri": "mysql+pymysql://root:@localhost/blog", | |
| "fb_url": "https://facebook.com/spykarsumit", | |
| "git_url": "https://github.com/sumitskr", | |
| "insta_url": "https://instagram.com/sumitsarkarrrr", | |
| "site_title" : "Condemn", | |
| "site_header" : "Sumit Sarkar", | |
| "tag_line" : "A Blog by Sumit Sarkar", | |
| "gmail_username" : "sumitsarkar.op@gmail.com", | |
| "gmail_password": "**********", | |
| "about_self" : "Hi,I'am Sumit Sarkar studying B.Tech(CSE) in MAKAUT(WB).I'm here to learn WEB-development using flask documentation of Python .I created this website for my own web project. : )", | |
| "post_number" : 2, | |
| "admin_usr" : "sumitsarkar", | |
| "admin_pass" : "032154268", | |
| "uploader location" : "C:\\Users\\sumit\\web_tut\\static" | |
| } | |
| } |
requirements:
pip install flask
pip install SQLAlchemy
pip install requests
pip install pymysql
I used PHPmyadmin for better graphical works.
pip install flask_mail
pip install wrekzeug
Comments
Post a Comment