# 商品 class Product(db.Model, CRUDMixin): __tablename__ = 't_product' id = db.Column(db.Integer, primary_key=True, autoincrement=True) title = db.Column(db.String(128), nullable=False) content = db.Column(db.TEXT) orginal_price = db.Column(db.DECIMAL) team_buying_price = db.Column(db.DECIMAL) category = db.Column(db.Integer) status = db.Column(db.SMALLINT) create_time = db.Column(db.Integer) # one-to-many images = db.relationship('ProductImage', backref='product', primaryjoin='ProductImage.product_id == Product.id') # 商品图片 class ProductImage(db.Model, CRUDMixin): __tablename__ = 't_product_img' id = db.Column(db.Integer, primary_key=True, autoincrement=True) product_id = db.Column(db.Integer, db.ForeignKey('t_product.id')) img_url = db.Column(db.String(512)) order = db.Column(db.SmallInteger) if __name__ == '__main__': res = db.create_all() print res
db.init_app(app) db.app = app #Flask-Login login_configure(app) def login_configure(app): login_manager.init_app(app) login_manager.login_view = app.config['LOGIN_VIEW'] @login_manager.user_loader def load_user(user_id): user_instance = User.query.filter_by(id=user_id).first() if user_instance: return user_instance else: return None if __name__ == '__main__': app = create_app() # db.drop_all() db.create_all()