class Department(db.Model):
__tablename__ = 'departments'
department_id = db.Column(db.Integer, primary_key=True)
name = db.Column(CIText(), unique=True, nullable=False)
products = db.relationship('Product', backref="department", lazy=True)
def __repr__(self):
return f'Department({self.department_id}, {self.name})'
class UserJwt(db.Model):
__tablename__ = 'user_jwts'
user_jwt_id = db.Column(db.Integer, primary_key=True)
jwt = db.Column(CIText(), nullable=False)
date_created = db.Column(db.DateTime, default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('users.user_id'), nullable = False)
def __repr__(self):
return f'UserJwt({self.user_jwt_id}, {self.jwt}, {self.date_created}, {self.user_id})'
class User(db.Model):
__tablename__ = 'users'
user_id = db.Column(db.Integer, primary_key=True)
email = db.Column(CIText(), unique=True, nullable=False)
first_name = db.Column(CIText(), nullable=False)
password = db.Column(CIText(), nullable=False)
date_created = db.Column(db.DateTime, default=datetime.utcnow)
jwts = db.relationship('UserJwt', backref="user", lazy=True)
def __repr__(self):
return f'User({self.user_id}, {self.email}, {self.password}, {self.date_created})'
class ProductView(db.Model):
__tablename__ = 'products_view'
product_id = db.Column(db.Integer, primary_key=True)
description = db.Column(CIText(), unique=True, nullable=False)
last_sold = db.Column(db.Date, nullable=True)
shelf_life_days = db.Column(db.Integer, nullable=True)
sell_price = db.Column(db.Float, nullable=False)
cost_expense = db.Column(db.Float, nullable=False)
qty_sold_in = db.Column(db.Integer, nullable=False)
department = db.Column(db.String(50), nullable=False)
unit = db.Column(db.String(50), nullable=False)
def __repr__(self):
return f'ProductView({self.product_id}, {self.description}, {self.last_sold}, {self.shelf_life_days}, {self.sell_price}, {self.cost_expense}, {self.qty_sold_in}, {self.department}, {self.unit})'
class Product(db.Model):
__tablename__ = 'products'
product_id = db.Column(db.Integer, primary_key=True)
description = db.Column(CIText(), unique=True, nullable=False)
last_sold = db.Column(db.Date, nullable=True)
shelf_life_days = db.Column(db.Integer, nullable=True)
sell_price = db.Column(db.Float, nullable=False)
cost_expense = db.Column(db.Float, nullable=False)
qty_sold_in = db.Column(db.Integer, nullable=False)
department_id = db.Column(db.Integer,
db.ForeignKey('departments.department_id'),
nullable=False)
unit_id = db.Column(db.Integer,
db.ForeignKey('units.unit_id'),
nullable=False)
def __repr__(self):
return f'Product({self.product_id}, {self.description}, {self.last_sold}, {self.shelf_life_days}, {self.sell_price})'