GitLocker: The Coding Marketplace

Description:

validatable 0.4.0

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.