mirror of
https://github.com/kennethreitz/pydantic.git
synced 2026-06-05 14:50:19 +00:00
Stephen Brown II
37 lines
916 B
Python
37 lines
916 B
Python
from typing import List
|
|
from sqlalchemy import Column, Integer, String
|
|
from sqlalchemy.dialects.postgresql import ARRAY
|
|
from sqlalchemy.ext.declarative import declarative_base
|
|
from pydantic import BaseModel, constr
|
|
|
|
Base = declarative_base()
|
|
|
|
|
|
class CompanyOrm(Base):
|
|
__tablename__ = 'companies'
|
|
id = Column(Integer, primary_key=True, nullable=False)
|
|
public_key = Column(String(20), index=True, nullable=False, unique=True)
|
|
name = Column(String(63), unique=True)
|
|
domains = Column(ARRAY(String(255)))
|
|
|
|
|
|
class CompanyModel(BaseModel):
|
|
id: int
|
|
public_key: constr(max_length=20)
|
|
name: constr(max_length=63)
|
|
domains: List[constr(max_length=255)]
|
|
|
|
class Config:
|
|
orm_mode = True
|
|
|
|
|
|
co_orm = CompanyOrm(
|
|
id=123,
|
|
public_key='foobar',
|
|
name='Testing',
|
|
domains=['example.com', 'foobar.com'],
|
|
)
|
|
print(co_orm)
|
|
co_model = CompanyModel.from_orm(co_orm)
|
|
print(co_model)
|