PYTHON

sqlalchemy validation

class Article(Base):
    ...
    name = Column(Text, unique=True)
    ...

    @validates('name')
    def validate_name(self, key, value):
        assert value != ''
        return value

sqlalchemy validation at db level

class Article(Base):
    ...
    name = Column(Text, CheckConstraint('name!=""')
    ...