Source code for flaskapp.models.product_category

from flaskapp.database import Base
from sqlalchemy import Column, String, Integer, ForeignKey
from sqlalchemy.orm import relationship


class ProductCategoryModel(Base):
    """ORM class for product-category association objects."""
    __tablename__ = "product_category"

    product_id = Column(String(15), ForeignKey("product.id"), primary_key=True, autoincrement=False)
    category_id = Column(Integer, ForeignKey("category.id"), primary_key=True, autoincrement=False)
    category = relationship("CategoryModel", backref="product_category", uselist=False)

    def __repr__(self):
        """Returns a readable representation of a product-category association object."""
        return f"Product_Category('{self.product_id}', '{self.category_id})"