class ProductInfo(Base, db.Model):
id = db.Column(db.Integer, primary_key=True)
quantity = db.Column(db.Integer, nullable=False)
date = db.Column(db.DateTime, nullable=False)
product_id = db.Column(db.Integer, db.ForeignKey("product.id"))
def __init__(self, quantity, date):
self.quantity = quantity
self.date = date
def __repr__(self):
return str(self.id)
class Customer(Base, db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(200), unique=True)
address = db.Column(db.String(200))
phone_number = db.Column(db.String(200))
orders = db.relationship("Order", backref="customer", lazy="select")
def __init__(self, name, address, phone_number, total_amount=0):
self.name = name
self.address = address
self.phone_number = phone_number
self.total_amount = total_amount
def __repr__(self):
return str(self.id)
class Product(Base, db.Model):
id = db.Column(db.Integer, primary_key=True)
product_name = db.Column(db.String(200), nullable=False)
price = db.Column(db.Float, nullable=False)
quantity = db.Column(db.Integer)
product_info = db.relationship("ProductInfo",
backref="product",
lazy="select")
order_info = db.relationship("OrderItem", backref="product", lazy="select")
def __init__(self, product_name, price):
self.product_name = product_name
self.price = price
self.quantity = 0 #total quantity of bags produced..
def __repr__(self):
return str(self.id)
class Order(Base, db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.DateTime, nullable=False)
order_id = db.Column(db.String(200), nullable=False)
customer_id = db.Column(db.Integer, db.ForeignKey("customer.id"))
paid_status = db.Column(db.String(200))
total_amount = db.Column(db.Integer)
orders = db.relationship("OrderItem", backref="order", lazy="select")
def __init__(self, date, order_id, paid_status, total_amount=0):
self.date = date
self.order_id = order_id
self.paid_status = paid_status
self.total_amount = total_amount
class OrderItem(Base, db.Model):
id = db.Column(db.Integer, primary_key=True)
order_id = db.Column(db.Integer, db.ForeignKey("order.order_id"))
product_id = db.Column(db.Integer, db.ForeignKey("product.id"))
quantity = db.Column(db.Integer, nullable=False)
rate = db.Column(db.Float, nullable=False)
amount = db.Column(db.Float, nullable=False)
def __init__(self, quantity, rate, amount):
self.quantity = quantity
self.rate = rate
self.amount = amount