Python-сообщество

 class Field(object):
    def __init__(self, name, column_type, primary_key, default):
        self.name = name
        self.column_type = column_type
        self.primary_key = primary_key
        self.default = default
    def __str__(self):
        return '<%s, %s, %s>' % (self.__class__.__name__, self.column_type, self.name)
class VarcharField(Field):
    def __init__(self,  name=None, primary_key=False, default=None, ddl='varchar(100)', max_len=4):
        super(VarcharField, self).__init__(name, ddl, primary_key, default)
        self.max_len = max_len
        self.field_type_sql = f'VARCHAR'
class OneToOneField(Field):
    def __init__(self, rel_class, name=None):
        super(OneToOneField, self).__init__(
            name, primary_key=False, default=0, column_type=None
        )
        self.rel_class = rel_class
class ForeignKey(Field):
    def __init__(self, model_class, name=None):
        self.column_type = "foreignkey"
        self.field_level = 1
        self.name = name
        self.model_class = model_class
    def field_sql(self, field_name):
        foreign_to = self.model_class.__name__.lower()
        return '"%s" integer NULL REFERENCES "%s" ("id")' % (field_name, foreign_to)

 @model(models.ID_MODEL)
class Person:
    @field(fields.STRING, empty=True)
    def name(self, val: str) -> str:
          pass   
    @field(fields.INT, null=False)
    def age(self, val: int) -> int:
          assert(10 < val < 150)
@model(models.ID_MODEL)
class Organization:
    @field(fields.STRING, empty=False, unique=True)
    def name(self, val: str) ->str:
          pass  
    
    @field(fields.ONE_TO_MANY, rely_to=Person) 
    def staff(self, val: Iterable[Person]) -> List[Person]:
         pass
with transaction() as t:
    person = new(Person)
    person.name = 'Ivan'
    person.age = 43
    organization = find_one(Organization).where(name='Vector')
    organization.staff.add(person)