class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) public_id = db.Column(db.String(50), unique=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) admin = db.Column(db.Boolean, default=False) posts = db.relationship('Post', backref="author", lazy=True) items = db.relationship('Item', backref="checker", lazy=True) active = db.Column(db.Boolean, default=False) def get_reset_token(self, expires_sec=1800): s = Serializer(current_app.config['SECRET_KEY'], expires_sec) return s.dumps({'user_id': self.id}).decode('utf-8') @staticmethod def verify_reset_token(token): s = Serializer(current_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 Cloth(db.Model): id = db.Column(db.Integer, primary_key=True) color_name = db.Column(db.String(50), index=True) supplier = db.Column(db.String(50)) width = db.Column(db.Float) fibre = db.Column(db.String(50)) photo = db.Column(db.LargeBinary)
class Orders(db.Model): #订单表 id = db.Column(db.String(30), primary_key=True) customer = db.Column(db.String(20)) date = db.Column(db.String(15), index=True) quantity = db.Column(db.Integer) amount = db.Column(db.Float) pay = db.Column(db.Boolean, default=True)
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) content = db.Column(db.Text, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True) def __repr__(self): return f"Post('{self.title}', '{self.timestamp}')"
class Movement(db.Model): id = db.Column(db.Integer, primary_key=True) product_id = db.Column(db.Integer, db.ForeignKey('product.id'), nullable=False) product = db.Column(db.String(50), nullable=False) from_location_id = db.Column(db.Integer, db.ForeignKey('location.id')) from_location = db.Column(db.String(50)) to_location_id = db.Column(db.Integer, db.ForeignKey('location.id')) to_location = db.Column(db.String(50)) quantity = db.Column(db.Integer, nullable=False) timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
class Item(db.Model): id = db.Column(db.Integer, primary_key=True) item_name = db.Column(db.String(100), nullable=False) item_brand = db.Column(db.String(100), nullable=True) item_model = db.Column(db.String(100), nullable=True) item_cost = db.Column(db.Float, nullable=False) item_quantity = db.Column(db.Integer, nullable=False) supplyer_id = db.Column(db.Integer, db.ForeignKey('supplyer.id'), nullable=True) timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)
class ProductMovement(db.Model): movement_id = db.Column(db.Integer, primary_key=True) timestamp = db.Column(db.DateTime, nullable=False, default=datetime.now) from_location = db.Column(db.String(20), db.ForeignKey('location.location_id')) to_location = db.Column(db.String(20), db.ForeignKey('location.location_id')) product_id = db.Column(db.Integer, db.ForeignKey('product.product_id'), nullable=False) qty = db.Column(db.Integer, nullable=False) def __repr__(self): return f"ProductMovement( '{self.timestamp}', '{self.from_location}', '{self.to_location}', '{self.product_id}', '{self.qty}')"
class Customer(db.Model): #客户信息表 id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20)) def __repr__(self): return '<Customer %r>' % self.name
class Product(db.Model): prod_name = db.Column(db.String(20), primary_key=True) prod_qty = db.Column(db.Integer, nullable=False) prod_price = db.Column(db.Float, nullable=False) def __repr__(self): return f"Product('{self.prod_name}','{self.prod_qty}','{self.prod_price}')"
class Product(db.Model): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(200), nullable=False, unique=True) product_movement = db.relationship('ProductMovement', backref='product', lazy=True) def __repr__(self): return "{}".format(self.id)
class OrderDetail(db.Model): #订单详情 id = db.Column(db.Integer, primary_key=True) order_id = db.Column(db.String(30), index=True) goods_id = db.Column(db.Integer, db.ForeignKey('goods.id')) #goods_id = db.Column(db.Integer) goods_name = db.relationship('Goods', back_populates='order_id') goods_quantity = db.Column(db.Integer) goods_amount = db.Column(db.Float)
class Goods(db.Model): #商品信息表 id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(30), unique=True) price = db.Column(db.Float) order_id = db.relationship('OrderDetail', back_populates='goods_name') def __repr__(self): return '<Goods %r>' % self.name
class Supplyer(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(100), nullable=False) contact_number = db.Column(db.String, nullable=True) address = db.Column(db.Text, nullable=True) timestamp = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) items = db.relationship('Item', backref="distributor", lazy=True) def __repr__(self): return f"Post('{self.name}', '{self.contact_number}')"
class Location(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50), unique=True, nullable=False) from_loc = db.relationship( 'Movement', backref='to', lazy=True, primaryjoin='Movement.from_location_id == Location.id') to_loc = db.relationship( 'Movement', backref='from', lazy=True, primaryjoin='Movement.to_location_id == Location.id')
class Location(db.Model): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(200), nullable=False, unique=True) def __repr__(self): return "{}".format(self.id)
class Location(db.Model): location_id = db.Column(db.Integer, primary_key=True) location_name = db.Column(db.String(20), unique=True, nullable=False) def __repr__(self): return f"Location('{self.location_name}')"
class Product(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(50), unique=True, nullable=False) moved_product = db.relationship('Movement', backref='item', lazy=True)
class Product(db.Model): product_id = db.Column(db.Integer, primary_key=True) product_name = db.Column(db.String(20), unique=True, nullable=False) def __repr__(self): return f"Product('{self.product_name}')"