使用SQLAlchemy进行简单验证 [英] Simple validation with SQLAlchemy

问题描述

我是sqlalchemy的新手，我正在尝试实现对模型字段的简单验证，这是Django ORM提供的(Integer，email等的最小和最大). SQLAlchemy可以立即进行此类字段验证吗? 顺便说一句，我在Flask中使用SQLAlchemy.

I'm new to sqlalchemy, and I'm trying to achieve simple validation of model's fields, as provided by Django ORM (min & max for Integer, email, ...). Can SQLAlchemy do this sort of field validations out of the box ? By the way, I'm using SQLAlchemy with Flask.

推荐答案

请参见简单验证器.示例代码摘录如下:

See Simple Validators in the documentation. Sample code extract below:

class EmailAddress(Base):
    __tablename__ = 'address'

    id = Column(Integer, primary_key=True)
    email = Column(String)

    @validates('email')
    def validate_email(self, key, address):
        assert '@' in address
        return address

这篇关于使用SQLAlchemy进行简单验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！