class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True, autoincrement=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) cart_details = db.relationship('Cart', backref='owner', lazy=True) contact_us = db.relationship('ContactUs', backref='author', lazy=True) order_details = db.relationship('Order', backref='owner', lazy=True) admin_rights = db.Column(db.Boolean, unique=False, default=False) def get_reset_token(self, expires_sec=1800): s = Serializer(app.config['SECRET_KEY'], expires_sec) return s.dumps({'user_id': self.id}).decode('utf-8') @staticmethod def verify_reset_token(token): s = Serializer(app.config['SECRET_KEY']) try: user_id = s.loads(token)['user_id'] except: return None return User.query.get(user_id) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')"
class Order(db.Model): id = db.Column(db.Integer, primary_key=True) address = db.Column(db.String(100), nullable=False) postal = db.Column(db.String(100), nullable=False) cardNumber = db.Column(db.String(100), nullable=False) expDate = db.Column(db.String(100), nullable=False) cvv = db.Column(db.String(100), nullable=False) product_name = db.Column(db.String, nullable=False) qty = db.Column(db.Integer, nullable=False) price = db.Column(db.String, nullable=False) totalsum = db.Column(db.Float(2, 2), nullable=False) owner_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Seller(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(60), nullable=False) address = db.Column(db.String(120), nullable=False) phone = db.Column(db.String(12), nullable=False) is_customer = db.Column(db.Boolean, server_default="0") product = db.relationship('Product', backref='seller_item', lazy=True) def __repr__(self): return f"Seller('{self.username}', '{self.email}', '{self.address}', '{self.phone}')"
class CustomerBought(db.Model): id = db.Column(db.Integer, primary_key=True) price = db.Column(db.Integer, nullable=False) size = db.Column(db.Integer, nullable=False) name = db.Column(db.String(60), nullable=False) quantity = db.Column(db.Integer, nullable=False) date_bought = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) image_product = db.Column(db.String(60), nullable=False) customer_id = db.Column(db.Integer, db.ForeignKey('customer.id')) def __repr__(self): return f"CustomerBought('{self.name}', '{self.date_bought}', '{self.price}', '{self.quantity}')"
class Customer(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(60), nullable=False) is_customer = db.Column(db.Boolean, server_default="1") customer_bought = db.relationship('CustomerBought', backref='customer_bought', lazy=True) #Changed gender = db.Column(db.Integer, db.ForeignKey('gender.id')) def __repr__(self): return f"User('{self.username}', '{self.email}')"
class Product(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100), nullable=False) price = db.Column(db.Float(2, 2), nullable=False) qty = db.Column(db.Integer, nullable=False) def __repr__(self): return f"Product('{self.id}',{self.name},'{self.price}')"
class ContactUs(db.Model): id = db.Column(db.Integer, primary_key=True) subject = db.Column(db.String(100), nullable=False) content = db.Column(db.Text, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Brand(db.Model): id = db.Column(db.Integer, primary_key=True) brand_name = db.Column(db.String(25), nullable=False, unique=True) product = db.relationship('Product', backref='brand_product', lazy=True) def __repr__(self): return f"Brand('{self.brand_name}')"
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
class Size(db.Model): id = db.Column(db.Integer, primary_key=True) size_number = db.Column(db.Integer, nullable=False) size_name = db.Column(db.String(20), nullable=False) product_id = db.Column(db.Integer, db.ForeignKey('product.id')) def __repr__(self): return f"Size('{self.size_number}', '{self.size_name}')"
class Product(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(60), nullable=False) price = db.Column(db.Integer, nullable=False) quantity = db.Column(db.Integer, nullable=False) image_product = db.Column(db.String(60), nullable=False) feature = db.relationship('Feature', backref='product_features', lazy=True) size = db.relationship('Size', backref='product_size', lazy=True) review = db.relationship('Review', backref='product_review', lazy=True) #Changed gender = db.Column(db.Integer, db.ForeignKey('gender.id')) brand_id = db.Column(db.Integer, db.ForeignKey('brand.id')) seller_id = db.Column(db.Integer, db.ForeignKey('seller.id')) def __repr__(self): return f"Product('{self.name}', '{self.price}', '{self.quantity}')"
class Gender(db.Model): id = db.Column(db.Integer, primary_key=True) gender = db.Column(db.String(7), nullable=False) # Changed customer = db.relationship('Customer', backref='gender_customer', lazy=True) product = db.relationship('Product', backref='gender_product', lazy=True) def __repr__(self): return f"Gender('{self.gender}')"
class Timeout(db.Model): ip = db.Column(db.String(100), primary_key=True) attempts = db.Column(db.Integer) start = db.Column(db.DateTime, nullable=True) release = db.Column(db.DateTime, nullable=True)