class InvoiceItem(db.Model):
__tablename__ = 'invoice_table'
id = db.Column(db.Integer, primary_key=True)
items = db.Column(db.String(10000), nullable=False)
subtotal = db.Column(db.Float)
total = db.Column(db.Float)
tax = db.Column(db.Float)
class WishListItem(db.Model):
__tablename__ = 'wishlist_table'
id = db.Column(db.Integer, primary_key=True)
itemname = db.Column(db.String(64), nullable=False)
itemprice = db.Column(db.Float)
image = db.Column(db.String(150), nullable=False)
itemsize = db.Column(db.String(64), nullable=False)
class Item(db.Model):
__tablename__ = 'table_of_items'
id = db.Column(db.Integer, primary_key=True)
itemname = db.Column(db.String(64), unique=True, nullable=False)
itemprice = db.Column(db.Float)
category = db.Column(db.String(64), nullable=False)
image = db.Column(db.String(150), nullable=False)
class User(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
userName = db.Column(db.String(64), unique=True, nullable=False)
firstName = db.Column(db.String(128))
lastName = db.Column(db.String(128))
email = db.Column(db.String(128), index=True, unique=True)
CreditCard = db.Column(db.String(128), unique=True)
ccv = db.Column(db.String(128), unique=True)
password = db.Column(db.String(128), nullable=False)
hint = db.Column(db.String(128), nullable=False)
def set_password(self, password):
self.password = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password, password)
def set_hint(self, password):
self.hint = generate_password_hash(password)
def check_secret_key(self, password):
return check_password_hash(self.hint, password)
def __repr__(self):
return '<User:{}>'.format(self.userName)
class CartItem(db.Model):
__tablename__ = 'cart_table'
id = db.Column(db.Integer, primary_key=True)
itemname = db.Column(db.String(64), nullable=False)
itemprice = db.Column(db.Float)
image = db.Column(db.String(150), nullable=False)
itemquantity = db.Column(db.Integer)
itemsize = db.Column(db.String(64), nullable=False)