class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
role = db.Column(db.Integer, db.ForeignKey('role.id'), nullable=True)
def __repr__(self):
return f"User('{self.id}', '{self.email}', '{self.role}')"
class Order(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120), nullable=False)
completed = db.Column(db.Boolean, nullable=False, default=False)
requires_action = db.Column(db.Boolean, nullable=False, default=False)
position = db.Column(db.ForeignKey('role.id'), nullable=False, default=1)
message = db.Column(db.String(120), nullable=True)
def __repr__(self):
return f"Order('{self.name}', '{self.id}')"
class Size(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120), unique=True, nullable=False)
fabric_multiplier = db.Column(db.Float, nullable=False)
def __repr__(self):
return f"Size('{self.name}', '{self.id}')"
class Component(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120), unique=False, nullable=False)
color = db.Column(db.ForeignKey('color.id'), nullable=False)
fabric = db.Column(db.Boolean, nullable=False, default=False)
quantity = db.Column(db.Float, nullable=False)
def __repr__(self):
return f"Component('{self.name}', '{self.quantity}')"
def to_json(self):
return {"nazwa": self.name, "kolor": self.color, "ilosc": str(self.quantity)}
class Product(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120), unique=True, nullable=False)
def __repr__(self):
return f"Product('{self.name}')"
class Role(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(60), unique=True, nullable=False)
def __repr__(self):
return f"Role('{self.id}', '{self.name}')"