class Addproduct(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(40), nullable=False)
price = db.Column(db.Numeric(10, 2), nullable=False)
discount = db.Column(db.Integer, default=0)
stock = db.Column(db.Integer, nullable=False)
color = db.Column(db.Text, nullable=False)
desc = db.Column(db.Text, nullable=False)
pub_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
category_id = db.Column(db.Integer,
db.ForeignKey('category.id'),
nullable=False)
category = db.relationship('Category',
backref=db.backref('categories', lazy=True))
brand_id = db.Column(db.Integer, db.ForeignKey('brand.id'), nullable=False)
brand = db.relationship('Brand', backref=db.backref('brands', lazy=True))
image1 = db.Column(db.String(150), nullable=False, default='image1.jpg')
image2 = db.Column(db.String(150), nullable=False, default='image2.jpg')
image3 = db.Column(db.String(150), nullable=False, default='image3.jpg')
merchant_id = db.Column(db.Integer,
db.ForeignKey('merchant.id'),
nullable=False)
merchant = db.relationship('Merchant',
backref=db.backref('merchant', lazy=True))
merchant_name = db.Column(db.String(45), nullable=False)
merchant_phone = db.Column(db.String(45), nullable=False)
merchant_address = db.Column(db.Text, nullable=False)
def __repr__(self):
return '<Addproduct %r>' % self.name
class Cart(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
User = db.relationship(User, backref=db.backref('users', lazy=True))
product_id = db.Column(db.Integer,
db.ForeignKey('addproduct.id'),
nullable=False)
Addproduct = db.relationship(Addproduct,
backref=db.backref('products', lazy=True))
color = db.Column(db.Text, nullable=False)
quantity = db.Column(db.Integer, nullable=False)
class Shipment(db.Model):
Shipment_ID = db.Column(db.String(10), primary_key=True, nullable=False)
Shipment_Note = db.Column(db.String(50))
Delivery_ID = db.Column(db.String(8),
db.ForeignKey('delivery.Delivery_ID'),
nullable=False)
delivery = db.relationship('Delivery',
backref=db.backref('delivery', lazy=True))
class Brand(db.Model):
__tablename__ = 'brand'
brand_id = db.Column(db.Integer(), primary_key=True)
brand_name = db.Column(db.String(50))
# Relationships
product = db.relationship('Product', backref='brand', lazy='joined',
cascade='all,delete')
# FKs
def __repr__(self):
return f"Brand({self.brand_name})"
class Category(db.Model):
__tablename__ = 'category'
category_id = db.Column('category_id', db.Integer(), primary_key=True)
category_name = db.Column('category_name', db.String(50))
#Relationships
subcategory = db.relationship('SubCategory',
backref='category',
lazy='joined',
cascade="all,delete")
#FKs
def __repr__(self):
return f"Cat({self.category_id},{self.category_name})"