一个简单的flask框架博客

首先，我从bootstrap网站找了一个简单的博客模板，然后将html文件作为模板文件放入templates目录，将index.html引用的CSS,JS,IMG等静态资源放入static目录，修改index.html文件，将页面上半部分和页面下半部分分为header和footer模板，然后index，post，newpost模板引入。

因为我本地有mysql数据库，所以使用了数据库，注意的地方是当博客内容，主题，作者为中文的时候，需要注意数据库连接字符串的参数。否则，保存到数据表的内容全部是乱码。

下面就是最重要的三个文件了，入口文件，数据模型文件，数据库连接的文件，使用了flask-sqlalchemy，pymysql，

run.py

from flask import Flask
from flask import render_template, request, url_for, redirect
from sqlalchemy import desc
from database import session
from models import Blog


app = Flask(__name__)


@app.route('/')
def index():
    blog_title = '我的博客'
    db_session = session()
    allblog = db_session.query(Blog).order_by(desc(Blog.post_date)).all()
    return render_template('index.html',
                           blog_title=blog_title, allblog=allblog)


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


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


@app.route('/post/<post_id>')
def post(post_id):
    db_session = session()
    entry = db_session.query(Blog).filter(Blog.id == post_id).one()
    return render_template('post.html', entry=entry)


@app.route('/newpost', methods=['post'])
def newpost():
    if request.method == 'POST':
        db_session = session()
        title = request.form['title']
        catagory = request.form['catagory']
        auther = request.form['auther']
        content = request.form['content']
        entry = Blog(title=title, catagory=catagory,
                     auther=auther, content=content)
        db_session.add(entry)
        db_session.commit()
    return redirect(url_for('index'))


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

database.py

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from models import Base


engine = create_engine(
    'mysql+pymysql://root:1234@localhost/test?charset=utf8',
    convert_unicode=True)
session = sessionmaker(bind=engine)


def init_db():
    # import all modules here that might define models so that
    # they will be registered properly on the metadata.  Otherwise
    # you will have to import them first before calling init_db()
    from models import Blog
    Base.metadata.create_all(Blog, bind=engine)

models.py

from datetime import datetime
from sqlalchemy import Column, Integer, String, DateTime, Text
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class Blog(Base):
    __tablename__ = 'blog'
    id = Column(Integer, primary_key=True)
    title = Column(String(50))
    catagory = Column(String(50))
    auther = Column(String(50))
    content = Column(Text)
    post_date = Column(DateTime, default=datetime.now)

    def __reqr__(self):
        return "<Blog %r>" % self.title

最后修改于 2018-06-05