Guest User

Untitled

a guest
Dec 1st, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.69 KB | None | 0 0
  1. class MyEnum(enum.Enum):
  2.     one = "szt"
  3.     two = "kg"
  4.  
  5. class ProductTable(Base):
  6.     __tablename__ = 'product'
  7.     product_id = Column(Integer, primary_key=True)
  8.     product_name = Column(String(30))
  9.     product_quantity = Column(Integer)
  10.     product_type = Column(ENUM(MyEnum))
  11.     category_id = Column(Integer, ForeignKey('category.id'))
  12.     category = relationship("category", back_populates="product")
  13.     product_description = Column(String(255))
  14.    
  15. class CategoryTable(Base):
  16.     __tablename__ = 'category'
  17.     id = Column(Integer, primary_key=True)
  18.     category_name = Column(String(25))
  19.  
  20.     product = relationship("Main_Table", back_populates="category", uselist=False)
Advertisement
Add Comment
Please, Sign In to add comment