class MediaMixin(StandardMixin):
link = db.Column(db.String(255), nullable=False, unique=True)
path = db.Column(db.String(255), nullable=False, unique=True)
filename = db.Column(db.String(255))
def to_dict(self, *_, **__):
return ObjectDict(id=self.id, link=self.link)
class CatalogXMixin(CatalogMixin):
@declared_attr
def __table_args__(self):
return (db.UniqueConstraint("code", "type_id"), )
code = db.Column(db.String(20))
order_id = db.Column(db.Integer, index=True)
order_by = asc(order_id)
def __str__(self):
return f"<{self.code} - {self.label}>"
def to_dict(self, **kwargs):
return super().to_dict(code=self.code, orderId=self.order_id, **kwargs)
class UserMixin(StandardMixin):
_hasher = argon2
_password = db.Column("password", db.String(128), nullable=False)
email = db.Column(db.String(255), unique=True, nullable=False)
@hybrid_property
def password(self):
return self._password
@password.setter
def password(self, password):
self._password = self._hasher.generate_hash(password)
def check_password(self, password):
return self._hasher.verify_hash(self._password, password)
def to_dict(self, **_):
return ObjectDict(id=self.id, email=self.email)
class CatalogMixin(BaseMixin):
@declared_attr
def __table_args__(self):
return (db.UniqueConstraint("label", "type_id"), )
id = db.Column(db.Integer, primary_key=True)
label = db.Column(db.String(100))
type_id = db.Column(db.Integer)
description = db.Column(db.String(250))
def __str__(self):
return str(self.label)
def to_dict(self, **kwargs):
return ObjectDict(
id=self.id,
label=self.label,
description=self.description,
typeId=self.type_id,
**kwargs,
)
class ExtraMixin(BaseMixin):
_json_class = json
_extra = db.Column(db.Text())
@property
def extra(self):
return self._json_class.loads(self._extra) if self._extra else {}
@extra.setter
def extra(self, value):
self._extra = None
if value:
self._extra = self._json_class.dumps(value)
class StandardMixin(BaseMixin):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
created_at = db.Column(db.DateTime, server_default=func.now())
updated_at = db.Column(db.DateTime, onupdate=func.now())