# 商品
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()
