{"id":21,"date":"2025-08-02T22:15:39","date_gmt":"2025-08-02T14:15:39","guid":{"rendered":"https:\/\/22z.top\/?p=21"},"modified":"2025-08-02T22:15:40","modified_gmt":"2025-08-02T14:15:40","slug":"marshmallow%e5%9f%ba%e7%a1%80%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"https:\/\/22z.top\/?p=21","title":{"rendered":"Marshmallow\u57fa\u7840\u4f7f\u7528"},"content":{"rendered":"\n

\u5b98\u65b9\u6587\u6863\uff1ahttps:\/\/marshmallow.readthedocs.io\/en\/latest\/<\/a><\/h1>\n\n\n\n

Marshmallow\uff0c\u4e2d\u6587\u8bd1\u4f5c\uff1a\u68c9\u82b1\u7cd6\u3002\u662f\u4e00\u4e2a\u8f7b\u91cf\u7ea7\u7684\u6570\u636e\u683c\u5f0f\u8f6c\u6362\u7684\u6a21\u5757\uff0c\u4e5f\u53eb\u5e8f\u5217\u5316\u548c\u53cd\u5e8f\u5217\u5316\u6a21\u5757\uff0c\u5e38\u7528\u4e8e\u5c06\u590d\u6742\u7684orm\u6a21\u578b\u5bf9\u8c61\u4e0epython\u539f\u751f\u6570\u636e\u7c7b\u578b\u4e4b\u95f4\u76f8\u4e92\u8f6c\u6362\u3002marshmallow\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684api\u529f\u80fd\u3002\u5982\u4e0b\uff1a<\/p>\n\n\n\n

\n
    \n
  1. Serializing<\/strong>\u5e8f\u5217\u5316[\u53ef\u4ee5\u628a\u6570\u636e\u5bf9\u8c61\u8f6c\u5316\u4e3a\u53ef\u5b58\u50a8\u6216\u53ef\u4f20\u8f93\u7684\u6570\u636e\u7c7b\u578b\uff0c\u4f8b\u5982\uff1aobjects\/object->list\/dict\uff0cdict\/list->string]<\/li>\n\n\n\n
  2. Deserializing<\/strong>\u53cd\u5e8f\u5217\u5316\u5668[\u628a\u53ef\u5b58\u50a8\u6216\u53ef\u4f20\u8f93\u7684\u6570\u636e\u7c7b\u578b\u8f6c\u6362\u6210\u6570\u636e\u5bf9\u8c61\uff0c\u4f8b\u5982\uff1alist\/dict->objects\/object\uff0cstring->dict\/list]<\/li>\n\n\n\n
  3. Validation<\/strong>\u6570\u636e\u6821\u9a8c\uff0c\u53ef\u4ee5\u5728\u53cd\u5e8f\u5217\u5316\u9636\u6bb5\uff0c\u9488\u5bf9\u8981\u8f6c\u6362\u6570\u636e\u7684\u5185\u5bb9\u8fdb\u884c\u7c7b\u578b\u9a8c\u8bc1\u6216\u81ea\u5b9a\u4e49\u9a8c\u8bc1\u3002<\/li>\n<\/ol>\n<\/blockquote>\n\n\n\n

    Marshmallow\u672c\u8eab\u662f\u4e00\u4e2a\u5355\u72ec\u7684\u5e93\uff0c\u57fa\u4e8e\u6211\u4eec\u5f53\u524d\u9879\u76ee\u4f7f\u7528\u6846\u67b6\u662fflask\u5e76\u4e14\u6570\u636e\u5e93ORM\u6846\u67b6\u4f7f\u7528SQLAlchemy\uff0c\u6240\u4ee5\u6211\u4eec\u53ef\u4ee5\u901a\u8fc7\u5b89\u88c5flask-sqlalchemy\u548cmarshmallow-sqlalchemy\u96c6\u6210\u5230\u9879\u76ee\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n\n\n\n

    \u57fa\u672c\u5b89\u88c5\u548c\u914d\u7f6e<\/h2>\n\n\n\n

    \u6a21\u5757\u5b89\u88c5\uff1a<\/p>\n\n\n\n

    pip install -U marshmallow-sqlalchemy
    pip install -U flask-sqlalchemy
    pip install -U flask-marshmallow<\/pre>\n\n\n\n
    Marshmallow\u6a21\u5757\u5feb\u901f\u4f7f\u7528\uff0c\u6211\u4eec\u5355\u72ec\u521b\u5efa\u4e00\u4e2apython\u6587\u4ef6\u8fdb\u884c\u57fa\u672c\u7684\u4f7f\u7528\uff0cdocs\/main.py\uff1a<\/p>\n\n\n\n
    from datetime import datetime
    \u200b
    from flask import Flask
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/mofang?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \u200b
    class User(db.Model):
        __tablename__ = \"tb_user\"
        id = db.Column(db.Integer, primary_key=True, comment=\"\u4e3b\u952eID\")
        username = db.Column(db.String(255), index=True, comment=\"\u7528\u6237\u540d\")
        password = db.Column(db.String(255), comment=\"\u767b\u5f55\u5bc6\u7801\")
        mobile = db.Column(db.String(15), index=True, comment=\"\u624b\u673a\u53f7\u7801\")
        sex = db.Column(db.Boolean, default=True, comment=\"\u6027\u522b\")
        email = db.Column(db.String(255), index=True, comment=\"\u90ae\u7bb1\")
        created_time = db.Column(db.DateTime, default=datetime.now, comment=\"\u521b\u5efa\u65f6\u95f4\")
        updated_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now, comment=\"\u66f4\u65b0\u65f6\u95f4\")
    \u200b
        def __repr__(self):
            return \"<%s: %s>\" % (self.__class__.name,self.username)
    \u200b
    \u200b
    @app.route(\"\/\")
    def index():
        return \"ok\"
    \u200b
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True,port=5555)<\/pre>\n\n\n\n
    \u57fa\u672c\u6784\u9020\u5668(Schema)<\/h2>\n\n\n\n
    \u4e5f\u53ef\u4ee5\u53eb\u57fa\u672c\u6a21\u5f0f\u7c7b\u6216\u57fa\u672c\u5e8f\u5217\u5316\u5668\u7c7b\u3002<\/p>\n\n\n\n
    marshmallow\u8f6c\u6362\u6570\u636e\u683c\u5f0f\u4e3b\u8981\u901a\u8fc7\u6784\u9020\u5668\u7c7b\uff08\u5e8f\u5217\u5316\u5668\uff09\u6765\u5b8c\u6210\u3002\u5728marshmallow\u4f7f\u7528\u8fc7\u7a0b\u4e2d\u6240\u6709\u7684\u6784\u9020\u5668\u7c7b\u5fc5\u987b\u76f4\u63a5\u6216\u95f4\u63a5\u7ee7\u627f\u4e8eSchema\u57fa\u7c7b\uff0c\u800cSchema\u57fa\u7c7b\u63d0\u4f9b\u4e86\u6570\u636e\u8f6c\u6362\u7684\u57fa\u672c\u529f\u80fd\uff1a\u5e8f\u5217\u5316\uff0c\u9a8c\u8bc1\u6570\u636e\u548c\u53cd\u5e8f\u5217\u5316\u3002<\/p>\n\n\n\n
    \u57fa\u4e8eSchema\u5b8c\u6210\u6570\u636e\u5e8f\u5217\u5316\u8f6c\u6362<\/h3>\n\n\n\n
    from datetime import datetime
    \u200b
    from flask import Flask
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/yingming?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    app.config[\"SQLALCHEMY_ECHO\"] = True
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \u200b
    \"\"\"\u6a21\u578b\"\"\"
    class User(db.Model):
        __tablename__ = \"desc_user\"
        id = db.Column(db.Integer, primary_key=True, comment=\"\u4e3b\u952eID\")
        username = db.Column(db.String(255), index=True, comment=\"\u7528\u6237\u540d\")
        password = db.Column(db.String(255), comment=\"\u767b\u5f55\u5bc6\u7801\")
        mobile = db.Column(db.String(15), index=True, comment=\"\u624b\u673a\u53f7\u7801\")
        sex = db.Column(db.Boolean, default=True, comment=\"\u6027\u522b\")
        email = db.Column(db.String(255), index=True, comment=\"\u90ae\u7bb1\")
        created_time = db.Column(db.DateTime, default=datetime.now, comment=\"\u521b\u5efa\u65f6\u95f4\")
        updated_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now, comment=\"\u66f4\u65b0\u65f6\u95f4\")
    \u200b
        def __repr__(self):
            return \"<%s: %s>\" % (self.__class__.__name__, self.username)
    \u200b
    \u200b
    \"\"\"\u5e8f\u5217\u5316\u5668\"\"\"
    \u200b
    from marshmallow import Schema, fields
    \u200b
    \u200b
    class UserSchema(Schema):
        username = fields.String()
        mobile = fields.String()
        sex = fields.Boolean()
        email = fields.Email()
        created_time = fields.DateTime()
        updated_time = fields.DateTime()
    \u200b
    \u200b
    \u200b
    @app.route(\"\/1\")
    def index1():
        \"\"\"\u5e8f\u5217\u5316\u4e00\u4e2a\u5bf9\u8c61\u6210\u5b57\u5178\u6216\u5b57\u7b26\u4e32\"\"\"
        # \u6a21\u62df\u4ece\u6570\u636e\u5e93\u4e2d\u8bfb\u53d6\u51fa\u6765\u7684\u6a21\u578b\u7c7b
        user = User(
            username=\"xiaoming\",
            mobile=\"13312345677\",
            sex=True,
            email=\"133123456@qq.com\",
            created_time=datetime.now(),
            updated_time=datetime.now()
        )
    \u200b
        db.session.add(user)
        db.session.commit()
        print(user)
    \u200b
        # \u5e8f\u5217\u5316\u6210\u4e00\u4e2a\u5b57\u5178
        us = UserSchema()
        result = us.dump(user)
        print(result, type(result))
    \u200b
        # \u5e8f\u5217\u5316\u5668\u6210\u4e00\u4e2a\u5b57\u7b26\u4e32[\u7b26\u5408json\u8bed\u6cd5]
        result = us.dumps(user)
        print(result, type(result))
    \u200b
        # \u5982\u679c\u8981\u5e8f\u5217\u5316\u591a\u4e2a\u6a21\u578b\u5bf9\u8c61\uff0c\u53ef\u4ee5\u4f7f\u7528many=True
        result = us.dump([user,user,user], many=True)
        print(result)
        result = us.dumps([user,user,user], many=True)
        print(result)
        return \"ok\"
    \u200b
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True, port=5555)<\/pre>\n\n\n\n
    schema\u5e38\u7528\u5c5e\u6027\u6570\u636e\u7c7b\u578b<\/strong><\/p>\n\n\n\n
    \u7c7b\u578b<\/th>\u63cf\u8ff0<\/th><\/tr><\/thead>
    fields.Dict<\/code><\/a>(keys, type]] = None, values, \u2026)<\/td>\u5b57\u5178\u7c7b\u578b\uff0c\u5e38\u7528\u4e8e\u63a5\u6536json\u7c7b\u578b\u6570\u636e<\/td><\/tr>
    fields.List<\/code><\/a>(cls_or_instance, type], **kwargs)<\/td>\u5217\u8868\u7c7b\u578b\uff0c\u5e38\u7528\u4e8e\u63a5\u6536\u6570\u7ec4\u6570\u636e<\/td><\/tr>
    fields.Tuple<\/code><\/a>(tuple_fields, *args, **kwargs)<\/td>\u5143\u7ec4\u7c7b\u578b<\/td><\/tr>
    fields.String<\/code><\/a>(*, default, missing, data_key, \u2026)<\/td>\u5b57\u7b26\u4e32\u7c7b\u578b<\/td><\/tr>
    fields.UUID<\/code><\/a>(*, default, missing, data_key, \u2026)<\/td>UUID\u683c\u5f0f\u7c7b\u578b\u7684\u5b57\u7b26\u4e32<\/td><\/tr>
    fields.Number<\/code><\/a>(*, as_string, **kwargs)<\/td>\u6570\u503c\u57fa\u672c\u7c7b\u578b<\/td><\/tr>
    fields.Integer<\/code><\/a>(*, strict, **kwargs)<\/td>\u6574\u578b<\/td><\/tr>
    fields.Decimal<\/code><\/a>(places, rounding, *, allow_nan, \u2026)<\/td>\u6570\u503c\u578b<\/td><\/tr>
    fields.Boolean<\/code><\/a>(*, truthy, falsy, **kwargs)<\/td>\u5e03\u5c14\u578b<\/td><\/tr>
    fields.Float<\/code><\/a>(*, allow_nan, as_string, **kwargs)<\/td>\u6d6e\u70b9\u6570\u7c7b\u578b<\/td><\/tr>
    fields.DateTime<\/code><\/a>(format, **kwargs)<\/td>\u65e5\u671f\u65f6\u95f4\u7c7b\u578b<\/td><\/tr>
    fields.Time<\/code><\/a>(format, **kwargs)<\/td>\u65f6\u95f4\u7c7b\u578b<\/td><\/tr>
    fields.Date<\/code><\/a>(format, **kwargs)<\/td>\u65e5\u671f\u7c7b\u578b<\/td><\/tr>
    fields.Url<\/code><\/a>(*, relative, schemes, Set[str]]] = None, \u2026)<\/td>url\u7f51\u5740\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u81ea\u5e26url\u5730\u5740\u7684\u6821\u9a8c\u89c4\u5219<\/td><\/tr>
    fields.Email<\/code><\/a>(*args, **kwargs)<\/td>\u90ae\u7bb1\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u81ea\u5e26email\u5730\u5740\u7684\u6821\u9a8c\u89c4\u5219<\/td><\/tr>
    fields.IP<\/code><\/a>(*args[, exploded])<\/td>IP\u5730\u5740\u5b57\u7b26\u4e32\u7c7b\u578b<\/td><\/tr>
    fields.IPv4<\/code><\/a>(*args[, exploded])<\/td>IPv4\u5730\u5740\u5b57\u7b26\u4e32\u7c7b\u578b<\/td><\/tr>
    fields.IPv6<\/code><\/a>(*args[, exploded])<\/td>IPv6\u5730\u5740\u5b57\u7b26\u4e32\u7c7b\u578b<\/td><\/tr>
    fields.Method<\/code><\/a>(serialize, deserialize, **kwargs)<\/td>\u57fa\u4e8eSchema\u7c7b\u65b9\u6cd5\u8fd4\u56de\u503c\u7684\u5b57\u6bb5<\/td><\/tr>
    fields.Function<\/code><\/a>(serialize, Any], Callable[[Any, \u2026)<\/td>\u57fa\u4e8e\u51fd\u6570\u8fd4\u56de\u503c\u5f97\u5b57\u6bb5<\/td><\/tr>
    fields.Nested<\/code><\/a>(nested, type, str, Callable[[], \u2026)<\/td>\u5d4c\u5957\u7c7b\u578b\u6216\u5916\u952e\u7c7b\u578b<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    Schema\u6570\u636e\u7c7b\u578b\u7684\u5e38\u7528\u901a\u7528\u5c5e\u6027<\/strong><\/p>\n\n\n\n
    \u5c5e\u6027\u540d<\/th>\u63cf\u8ff0<\/th><\/tr><\/thead>
    default<\/strong><\/td>\u5e8f\u5217\u5316\u9636\u6bb5\u4e2d\u8bbe\u7f6e\u5b57\u6bb5\u7684\u9ed8\u8ba4\u503c<\/td><\/tr>
    missing<\/strong><\/td>\u53cd\u5e8f\u5217\u5316\u9636\u6bb5\u4e2d\u8bbe\u7f6e\u5b57\u6bb5\u7684\u9ed8\u8ba4\u503c<\/td><\/tr>
    validate<\/strong><\/td>\u53cd\u5e8f\u5217\u5316\u9636\u6bb5\u8c03\u7528\u7684\u5185\u7f6e\u6570\u636e\u9a8c\u8bc1\u5668\u6216\u8005\u5185\u7f6e\u9a8c\u8bc1\u96c6\u5408<\/td><\/tr>
    required<\/strong><\/td>\u53cd\u5e8f\u5217\u5316\u9636\u6bb5\u8c03\u7528\u7684\uff0c\u8bbe\u7f6e\u5f53\u524d\u5b57\u6bb5\u7684\u5fc5\u586b\u5b57\u6bb5<\/td><\/tr>
    allow_none<\/strong><\/td>\u53cd\u5e8f\u5217\u5316\u9636\u6bb5\u8c03\u7528\u7684\uff0c\u662f\u5426\u5141\u8bb8\u4e3a\u7a7a<\/td><\/tr>
    load_only<\/strong><\/td>\u662f\u5426\u5728\u53cd\u5e8f\u5217\u5316\u9636\u6bb5\u624d\u4f7f\u7528\u5230\u5f53\u524d\u5b57\u6bb5\uff0c\u76f8\u5f53\u4e8edrf\u6846\u67b6\u7684write_only<\/td><\/tr>
    dump_omly<\/strong><\/td>\u662f\u5426\u5728\u5e8f\u5217\u5316\u9636\u6bb5\u624d\u4f7f\u7528\u5230\u5f53\u524d\u5b57\u6bb5\uff0c\u76f8\u5f53\u4e8edrf\u6846\u67b6\u7684read_only<\/td><\/tr>
    error_messages<\/strong><\/td>\u4f7f\u7528\u6821\u9a8c\u503cvalidate\u9009\u9879\u4ee5\u540e\u8bbe\u7f6e\u7684\u9519\u8bef\u63d0\u793a\uff0c\u5b57\u5178\u7c7b\u578b\uff0c\u53ef\u4ee5\u7528\u6765\u66ff\u4ee3\u9ed8\u8ba4\u7684\u5b57\u6bb5\u5f02\u5e38\u63d0\u793a\u8bed\uff0c\u683c\u5f0f\uff1a error_messages={\u201crequired\u201d: \u201c\u7528\u6237\u540d\u4e3a\u5fc5\u586b\u9879\u3002\u201d}<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \u6784\u9020\u5668\u5d4c\u5957\u4f7f\u7528<\/h4>\n\n\n\n
    from datetime import datetime
    \u200b
    from flask import Flask
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/yingming?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    app.config[\"SQLALCHEMY_ECHO\"] = True
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \u200b
    \"\"\"\u6a21\u4effORM\u7684\u6a21\u578b\"\"\"
    class Model(object):
        pass
    \u200b
    class User(Model):
        def __init__(self, name, email):
            self.name = name
            self.email = email
            self.created_at = datetime.now()
            self.books = []    # \u7528\u6765\u4ee3\u66ffMySQL\u4e2d\u7684\u5916\u68c0\u5173\u7cfb\uff0c\u5b9e\u73b01\u5bf9\u591a\u6216\u591a\u5bf9\u591a
            self.friends = []  # \u7528\u6765\u4ee3\u66ffMySQL\u4e2d\u7684\u5916\u68c0\u5173\u7cfb\uff0c\u5b9e\u73b0\u81ea\u5173\u8054
    \u200b
    \u200b
    class Book(Model):
        def __init__(self, title, author):
            self.title = title
            self.author = author  # \u7528\u6765\u4ee3\u66ffMySQL\u4e2d\u7684\u5916\u952e\u5173\u7cfb\uff0c1\u5bf91
    \u200b
    \"\"\"\u5e8f\u5217\u5316\u5668\"\"\"
    from marshmallow import Schema, fields
    \u200b
    \u200b
    class UserSchema(Schema):
        \"\"\"\u7528\u6237\u7684\u5e8f\u5217\u5316\u5668\"\"\"
        name = fields.String()
        email = fields.Email()
        \"\"\"1\u5bf9\u591a\uff0c\u591a\u5bf9\u591a\"\"\"
        # \u5728fields.Nested\u5916\u56f4\u5305\u88f9\u4e00\u4e2aList\u5217\u8868\u5b57\u6bb5\uff0c\u5219\u53ef\u4ee5\u8fd4\u56de\u591a\u4e2a\u7ed3\u679c\u4e86\u3002exclude\u8868\u793a\u6392\u9664
        # books = fields.List(fields.Nested(lambda: BookSchema(exclude=[\"author\"])))
        # \u7b80\u5199\u65b9\u5f0f:
        books = fields.Nested(lambda : BookSchema(many=True, exclude=[\"author\"]))
        \"\"\"\u81ea\u5173\u8054\"\"\"
        # \u81ea\u5173\u8054\u5c31\u662f\u4e00\u4e2a\u6a21\u578b\u4e2d\u65e2\u5b58\u5728\u4e3b\u952e\u5173\u7cfb\uff0c\u4e5f\u5b58\u5728\u5916\u952e\u5173\u7cfb\u7684\u60c5\u51b5
        # \u65b9\u5f0f1\uff1a\u4f7f\u7528\u81ea\u8eab\"self\"\u4f5c\u4e3a\u5916\u952e\u7684\u65b9\u5f0f\uff0c\u5e76\u53ef\u4ee5\u6307\u5b9a\u5e8f\u5217\u5316\u6a21\u578b\u7684\u591a\u4e2a\u5b57\u6bb5
        # friends = fields.Nested(lambda: \"self\", only=(\"name\", \"email\", \"books\"), many=True)
        # \u65b9\u5f0f2\uff1a\u4f7f\u7528Pluck\u5b57\u6bb5\u53ef\u4ee5\u7528\u5355\u4e2a\u503c\u6765\u66ff\u6362\u5d4c\u5957\u7684\u6570\u636e\uff0c\u53ea\u53ef\u4ee5\u5f97\u5230\u6a21\u578b\u7684\u5355\u4e2a\u5b57\u6bb5\u503c
        friends = fields.Pluck(lambda: \"self\", \"name\", many=True)
    \u200b
    class BookSchema(Schema):
        \"\"\"\u56fe\u4e66\u7684\u5e8f\u5217\u5316\u5668\"\"\"
        title = fields.String()
        author = fields.Nested(lambda: UserSchema(exclude=[\"books\"]))
    \u200b
    @app.route(\"\/1\")
    def index1():
        \"\"\"\u6784\u9020\u5668\u5d4c\u5957\u4f7f\u7528\"\"\"
        # \u5047\u8bbe\u6839\u636e\u5f53\u524d\u4f5c\u8005\uff0c\u67e5\u627e\u5bf9\u5e94\u7684\u4f5c\u8005\u53d1\u5e03\u7684\u56fe\u4e66\u5217\u8868
        user0 = User(name=\"\u5357\u6d3e\u4e09\u53d4\", email=\"sanshu@163.com\")
    \u200b
        book1 = Book(title=\"\u76d7\u5893\u7b14\u8bb01\", author=user0)
        book2 = Book(title=\"\u76d7\u5893\u7b14\u8bb02\", author=user0)
        book3 = Book(title=\"\u76d7\u5893\u7b14\u8bb03\", author=user0)
        user0.books = [book1, book2, book3]
    \u200b
        us = UserSchema()
        result = us.dump(user0)
        print(result)
    \u200b
        bs = BookSchema()
        result = bs.dump([book1, book2, book3], many=True)
        print(result)
    \u200b
        return \"ok\"
    \u200b
    \u200b
    @app.route(\"\/2\")
    def index2():
        \"\"\"\u81ea\u5173\u8054\"\"\"
        user0 = User(name=\"\u5357\u6d3e\u4e09\u53d4\", email=\"sanshu@163.com\")
        user1 = User(name=\"\u5218\u6148\u6b23\", email=\"sanshu@163.com\")
        user2 = User(name=\"\u5929\u4e0b\u9738\u5531\", email=\"sanshu@163.com\")
        user0.friends = [user1, user2]
    \u200b
        us = UserSchema()
        result = us.dump(user0)
        print(result)
    \u200b
        return \"ok\"
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True, port=5555)<\/pre>\n\n\n\n
    \u57fa\u4e8eSchema\u5b8c\u6210\u6570\u636e\u53cd\u5e8f\u5217\u5316\u8f6c\u6362<\/h3>\n\n\n\n
    \u4ee3\u7801\uff1a<\/p>\n\n\n\n
    import re
    from flask import Flask
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/yingming?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    app.config[\"SQLALCHEMY_ECHO\"] = True
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \"\"\"\u5e8f\u5217\u5316\u5668\"\"\"
    from marshmallow import Schema, fields, validate, ValidationError
    \"\"\"
    validate \u662fmarshMallow\u5185\u7f6e\u6821\u9a8c\u5668\u6a21\u5757\uff0c\u63d0\u4f9b\u4e86\u90e8\u5206\u5185\u7f6e\u5199\u597d\u7684\u9a8c\u8bc1\u89c4\u5219\u3002
    validate.Length \u5b57\u7b26\u4e32\u957f\u5ea6\u9a8c\u8bc1\uff0c\u6216\u8005\u6587\u4ef6\u5185\u5bb9\u957f\u5ea6\u9a8c\u8bc1
    validate.Range  \u6570\u503c\u8303\u56f4\u9a8c\u8bc1
    validate.Regexp \u6b63\u5219\u9a8c\u8bc1\uff0c\u5e95\u5c42\u4f7f\u7528\u7684\u662fpython\u5185\u7f6e\u7684re\u6a21\u5757
    validate.OneOf  \u9009\u9879\u53d6\u503c\uff0c\u901a\u8fc7choices\u9009\u9879\u6307\u5b9a\u503c\u53ea\u80fd\u662f\u5176\u4e2d\u4e00\u4e2a
    validate.Email    \u90ae\u7bb1\u89c4\u5219\u6821\u9a8c\uff0c\u5e95\u5c42\u5b9e\u9645\u4e0a\u5c31\u662f\u4e00\u4e2a\u90ae\u7bb1\u7684\u6b63\u5219\u6821\u9a8c
    validate.URL      \u7f51\u5740\u89c4\u5219\u6821\u9a8c\uff0c\u5e95\u5c42\u5b9e\u9645\u4e0a\u5c31\u662f\u4e00\u4e2a\u7f51\u5740\u7684\u6b63\u5219\u6821\u9a8c
    validate.Equal    \u5224\u65ad\u662f\u5426\u4e0e\u6307\u5b9a\u7684\u503c\u76f8\u7b49
    \"\"\"
    \u200b
    class UserSchema(Schema):
        \"\"\"\u7528\u6237\u7684\u5e8f\u5217\u5316\u5668\"\"\"
        # required = True, \u8bbe\u7f6e\u5f53\u524d\u5b57\u6bb5\u4e3a\u5fc5\u586b\u9879
        name = fields.String(required=True, validate=validate.Length(min=3, max=16, error=\"\u7528\u6237\u540d\u6709\u8bef\uff01name\u5fc5\u987b\u5728{min}~{max}\u4e2a\u5b57\u7b26\u957f\u5ea6\u4e4b\u95f4\"))
        age = fields.Integer(validate=validate.Range(min=12, max=55, error=\"\u7528\u6237\u5e74\u9f84\u5fc5\u987b\u5728{min}~{max}\u5c81\u4e4b\u95f4!\"))
        role = fields.String(validate=validate.OneOf(choices=[\"\u8001\u5e08\", \"\u5b66\u751f\", \"\u8def\u4eba\"], error=\"\u8eab\u4efd\u53ea\u80fd\u5728{choices}\u4e2d\u9009\u62e9\u5176\u4e2d\u4e00\u4e2a\uff01\"))
        email = fields.Email(validate=validate.Email(error=\"\u90ae\u4ef6\u683c\u5f0f\u6709\u8bef\uff01\uff01\"))
        mobile = fields.String(validate=validate.Regexp(regex=\"1[3-9]\\d{9}\", error=\"\u624b\u673a\u53f7\u683c\u5f0f\u6709\u8bef\uff01\"))
    \u200b
    \u200b
    @app.route(\"\/1\")
    def index1():
        \"\"\"\u53cd\u5e8f\u5217\u5316\"\"\"
        # \u6a21\u62df\u5ba2\u6237\u7aef\u63d0\u4ea4\u8fc7\u6765\u7684\u6570\u636e
        user_data = {\"name\": \"xi\",\"role\": \"teacher\", \"email\": \"ronnie@stones.com\", \"age\": 12, \"mobile\": \"13311234455\"}
        us = UserSchema()
        # try:
        #     # \u6821\u9a8c\u4e00\u4e2a\u6570\u636e
        #     result = us.load(user_data)
        #     print(\"\u6821\u9a8c\u901a\u8fc7\uff0c\u6821\u9a8c\u7ed3\u679cresult=\", result)
        # except ValidationError as e:
        #     return f\"\u6821\u9a8c\u5931\u8d25\uff1a{e}\"
    \u200b
        data_list = [user_data, user_data, user_data]
        try:
            # \u6821\u9a8c\u591a\u4e2a\u6570\u636e
            result = us.load(data_list, many=True)
            print(\"\u6821\u9a8c\u901a\u8fc7\uff0c\u6821\u9a8c\u7ed3\u679cresult=\", result)
        except ValidationError as e:
            return f\"\u6821\u9a8c\u5931\u8d25\uff1a{e}\"
    \u200b
        return \"ok\"
    \u200b
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True, port=5555)
    \u200b<\/pre>\n\n\n\n
    \u57fa\u4e8e\u5185\u7f6e\u9a8c\u8bc1\u5668\u8fdb\u884c\u6570\u636e\u9a8c\u8bc1<\/h4>\n\n\n\n
    \u5185\u7f6e\u9a8c\u8bc1\u5668<\/th>\u63cf\u8ff0<\/th><\/tr><\/thead>
    validate.Email<\/code><\/a>(*, error)<\/td>\u90ae\u7bb1\u9a8c\u8bc1<\/td><\/tr>
    validate.Equal<\/code><\/a>(comparable, *, error)<\/td>\u5224\u65ad\u503c\u662f\u5426\u76f8\u7b49<\/td><\/tr>
    validate.Length<\/code><\/a>(min, max, *, equal, error)<\/td>\u503c\u957f\u5ea6\/\u5927\u5c0f\u9a8c\u8bc1<\/td><\/tr>
    validate.OneOf<\/code><\/a>(choices, labels, *, error)<\/td>\u9009\u9879\u9a8c\u8bc1<\/td><\/tr>
    validate.Range<\/code><\/a>([min, max])<\/td>\u8303\u56f4\u9a8c\u8bc1<\/td><\/tr>
    validate.Regexp<\/code><\/a>(regex, bytes, Pattern][, flags])<\/td>\u6b63\u5219\u9a8c\u8bc1<\/td><\/tr>
    validate.URL<\/code><\/a>(*, relative, schemes, Set[str]]] = None, \u2026)<\/td>\u9a8c\u8bc1\u662f\u5426\u4e3aURL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \u4ee3\u7801\uff1a<\/p>\n\n\n\n
    from marshmallow import Schema, fields, validate, ValidationError
    class UserSchema(Schema):
        name = fields.Str(validate=validate.Length(min=1))
        permission = fields.Str(validate=validate.OneOf([\"read\", \"write\", \"admin\"]))
        age = fields.Int(validate=validate.Range(min=18, max=40))
    \u200b
    if __name__ == '__main__':
        data = {\"name\": \"\", \"permission\": \"hello\", \"age\": 71}
        try:
            UserSchema().load(data)
        except ValidationError as err:
            pprint(err.messages)<\/pre>\n\n\n\n
    \u53cd\u5e8f\u5217\u5316\u65f6\u5bf9\u6307\u5b9a\u90e8\u5206\u5b57\u6bb5\u5ffd\u7565\u4e0d\u6821\u9a8c<\/h4>\n\n\n\n
    import re
    from flask import Flask
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/yingming?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    app.config[\"SQLALCHEMY_ECHO\"] = True
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \"\"\"\u5e8f\u5217\u5316\u5668\"\"\"
    from marshmallow import Schema, fields, validate, ValidationError
    \u200b
    class UserSchema(Schema):
        \"\"\"\u7528\u6237\u7684\u5e8f\u5217\u5316\u5668\"\"\"
        name = fields.String(required=True, validate=validate.Length(min=3, max=16, error=\"\u7528\u6237\u540d\u6709\u8bef\uff01name\u5fc5\u987b\u5728{min}~{max}\u4e2a\u5b57\u7b26\u957f\u5ea6\u4e4b\u95f4\"))
        age = fields.Integer(required=True)
        avatar = fields.String(required=True, error_messages={\"required\": \"avatar\u5fc5\u987b\u586b\u5199\uff01\"})
    \u200b
    @app.route(\"\/1\")
    def index1():
        \"\"\"\u53cd\u5e8f\u5217\u5316\u65f6\u5bf9\u90e8\u5206\u5b57\u6bb5\u8fdb\u884c\u5ffd\u7565\u4e0d\u6821\u9a8c\"\"\"
        # \u6a21\u62df\u5ba2\u6237\u7aef\u63d0\u4ea4\u7684\u6570\u636e
        user_data = {\"name\": \"xiaoming\", \"age\": 12}
        us = UserSchema()
        result = us.load(user_data, partial=[\"avatar\",])
        print(result)
        return \"ok\"
    \u200b
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True, port=5555)
    \u200b<\/pre>\n\n\n\n
    \u8bbe\u7f6e\u6307\u5b9a\u5b57\u6bb5\u53ea\u5728\u5e8f\u5217\u5316\u6216\u53cd\u5e8f\u5217\u5316\u9636\u6bb5\u624d\u542f\u7528<\/h4>\n\n\n\n
    \u5c31\u662f\u8bbe\u7f6e\u5e8f\u5217\u5316\u5668\u4e2d\u7684\u5b57\u6bb5\u53ea\u8bfb(dump_only\uff0c\u76f8\u5f53\u4e8edrf\u7684read_only)\u6216\u53ea\u5199(load_only\uff0c\u76f8\u5f53\u4e8edrf\u7684write_only)<\/p>\n\n\n\n
    import re
    from datetime import datetime
    from flask import Flask
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/yingming?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    app.config[\"SQLALCHEMY_ECHO\"] = True
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \"\"\"\u6a21\u578b\"\"\"
    class Model(object):
        pass
    \u200b
    class User(Model):
        def __init__(self, username, password):
            self.username = username
            self.password = password
            self.created_time = datetime.now()
    \u200b
    \"\"\"\u5e8f\u5217\u5316\u5668\"\"\"
    from marshmallow import Schema, fields, validate, ValidationError
    class UserSchema(Schema):
        username = fields.String()
        password = fields.String(required=True, load_only=True)  # \u76f8\u5f53\u4e8e\u53ea\u5199\u5b57\u6bb5 \"write-only\"
        created_time = fields.DateTime(dump_only=True) # \u76f8\u5f53\u4e8e\u53ea\u8bfb\u5b57\u6bb5 \"read-only\"
    \u200b
    @app.route(\"\/1\")
    def index1():
        \"\"\"\u8bbe\u7f6e\u6307\u5b9a\u5b57\u6bb5\u53ea\u80fd\u7528\u4e8e\u5e8f\u5217\u5316\u6216\u53cd\u5e8f\u5217\u5316\u4e2d\"\"\"
        # \u53cd\u5e8f\u5217\u5316\u9636\u6bb5
        # user_data = {\"username\": \"xiaoming\", \"password\": \"123456\"}
        # us = UserSchema()
        # result = us.load(user_data)
    \u200b
        # \u5e8f\u5217\u5316\u9636\u6bb5
        user = User(username=\"xiaohong\", password=\"123456\")
        us = UserSchema()
        result = us.dump(user)
        print(result)
    \u200b
        return \"ok\"
    \u200b
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True, port=5555)
    \u200b<\/pre>\n\n\n\n
    MarshMallow\u63d0\u4f9b\u7684\u94a9\u5b50\u65b9\u6cd5<\/h4>\n\n\n\n
    marshmallow\u63d0\u4f9b\u4e866\u4e2a\u94a9\u5b50\u5728\u53cd\u5e8f\u5217\u5316\u6216\u8005\u5e8f\u5217\u5316\u9636\u6bb5\u65f6\u81ea\u52a8\u6267\u884c\uff0c\u8fd9\u4e9b\u94a9\u5b50\u90fd\u662f\u4ee5\u88c5\u9970\u5668\u7684\u5f62\u5f0f\u63d0\u4f9b\u51fa\u6765\u7684\u3002<\/p>\n\n\n\n
    # \u5e8f\u5217\u5316\u4e4b\u524d\u6267\u884c\u7684\u94a9\u5b50\u65b9\u6cd5
    pre_dump([fn\uff0cpass_many]) \u6ce8\u518c\u8981\u5728\u5e8f\u5217\u5316\u5bf9\u8c61\u4e4b\u524d\u8c03\u7528\u7684\u65b9\u6cd5\uff0c\u5b83\u4f1a\u5728\u5e8f\u5217\u5316\u5bf9\u8c61\u4e4b\u524d\u88ab\u8c03\u7528\u3002
    # \u5e8f\u5217\u5316\u4e4b\u540e\u6267\u884c\u7684\u94a9\u5b50\u65b9\u6cd5
    post_dump([fn\uff0cpass_many\uff0cpass_original]) \u6ce8\u518c\u8981\u5728\u5e8f\u5217\u5316\u5bf9\u8c61\u540e\u8c03\u7528\u7684\u65b9\u6cd5\uff0c\u5b83\u4f1a\u5728\u5bf9\u8c61\u5e8f\u5217\u5316\u540e\u88ab\u8c03\u7528\u3002
    \u200b
    # \u53cd\u5e8f\u5217\u5316\u4e4b\u524d\u6267\u884c\u7684\u94a9\u5b50\u65b9\u6cd5
    pre_load([fn\uff0cpass_many]) \u5728\u53cd\u5e8f\u5217\u5316\u5bf9\u8c61\u4e4b\u524d\uff0c\u6ce8\u518c\u8981\u8c03\u7528\u7684\u65b9\u6cd5\uff0c\u5b83\u4f1a\u5728\u9a8c\u8bc1\u6570\u636e\u4e4b\u524d\u8c03\u7528
    # \u53cd\u5e8f\u5217\u5316\u4e4b\u540e\u6267\u884c\u7684\u94a9\u5b50\u65b9\u6cd5
    post_load([fn\uff0cpass_many\uff0cpass_original]) \u6ce8\u518c\u53cd\u5e8f\u5217\u5316\u5bf9\u8c61\u540e\u8981\u8c03\u7528\u7684\u65b9\u6cd5\uff0c\u5b83\u4f1a\u5728\u9a8c\u8bc1\u6570\u636e\u4e4b\u540e\u88ab\u8c03\u7528\u3002
    \u200b
    # \u6821\u9a8c\u6307\u5b9a\u5b57\u6bb5\u7684\u88c5\u9970\u5668\uff0c\u76f8\u5f53\u4e8edrf\u7684 \u5355\u5b57\u6bb5\u6821\u9a8c validate_<\u5b57\u6bb5\u540d>(data)
    validates(field_name)
    \u200b
    # \u6821\u9a8c\u6574\u4e2a\u6784\u9020\u5668\u4e2d\u6240\u6709\u6570\u636e\u7684\u88c5\u9970\u5668\uff0c\u76f8\u5f53\u4e8edrf\u7684\u5168\u5b57\u6bb5\u6821\u9a8c validate(data)
    validates_schema([fn, pass_many, ...])<\/pre>\n\n\n\n
    import re
    from datetime import datetime
    from flask import Flask, request
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/yingming?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    app.config[\"SQLALCHEMY_ECHO\"] = True
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \u200b
    \"\"\"\u6a21\u578b\"\"\"
    class Model(object):
        pass
    \u200b
    \u200b
    class User(Model):
        def __init__(self, username, password, avatar):
            self.username = username
            self.password = password
            self.avatar = avatar
            self.created_time = datetime.now()
            self.views_count = 0
    \u200b
        def __str__(self):
            return f\"<{self.__class__.__name__} [{self.username}]>\"
    \u200b
    \u200b
    \"\"\"\u5e8f\u5217\u5316\u5668\"\"\"
    from marshmallow import Schema, fields, validate, ValidationError, \\
        pre_dump, pre_load, post_dump, post_load, validates, validates_schema
    from werkzeug.security import generate_password_hash, check_password_hash
    \u200b
    \u200b
    class UserSchema(Schema):
        username = fields.String()
        password = fields.String(required=True, load_only=True)  # \u76f8\u5f53\u4e8e\u53ea\u5199\u5b57\u6bb5 \"write-only\"
        re_password = fields.Str(required=True)
        created_time = fields.DateTime(dump_only=True)  # \u76f8\u5f53\u4e8e\u53ea\u8bfb\u5b57\u6bb5 \"read-only\"
        avatar = fields.String()
    \u200b
        # # pass_many \u8868\u793a\u662f\u5426\u63a5\u53d7\u4f20\u9012\u8fdb\u6765\u7684many\u53c2\u6570
        # @pre_dump(pass_many=True)
        # def pre_dump(self, instance, many, **kwargs):
        #     \"\"\"\u5e8f\u5217\u5316\u4e4b\u524d\u81ea\u52a8\u6267\u884c\u7684\u94a9\u5b50\u51fd\u6570\"\"\"
        #     print(\"\u5e8f\u5217\u5316\u4e4b\u524d\uff0cdata\u662f\u6a21\u578b\u5bf9\u8c61\uff0c\u5bf9\u670d\u52a1\u7aef\u8981\u8fd4\u56de\u7ed9\u5ba2\u6237\u7aef\u7684\u6570\u636e\u8fdb\u884c\u9884\u5904\u7406-1\")
        #     instance.avatar = f\"\/\/{request.environ['HTTP_HOST']}{instance.avatar}\"
        #     # \u6b64\u5904\u53ef\u4ee5\u8c03\u7528\u6a21\u578b\u5bf9\u8c61\uff0c\u4fdd\u5b58\u6216\u64cd\u4f5c\u6a21\u578b\u6570\u636e\uff0c\u4fdd\u5b58\u5230\u6570\u636e\u5e93
        #     instance.views_count = instance.views_count+1
        #     return instance
    \u200b
        # @post_dump(pass_many=True)
        # def post_dump(self, data, many, **kwargs):
        #     \"\"\"\u5e8f\u5217\u5316\u4e4b\u540e\u81ea\u52a8\u6267\u884c\u7684\u94a9\u5b50\u51fd\u6570\"\"\"
        #     print(\"\u5e8f\u5217\u5316\u4e4b\u540e\uff0cdata\u662f\u5b57\u5178\uff0c\u5bf9\u670d\u52a1\u7aef\u8981\u8fd4\u56de\u7ed9\u5ba2\u6237\u7aef\u7684\u6570\u636e\u8fdb\u884c\u9884\u5904\u7406-2\")
        #     # \u6b64\u5904\u65e0\u6cd5\u8c03\u7528\u5230\u6a21\u578b\u5bf9\u8c61
        #     data[\"test\"] = \"abc\"
        #     return data
    \u200b
        # @pre_load(pass_many=True)
        # def pre_load(self, data, *args, **kwargs):
        #     \"\"\"\u53cd\u5e8f\u5217\u5316\u4e4b\u524d\uff0c\u6821\u9a8c\u6570\u636e\u4e4b\u524d\u7684\u94a9\u5b50\u64cd\u4f5c\"\"\"
        #     print(\"\u53cd\u5e8f\u5217\u5316\u4e4b\u524d\uff0cdata\u662f\u5b57\u5178\uff0c\u5bf9\u5ba2\u6237\u7aef\u63d0\u4ea4\u7684\u6570\u636e\u8fdb\u884c\u6821\u9a8c\u524d\u7684\u8c03\u6574\u6216\u4fee\u6539-1\")
        #     print(f\"\u4fdd\u5b58\u4e0a\u4f20\u6587\u4ef6\uff1adata['avatar']={data['avatar']}\")
        #     data[\"avatar\"] = f\"\/\/{request.environ['HTTP_HOST']}{data['avatar']}\"
        #     return data
    \u200b
        @post_load(pass_many=True)
        def post_load(self, data, *args, **kwargs):
            \"\"\"\u53cd\u5e8f\u5217\u5316\u4e4b\u540e\uff0c\u6821\u9a8c\u6570\u636e\u4e4b\u540e\u7684\u94a9\u5b50\u64cd\u4f5c\"\"\"
            # print(\"\u53cd\u5e8f\u5217\u5316\u4e4b\u524d\uff0cdata\u662f\u5b57\u5178\uff0c\u4e00\u822c\u5728\u8fd9\u4e2a\u94a9\u5b50\u91cc\u9762\u8fdb\u884c\u6570\u636e\u5e93\u7684\u64cd\u4f5c\uff0c\u628a\u5b57\u5178\u8f6c\u6362\u6210\u6a21\u578b-2\")
            data.pop(\"re_password\") # \u4f8b\u5982\u5220\u9664\u4e0d\u5fc5\u8981\u7684\u5b57\u6bb5
            data[\"password\"] = generate_password_hash(password=data[\"password\"]) # \u4f8b\u5982\u5bc6\u7801\u52a0\u5bc6\uff0c
            user = User(**data)
            return user
    \u200b
        # @validates(field_name=\"username\")
        # def validates1(self, data):
        #     \"\"\"\u5355\u5b57\u6bb5\u6821\u9a8c\uff1a\u6821\u9a8c\u7684\u5b57\u6bb5\u540d\u5fc5\u987b\u5199\u5728\u88c5\u9970\u5668\uff0c\u4e0e\u51fd\u6570\u540d\u6ca1\u6709\u4ec0\u4e48\u5173\u7cfb1\"\"\"
        #     print(f\"username={data}\")
        #     if data == \"root\":
        #         raise ValidationError(message=\"\u7528\u6237\u540d\u4e0d\u80fd\u53ebroot\uff01\uff01\uff01\", field_name=\"username\")
        #     return data
        #
        # @validates(field_name=\"avatar\")
        # def validates2(self, data):
        #     \"\"\"\u5355\u5b57\u6bb5\u6821\u9a8c\uff1a\u6821\u9a8c\u7684\u5b57\u6bb5\u540d\u5fc5\u987b\u5199\u5728\u88c5\u9970\u5668\uff0c\u4e0e\u51fd\u6570\u540d\u6ca1\u6709\u4ec0\u4e48\u5173\u7cfb2\"\"\"
        #     print(f\"avatar={data}\")
        #     type_list = [\"png\", \"jpeg\", \"jpg\"]
        #     if data.split(\".\")[-1] not in type_list:
        #         raise ValidationError(message=f\"\u5934\u50cf\u683c\u5f0f\u6709\u8bef\uff01\u53ea\u5141\u8bb8\u4f7f\u7528{type_list}\u4e4b\u4e2d\u7684\u4e00\u79cd\u683c\u5f0f\uff01\uff01\uff01\uff01\", field_name=\"username\")
        #     return data
    \u200b
        @validates_schema(pass_many=True)
        def validates_schema(self, data, *args, **kwargs):
            \"\"\"\u5168\u5b57\u6bb5\u6821\u9a8c\uff1a\"\"\"
            print(f\"data={data}\")
            # \u591a\u4e2a\u5b57\u6bb5\u4e4b\u95f4\u8fdb\u884c\u76f8\u4e92\u6821\u9a8c\uff0c\u4f8b\u5982\uff1a\u5bc6\u7801\u4e0e\u786e\u8ba4\u5bc6\u7801
            if data[\"password\"] != data[\"re_password\"]:
                raise ValidationError(message=\"\u5bc6\u7801\u4e0e\u786e\u8ba4\u5bc6\u7801\u4e0d\u4e00\u81f4\uff01\", field_name=\"password\")
            return data
    \u200b
    @app.route(\"\/1\")
    def index1():
        \"\"\"marshmallow\u63d0\u4f9b\u7684\u94a9\u5b50\u64cd\u4f5c\"\"\"
        # # \u6a21\u62df\u4ece\u6570\u636e\u5e93\u5f97\u5230\u7684\u6a21\u578b\u5bf9\u8c61
        # user = User(username=\"\u5c0f\u660e\", password=\"123456\", avatar=\"\/1.png\")
        # us = UserSchema()
        # result = us.dump(user)
        # print(result)
        # print(user.views_count)
    \u200b
        # \u6a21\u62df\u5ba2\u6237\u7aef\u63d0\u4ea4\u8fc7\u6765\u7684\u6570\u636e
        user_data = {\"username\": \"xiaohong\", \"password\": \"123456\", \"re_password\": \"1123456\", \"avatar\": \"2.gif\"}
        us = UserSchema()
        instance = us.load(user_data)
        print(instance.password)
    \u200b
        return \"ok\"
    \u200b
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True, port=5555)
    \u200b<\/pre>\n\n\n\n
    \u6a21\u578b\u6784\u9020\u5668(ModelSchema)<\/h2>\n\n\n\n
    \u7c7b\u4f3cdrf\u63d0\u4f9b\u7684ModelSerializer\uff0cModelSchema\u4e3b\u8981\u662f\u65b9\u4fbf\u5f00\u53d1\u8005\u53ef\u4ee5\u65b9\u4fbf\u7684\u64cd\u4f5c\u6570\u636e\u5e93\u7684\u3002<\/p>\n\n\n\n
    \u5b98\u65b9\u63d0\u4f9b\u4e86SQLAlchemyAutoSchema<\/strong>\u548cSQLAlchemySchema<\/strong>\u8fd92\u4e2a\u6a21\u578b\u6784\u9020\u7c7b\u63d0\u4f9b\u7ed9\u6211\u4eec\u7528\u4e8e\u7f16\u5199\u6a21\u578b\u6784\u9020\u5668\u3002<\/p>\n\n\n\n
    \u5b98\u65b9\u6587\u6863\uff1ahttps:\/\/github.com\/marshmallow-code\/marshmallow-sqlalchemy<\/a><\/p>\n\n\n\n
    \nhttps:\/\/marshmallow-sqlalchemy.readthedocs.io\/en\/latest\n<\/div><\/figure>\n\n\n\n
    SQLAlchemySchema<\/h3>\n\n\n\n
    import re
    from datetime import datetime
    from flask import Flask, request
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/yingming?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    app.config[\"SQLALCHEMY_ECHO\"] = True
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \u200b
    class User(db.Model):
        __tablename__ = \"tb_user\"
        id = db.Column(db.Integer, primary_key=True, comment=\"\u4e3b\u952eID\")
        username = db.Column(db.String(255), index=True, comment=\"\u7528\u6237\u540d\")
        password = db.Column(db.String(255), comment=\"\u767b\u5f55\u5bc6\u7801\")
        mobile = db.Column(db.String(15), index=True, comment=\"\u624b\u673a\u53f7\u7801\")
        sex = db.Column(db.Boolean, default=True, comment=\"\u6027\u522b\")
        email = db.Column(db.String(255), index=True, comment=\"\u90ae\u7bb1\")
        created_time = db.Column(db.DateTime, default=datetime.now, comment=\"\u521b\u5efa\u65f6\u95f4\")
        updated_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now, comment=\"\u66f4\u65b0\u65f6\u95f4\")
    \u200b
        def __repr__(self):
            return \"<%s: %s>\" % (self.__class__.__name__, self.username)
    \u200b
    \"\"\"\u6a21\u578b\u7c7b\u5e8f\u5217\u5316\u5668\"\"\"
    from marshmallow_sqlalchemy import SQLAlchemySchema, auto_field, fields
    from marshmallow import post_load
    \u200b
    \u200b
    class UserModelSchema(SQLAlchemySchema):
        \"\"\"
        SQLAlchemySchema\u63d0\u4f9b\u4e86\u4e00\u4e2aauto_field\u65b9\u6cd5\u53ef\u4ee5\u81ea\u52a8\u4ece\u6a21\u578b\u4e2d\u63d0\u53d6\u5f53\u524d\u5bf9\u5e94\u5b57\u6bb5\u58f0\u660e\u4fe1\u606f\u5230\u6784\u9020\u5668\u4e2d\uff0c
        \u4f46\u662f\uff0c\u6211\u4eec\u9700\u8981\u624b\u52a8\u58f0\u660e\u5e8f\u5217\u5316\u5668\u4e2d\u8c03\u7528\u7684\u54ea\u4e9b\u5b57\u6bb5\uff0c\u6bcf\u4e00\u4e2a\u90fd\u8981\u5199\u4e0a
        \"\"\"
        id = auto_field()
        username = auto_field()
        password = auto_field(load_only=True)
        mobile = auto_field()
        email = auto_field()
        created_time = auto_field()
        sex = auto_field()
    \u200b
        class Meta:
            model = User          # \u8bbe\u7f6e\u5f53\u524d\u5e8f\u5217\u5316\u5668\u7ed1\u5b9a\u64cd\u4f5c\u7684\u6a21\u578b\u5bf9\u8c61
            load_instance = True  # \u662f\u5426\u5728\u5e8f\u5217\u5316\u5668\u4e2d\u81ea\u52a8\u5b9e\u4f8b\u5316\u6a21\u578b\u5b9e\u4f8b\u5bf9\u8c61
    \u200b
    @app.route(\"\/1\")
    def index1():
        \"\"\"\u6a21\u578b\u7c7b\u6784\u9020\u5668\uff1aSQLAlchemySchema\"\"\"
        # # \u6a21\u62df\u5ba2\u6237\u7aef\u63d0\u4ea4\u7684\u6570\u636e
        # user_data1 = {'username': '\u5c0f\u660e', 'email': '123@qq.com',\"password\": \"123456\", 'sex': True, 'mobile': '13312345678'}
        # user_data2 = {'username': '\u5c0f\u7ea2', 'email': '456@qq.com',\"password\": \"123456\", 'sex': False, 'mobile': '13355545678'}
        # user1 = User(**user_data1)
        # user2 = User(**user_data2)
        # db.session.add_all([user1, user2])
        # db.session.commit()
    \u200b
        \"\"\"\u5e8f\u5217\u5316\u4e00\u4e2a\u6570\u636e\"\"\"
        # # \u8bfb\u53d6\u6570\u636e\u5e93\u4e2d\u7684\u7528\u6237
        # user = User.query.get(1)
        # us = UserModelSchema()
        # data = us.dump(user)
        # print(data)
    \u200b
        # \"\"\"\u5e8f\u5217\u5316\u591a\u4e2a\u6570\u636e\"\"\"
        # user_list = User.query.all()
        # us = UserModelSchema()
        # data = us.dump(user_list, many=True)
        # print(data)
    \u200b
        # \"\"\"\u53cd\u5e8f\u5217\u5316\u4e00\u4e2a\u6570\u636e\"\"\"
        # user_data = {'username': '\u5c0f\u8f89', 'email': '123@qq.com', \"password\": \"123456\", 'sex': True, 'mobile': '13312345678'}
        # us = UserModelSchema()
        # user = us.load(user_data, session=db.session)
        # db.session.add(user)
        # db.session.commit()
        # print(user)
    \u200b
        \"\"\"\u53cd\u5e8f\u5217\u5316\u591a\u4e2a\u6570\u636e\"\"\"
        user_data = {'username': '\u5c0f\u8f89', 'email': '123@qq.com', \"password\": \"123456\", 'sex': True, 'mobile': '13312345678'}
        us = UserModelSchema()
        user_list = us.load([user_data, user_data, user_data], session=db.session, many=True)
        db.session.add_all(user_list)
        db.session.commit()
        print(user_list)
    \u200b
    \u200b
    \u200b
        return \"ok\"
    \u200b
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True, port=5555)
    \u200b<\/pre>\n\n\n\n
    SQLAlchemyAutoSchema<\/h3>\n\n\n\n
    import re
    from datetime import datetime
    from flask import Flask, request
    from flask_sqlalchemy import SQLAlchemy
    from flask_marshmallow import Marshmallow
    \u200b
    \u200b
    app = Flask(__name__)
    app.config[\"DEBUG\"] = True
    app.config[\"SQLALCHEMY_DATABASE_URI\"]=\"mysql:\/\/root:123@127.0.0.1:3306\/yingming?charset=utf8mb4\"
    app.config[\"SQLALCHEMY_TRACK_MODIFICATIONS\"] = False
    app.config[\"SQLALCHEMY_ECHO\"] = True
    \u200b
    db = SQLAlchemy()
    db.init_app(app)
    \u200b
    ma = Marshmallow()
    ma.init_app(app)
    \u200b
    \u200b
    class User(db.Model):
        __tablename__ = \"tb_user\"
        id = db.Column(db.Integer, primary_key=True, comment=\"\u4e3b\u952eID\")
        username = db.Column(db.String(255), index=True, comment=\"\u7528\u6237\u540d\")
        password = db.Column(db.String(255), comment=\"\u767b\u5f55\u5bc6\u7801\")
        mobile = db.Column(db.String(15), index=True, comment=\"\u624b\u673a\u53f7\u7801\")
        sex = db.Column(db.Boolean, default=True, comment=\"\u6027\u522b\")
        email = db.Column(db.String(255), index=True, comment=\"\u90ae\u7bb1\")
        created_time = db.Column(db.DateTime, default=datetime.now, comment=\"\u521b\u5efa\u65f6\u95f4\")
        updated_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now, comment=\"\u66f4\u65b0\u65f6\u95f4\")
    \u200b
        def __repr__(self):
            return \"<%s: %s>\" % (self.__class__.__name__, self.username)
    \u200b
    \u200b
    \"\"\"\u6a21\u578b\u7c7b\u5e8f\u5217\u5316\u5668\"\"\"
    from marshmallow_sqlalchemy import SQLAlchemyAutoSchema, auto_field, fields
    from marshmallow import post_load
    \u200b
    \u200b
    class UserModelSchema(SQLAlchemyAutoSchema):
        password = auto_field(load_only=True)
    \u200b
        class Meta:
            model = User
            include_relationships = True  # \u8f93\u51fa\u6a21\u578b\u5bf9\u8c61\u65f6\u540c\u65f6\u5bf9\u5916\u952e\uff0c\u662f\u5426\u4e5f\u4e00\u5e76\u8fdb\u884c\u5904\u7406\uff0cTrue\u8868\u793a\u4e00\u5e76\u8fdb\u884c\u5e8f\u5217\u5316\u5668\uff0c\u7528\u4e8e\u9488\u5bf9\u5e8f\u5217\u5316\u5668\u5d4c\u5957\u8c03\u7528\u7684\u60c5\u51b5
            include_fk = True  # \u5e8f\u5217\u5316\u9636\u6bb5\u662f\u5426\u4e5f\u4e00\u5e76\u8fd4\u56de\u4e3b\u952e
            sqla_session = db.session  # \u6570\u636e\u5e93\u8fde\u63a5\u4f1a\u8bdd\u5bf9\u8c61\uff0c\u9488\u5bf9\u5728\u94a9\u5b50\u88c5\u9970\u5668\u4e2d\u5982\u679c\u5e0c\u671b\u8c03\u7528db\u6570\u636e\u5e93\u56de\u8bdd\u5bf9\u8c61\uff0c\u53ef\u4ee5\u5728\u6b64\u5904\u58f0\u660e\u5b8c\u6210\u4ee5\u540e\uff0c\u4f7f\u7528\u65f6\u901a\u8fc7sql_session\u76f4\u63a5\u8c03\u7528
            fields = [\"id\", \"username\", \"mobile\", \"email\", \"created_time\", \"sex\", \"password\"]
    \u200b
        @post_load(pass_many=True)
        def post_load(self, data, *args, **kwargs):
            if type(data) is list:
                \"\"\"\u6279\u91cf\u6dfb\u52a0\u6a21\u578b\"\"\"
                instance = []
                for item in data:
                    instance.append(self.Meta.model(**item))
                self.session.add_all(instance)
            else:
                \"\"\"\u5355\u4e2a\u6dfb\u52a0\u6a21\u578b\"\"\"
                instance = self.Meta.model(**data)
                self.session.add(instance)
            self.session.commit()
            return instance
    \u200b
    @app.route(\"\/1\")
    def index1():
        \"\"\"\u6a21\u578b\u7c7b\u6784\u9020\u5668\uff1aSQLAlchemyAutoSchema\"\"\"
        # \"\"\"\u5e8f\u5217\u5316\u4e00\u4e2a\u6570\u636e\"\"\"
        # user = User.query.get(1)
        # us = UserModelSchema()
        # data = us.dump(user)
        # print(data)
    \u200b
        # \"\"\"\u5e8f\u5217\u5316\u591a\u4e2a\u6570\u636e\"\"\"
        # user_list = User.query.all()
        # us = UserModelSchema()
        # data = us.dump(user_list, many=True)
        # print(data)
    \u200b
    \u200b
        \"\"\"\u53cd\u5e8f\u5217\u5316\u4e00\u4e2a\u6570\u636e\"\"\"
        user_data = {'email': '123@qq.com', 'username': 'xiaoming', 'sex': True, 'mobile': '13312345678', 'password': '56566666'}
        us = UserModelSchema()
        instance = us.load(user_data)
        print(instance)
    \u200b
        # \"\"\"\u53cd\u5e8f\u5217\u5316\u591a\u4e2a\u6570\u636e\"\"\"
        # user_data = {'email': '123@qq.com', 'username': 'xiaoming', 'sex': True, 'mobile': '13312345678', 'password': '56566666'}
        # us = UserModelSchema()
        # instance_list = us.load([user_data, user_data, user_data], many=True)
        # print(instance_list)
    \u200b
        return \"ok\"
    \u200b
    if __name__ == '__main__':
        with app.app_context():
            db.create_all()
        app.run(debug=True, port=5555)
    \u200b<\/pre>\n","protected":false},"excerpt":{"rendered":"
    \u5b98\u65b9\u6587\u6863\uff1ahttps:\/\/marshmallow.readthedocs.io\/en\/latest\/ Mars […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-21","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/22z.top\/index.php?rest_route=\/wp\/v2\/posts\/21","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/22z.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/22z.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/22z.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/22z.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=21"}],"version-history":[{"count":1,"href":"https:\/\/22z.top\/index.php?rest_route=\/wp\/v2\/posts\/21\/revisions"}],"predecessor-version":[{"id":22,"href":"https:\/\/22z.top\/index.php?rest_route=\/wp\/v2\/posts\/21\/revisions\/22"}],"wp:attachment":[{"href":"https:\/\/22z.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/22z.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/22z.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}