class Products(db.Model): """Products table""" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50), nullable=False) price = db.Column(db.Integer, nullable=False) discount = db.Column(db.Integer) stock = db.Column(db.Integer, nullable=False) image = db.Column(db.String(128), unique=True, nullable=False) category_id = db.Column(db.Integer, db.ForeignKey('categories.id'), nullable=False) sub_category_id = db.Column(db.Integer, db.ForeignKey('subcategories.id'), nullable=False) cart = db.relationship('Cart', backref='product', lazy=True) def __repr__(self): return self.name @property def image_filepath(self): """To access the product image filepath""" return images.path(self.image) def get_percent_saved(self): amount_saved = self.price - self.discount return round(amount_saved / self.price * 100) def get_humanize_price(self): return humanize.intcomma(self.price) def get_humanize_discount(self): return humanize.intcomma(self.discount)
class Cart(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) product_id = db.Column(db.Integer, db.ForeignKey('products.id'), nullable=False) quantity = db.Column(db.Integer, nullable=False, default=1) complete = db.Column(db.Boolean, default=False) start_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) ordered_date = db.Column(db.DateTime, nullable=True) def __repr__(self): return f'Product: {self.product_id}'
class Calendar(db.Model): id = db.Column(db.Integer, primary_key=True) dag = db.relationship("Dag", backref="calendar", lazy=True) user_id = db.Column(db.Integer, db.ForeignKey("users.id"), nullable=False) def __repr__(self): return str(self.user_id)
class Begivenhed(db.Model): id = db.Column(db.Integer, primary_key=True) time = db.Column(db.String) content = db.Column(db.String) dag_id = db.Column(db.Integer, db.ForeignKey("dag.id"), nullable=False) def __repr__(self): return str(self.content)
class CartItems(db.Model): id = db.Column(db.Integer, primary_key=True, autoincrement=True) name = db.Column(db.String, nullable=False) stock = db.Column(db.Integer, nullable=False) cart_id = db.Column(db.Integer, db.ForeignKey("carts.id"), nullable=False) def __repr__(self): return self.name
class BoughtItem(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) time = db.Column(db.DateTime, nullable=False) buying_price = db.Column(db.Float, nullable=False) bought_quantity = db.Column(db.Integer, nullable=False) # current_quantity = db.Column(db.Integer, nullable=False) # place = db.Column(db.String(50), nullable=False) item_id = db.Column(db.Integer, db.ForeignKey('main_item.id'))
class Dag(db.Model): id = db.Column(db.Integer, primary_key=True) date = db.Column(db.Integer, default=datetime.now().isoweekday()) begivenhed = db.relationship("Begivenhed", backref="dag", lazy=True) calendar_id = db.Column(db.Integer, db.ForeignKey("calendar.id"), nullable=False) def __repr__(self): return str(self.calendar_id)
class SoldItem(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) time = db.Column(db.DateTime, nullable=False) paid_price = db.Column(db.Float, nullable=False) sold_quantity = db.Column(db.Integer, nullable=False) customer = db.Column(db.String(100)) sale = db.Column(db.Float, nullable=False, default=0.0) debt = db.Column(db.Float, nullable=False) item_id = db.Column(db.Integer, db.ForeignKey('main_item.id'))
class Product(db.Model): id= db.Column(db.Integer, primary_key=True) product_identifier= db.Column(db.String(10), nullable=False) product_name= db.Column(db.String(40), nullable=False) product_description= db.Column(db.Text, nullable=False) pictures= db.Column(db.PickleType, nullable=False) unit_price= db.Column(db.Float, nullable=False) product_available= db.Column(db.Boolean, default=True) delivery= db.Column(db.String(20), nullable=False) brand_id= db.Column(db.Integer, db.ForeignKey('brand.id')) category_id= db.Column(db.Integer, db.ForeignKey('category.id')) discount_available= db.Column(db.Boolean, default=False) discount_percentage= db.Column(db.Float, nullable=True) pub_date = db.Column(db.DateTime, index=True, default=datetime.utcnow) def save_imgs(self, img_list): self.pictures= img_list def __repr__(self): return f"Product('{self.product_identifier}',\
class Order(db.Model): id= db.Column(db.Integer, primary_key=True) user_id= db.Column(db.Integer, db.ForeignKey('user.id')) order_number= db.Column(db.Integer, nullable=False) items= db.relationship('OrderItem', backref='order', lazy=True) paid= db.Column(db.Boolean, default=False) fulfilled= db.Column(db.Boolean, default=False) cancelled= db.Column(db.Boolean, default=False) err_msg= db.Column(db.String(60), nullable=True) err_log= db.Column(db.PickleType, nullable=True) date_placed = db.Column(db.DateTime, index=True, default=datetime.utcnow)
class Orders(db.Model): id = db.Column(db.Integer, primary_key=True) order_code = db.Column(db.Integer, nullable=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) complete = db.Column(db.Boolean, default=False) ordered_date = db.Column(db.DateTime, nullable=True) products = db.relationship('Cart', secondary=cart_orders, lazy='subquery', backref=db.backref('cart', lazy=True)) def __repr__(self): return f'Product: {self.product_id}'
class Sell(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) image_file = db.Column(db.String(20), nullable=False, default='def1.jpg') date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) price = db.Column(db.Integer, nullable=False) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Sell('{self.title}','{self.price}',{self.image_file}, '{self.date_posted}')"
class Users(UserMixin, db.Model): """Users table""" id = db.Column(db.Integer, primary_key=True) first_name = db.Column(db.String(50), nullable=False) last_name = db.Column(db.String(50), nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) email_confirmed = db.Column(db.Boolean(), nullable=False, default=0) email_confirmed_at = db.Column(db.DateTime()) is_active = db.Column(db.Boolean(), nullable=False, default=1) password = db.Column(db.String(300), nullable=False) role_id = db.Column(db.Integer, db.ForeignKey('roles.id'), nullable=False, default=1) cart = db.relationship('Cart', backref='user', lazy=True) orders = db.relationship('Orders', backref='user', lazy=True) def __repr__(self): return f'{self.first_name} {self.last_name}'
@event.listens_for(Products, 'after_delete') def delete_image(target): """This function deletes the image from the folder.""" if target.image_filepath is not None: try: os.remove(target.image_filepath) except OSError: pass cart_orders = db.Table( 'cart_orders', db.Column('cart_id', db.Integer, db.ForeignKey('cart.id'), primary_key=True), db.Column('orders_id', db.Integer, db.ForeignKey('orders.id'), primary_key=True)) class Cart(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) product_id = db.Column(db.Integer, db.ForeignKey('products.id'), nullable=False) quantity = db.Column(db.Integer, nullable=False, default=1) complete = db.Column(db.Boolean, default=False)
class OrderItem(db.Model): id= db.Column(db.Integer, primary_key=True) product_id= db.Column(db.Integer, db.ForeignKey('product.id')) order_id= db.Column(db.Integer, db.ForeignKey('order.id')) quantity= db.Column(db.Integer, nullable=False)