SQLAlchemy Validation Library.
This library supports validations based on the model class definition by using the Attribute Events .
Currently, this library supprts the following validations.
- Not Null Constraint
- Enum Constraint
- Type Constraint
- String Length Range Constraint
- RegExp Constraint
- Email Constraint
- Size Constraint
These validations don't have to the database connection, and you don't have to execute explicitly.
import re
import datetime
import sqlalchemy as sa
from sqlalchemy_validation import Model, Column
class Person(Model):
__tablename__ = 'person'
id = Column(sa.Integer, primary_key=True)
name = Column(sa.VARCHAR(20), length=(None, 15), unique=True, regexp=re.compile(r'[a-z0-9]*'))
age = Column(sa.Integer, size=(20, 40))
birth = Column(sa.DateTime, size=(None, datetime.now()), nullable=False)
email = Column(sa.VARCHAR(20), format='email') # require validate_email
try:
person = Person(id='foo')
except ValidationError as errors:
for column_names, error in errors.items():
print(column_names) # ("id",)
assert isinstance(error, InvalidTypeError)
person = Person()
try:
person.age = 10
except SizeError as e:
person.age # None
e.value # 10- Python 3
- SQLAlchemy
- validate_email(optional)
If you verify if email is valid, install validate_email.
$ pip install sqlalchemy_validation
This Library is distributed under the MIT license.