class Shop(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
products = db.relationship("Product", backref="shop_products", lazy=True)
sales = db.relationship("Sale", backref="shop_sales", lazy=True)
def __repr__(self):
return "<Shop %r>" % self.name
class ProductsSale(db.Model):
id = db.Column(db.Integer, primary_key=True)
quantity = db.Column(db.Integer)
sale_id = db.Column(db.Integer, db.ForeignKey("sale.id"), nullable=False)
product_id = db.Column(db.Integer,
db.ForeignKey("product.id"),
nullable=False)
def __repr__(self):
return "<ProductsSale %r>" % self.id
class Sale(db.Model):
id = db.Column(db.Integer, primary_key=True)
client = db.Column(db.String(120), nullable=False)
phone = db.Column(db.String(120), nullable=False)
price = db.Column(db.Integer)
shop_id = db.Column(db.Integer, db.ForeignKey("shop.id"), nullable=False)
products_detail_sales = db.relationship("ProductsSale",
backref="sale_products_sale",
lazy=True)
def __repr__(self):
return "<Sale %r>" % self.id
class Product(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
price = db.Column(db.Integer)
quantity = db.Column(db.Integer)
shop_id = db.Column(db.Integer, db.ForeignKey("shop.id"), nullable=False)
products_detail_sales = db.relationship("ProductsSale",
backref="product_products_sale",
lazy=True)
def __repr__(self):
return "<Product %r>" % self.name
class Etablishment(BaseModel, db.Model):
"""
Etablishment Table
"""
__tablename__ = 'etablishment'
name = db.Column(db.String(60), nullable=False)
# Foreing key to Entity table
entity_id = db.Column(db.Integer,
db.ForeignKey('entity.id'),
nullable=False)
def __repr__(self):
return '<Etablishment: ID : {} - Name : {}>'.format(self.id, self.name)
class Entity(BaseModel, db.Model):
"""
Entity Table
"""
__tablename__ = 'entity'
name = db.Column(db.String(60), nullable=False)
def __repr__(self):
return '<Entity: ID : {} - Name : {}>'.format(self.id, self.name)