pip install marshmallow_sqlalchemy,marshmallow

from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
# 定義一個(gè)數(shù)據(jù)庫(kù)表結(jié)構(gòu)的數(shù)據(jù)模型
class AssetModel(db.Model):
    __tablename__ = 'asset'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    init_date = db.Column(db.String(30), nullable=False)
    username = db.Column(db.String(20), nullable=False)
    account = db.Column(db.String(20), nullable=False)
    update_time = db.Column(db.DateTime, nullable=False)
    def __init__(self, username, init_date,account, update_time):
        self.username = username
        self.init_date = init_date
        self.account = account
        self.update_time = str(update_time)
3、接著我們開(kāi)始定義一個(gè)序列化器
from models.assetmodel import AssetModel
from marshmallow_sqlalchemy import SQLAlchemyAutoSchema
from marshmallow import EXCLUDE,validate,fields
class AssetSerializer(SQLAlchemyAutoSchema):
    class Meta:
        model = AssetModel   # 配置對(duì)應(yīng)的模型
        ordered = True       # 設(shè)置是否排序
        include_fk = True    # 是否包含外鍵
        unknown = EXCLUDE    # 未知字段序列化選項(xiàng)
        # exclude = ("name",)  # 序列化不需要的字段，反之對(duì)應(yīng)的是include

from models.assetmodel import AssetModel
from marshmallow_sqlalchemy import SQLAlchemyAutoSchema
from marshmallow import EXCLUDE,validate,fields
class AssetSerializer(SQLAlchemyAutoSchema):
    class Meta:
        model = AssetModel   # 配置對(duì)應(yīng)的模型
        ordered = True       # 設(shè)置是否排序
        include_fk = True    # 是否包含外鍵
        unknown = EXCLUDE    # 未知字段序列化選項(xiàng)
        # exclude = ("name",)  # 序列化不需要的字段，反之對(duì)應(yīng)的是include

from models.assetmodel import AssetModel,AssetSerializer
testdata_blueprint = Blueprint('testdata', __name__, url_prefix='/TestData')
@testdata_blueprint.route('/testdata', methods=['GET'])
def get_testdata_list():
    # 獲取當(dāng)前查詢(xún)頁(yè)碼，默認(rèn)為：1
    page = request.args.get('page',1,type=int)
    # 獲取每頁(yè)顯示記錄數(shù)，默認(rèn)是20
    limit = request.args.get('limit',20,type=int)
    # 獲取查詢(xún)的資產(chǎn)賬號(hào)
    account = request.args.get('account',type=int)
    # 計(jì)算當(dāng)前頁(yè)，開(kāi)始的記錄編號(hào)
    start = (page - 1) * limit
    # 計(jì)算當(dāng)前頁(yè)，結(jié)束的記錄編號(hào)；
    end = start + limit
    # 分頁(yè)查詢(xún)
    items = AssetModel.query.slice(start, end)
    # 獲取記錄總數(shù)
    total = AssetModel.query.count()
    # 將查詢(xún)結(jié)果進(jìn)行序列化
    items = AssetSerializer().dump(items,many=True)  # 記得帶上many=True參數(shù)，否則查詢(xún)結(jié)果為空
    # 將結(jié)果轉(zhuǎn)成json結(jié)構(gòu)進(jìn)行返回
    return jsonify({
        'code': 20000,
        'msg': 'success',
        'data': {
            'items': items,
            'total':total
        }
    })