FlaskRESTful之SQLAlchemy入门

使用步骤：

1. 编写数据库配置，并加载

# 创建数据库配置类
class Config(object):
    # 数据库链接地址
    SQLALCHEMY_DATABASE_URI = 'mysql://root:mysql@127.0.0.1:3306/test'

    # 禁用追踪
    SQLALCHEMY_TRACK_MODIFICATIONS = False

# 加载配置
app.config.from_object(Config)

2. 创建数据库对象

# 创建数据库对象
db = SQLAlchemy(app)

3. 定义模型类

# 创建模型类
class BookInfo(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String, nullable=False)
    author = db.Column(db.String, nullable=False)

代码案例：

from flask import Flask
from flask_restful import Api, Resource
# 导包
from flask_sqlalchemy import SQLAlchemy

# 创建数据库配置类
class Config(object):
    # 数据库链接地址
    SQLALCHEMY_DATABASE_URI = 'mysql://root:mysql@127.0.0.1:3306/test'

    # 禁用追踪
    SQLALCHEMY_TRACK_MODIFICATIONS = False

app = Flask(__name__)

# 加载配置
app.config.from_object(Config)

api = Api(app)
# 创建数据库对象
db = SQLAlchemy(app)

# 创建模型类
class BookInfo(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String, nullable=False)
    author = db.Column(db.String, nullable=False)


class IndexResource(Resource):
    def get(self):
        return 'index'

api.add_resource(IndexResource, '/')

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