# _*_coding:utf-8_*_
from datetime import datetime, date
from typing import List, Optional
from sqlalchemy import Column, Integer, String,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(50), unique=True)
    domains = Column(ARRAY(String(100)))


class CompanyModel(BaseModel):
   
    public_key: constr(max_length=20)
    name: constr(max_length=50)
    domains: List[constr(max_length=100)]

    class Config:
        orm_mode = True


co_orm = CompanyOrm(
    id=123,
    public_key='foobar',
    name='Testing',
    domains=['example.com', 'foobar.com'],
)

print(CompanyModel.from_orm(co_orm))