flask操作mysql最好方法_flask+pymysql操作MySQL数据库（下）

一、备份简书文章

上面实现了操作SQLAlchemy把数据存入数据库，接下来我试着把我的简书文章全部存入数据库做备份，直接上脚本：

vim modle.py

# coding:utf-8

from flask.ext.sqlalchemy import SQLAlchemy

from flask import Flask

app = Flask(__name__)

app.config['SECRET_KEY'] ='hard to guess'

app.config['SQLALCHEMY_DATABASE_URI']='mysql+pymysql://jianshu:jianshu@127.0.0.1:3306/jianshu'

app.config['SQLALCHEMY_COMMIT_ON_TEARDOWN']=True

db = SQLAlchemy(app)

class Category(db.Model):

__tablename__ = 'categorys'

id = db.Column(db.Integer, primary_key=True)

category_name = db.Column(db.String(64), unique=True, index=True)

category_url = db.Column(db.String(64), unique=True)

user = db.relationship('Article', backref='category')