Validatable
Data validation and SQL Toolkit using Python type hints.
Introduction
Validatable provides a single class definition for data validation and SQL table representation. It uses Pydantic and SQLAlchemy Core.
Getting Started
Installation
You can install Validatable like this:
pip install validatable
Simple Example
from datetime import datetime
from typing import Optional
from uuid import uuid4
from sqlalchemy.dialects.postgresql import dialect
from sqlalchemy.schema import CreateTable
from validatable import UUID4, BaseTable, EmailStr, Field, ForeignKey, MetaData
class Base(BaseTable):
metadata = MetaData()
class User(Base):
id: UUID4 = Field(sa_primary_key=True, default_factory=uuid4)
name: str
email: EmailStr
created_ts: datetime = Field(default_factory=datetime.now)
friends: Optional[UUID4] = Field(sa_fk=ForeignKey("user.id"))
ddl = CreateTable(User.__sa_table__).compile(dialect=dialect())
print(ddl)
# CREATE TABLE "user" (
# id UUID NOT NULL,
# name VARCHAR NOT NULL,
# email VARCHAR(320) NOT NULL,
# created_ts TIMESTAMP WITHOUT TIME ZONE,
# friends UUID,
# PRIMARY KEY (id),
# FOREIGN KEY(friends) REFERENCES "user" (id)
# )License
This project is licensed under the terms of the MIT license - see the LICENSE.txt file for details.
