class Course(Model):
cid = StringField(primary_key=True)
cname = StringField()
chours = IntegerField()
credit = FloatField()
precid = StringField()
# -*- coding：utf-8-*-
class TaobaoProducts(Model):
__table__ = 'TaobaoProducts'
id = IntegerField(primary_key=True)
keyword = StringField(ddl='varchar(30)')
product_id = StringField(ddl='varchar(100)')
product_type = StringField(ddl='varchar(100)')
imgsrcurl = StringField(ddl='varchar(300)')
imgurl = StringField(ddl='varchar(300)')
imgnumber = IntegerField()
samestyleurl = StringField(ddl='varchar(300)')
similarurl = StringField(ddl='varchar(300)')
product_price = StringField(ddl='varchar(20)')
payednum = StringField(ddl='varchar(20)')
title = StringField(ddl='varchar(300)')
title1 = StringField(ddl='varchar(300)')
title2 = StringField(ddl='varchar(300)')
titlehaskey = StringField(ddl='varchar(10)')
titleurl = StringField(ddl='varchar(300)')
shopname = StringField(ddl='varchar(100)')
shopurl = StringField(ddl='varchar(300)')
shopaddress = StringField(ddl='varchar(20)')
shoplevelzuanqty = IntegerField()
shoplevelguanqty = IntegerField()
shoplevelxinqty = IntegerField()
shopleveljingguanqty = IntegerField()
istmall = StringField(ddl='varchar(10)')
iconkey1 = StringField(ddl='varchar(100)')
icontitle1 = StringField(ddl='varchar(100)')
iconurl1 = StringField(ddl='varchar(300)')
iconkey2 = StringField(ddl='varchar(100)')
icontitle2 = StringField(ddl='varchar(100)')
iconurl2 = StringField(ddl='varchar(300)')
iconkey3 = StringField(ddl='varchar(100)')
icontitle3 = StringField(ddl='varchar(100)')
iconurl3 = StringField(ddl='varchar(300)')
iconkey4 = StringField(ddl='varchar(100)')
icontitle4 = StringField(ddl='varchar(100)')
iconurl4 = StringField(ddl='varchar(300)')
iconkey5 = StringField(ddl='varchar(100)')
icontitle5 = StringField(ddl='varchar(100)')
iconurl5 = StringField(ddl='varchar(300)')
subiconclass1 = StringField(ddl='varchar(100)')
subicontitle1 = StringField(ddl='varchar(100)')
subiconcontent1 = StringField(ddl='varchar(300)')
subiconclass2 = StringField(ddl='varchar(100)')
subicontitle2 = StringField(ddl='varchar(100)')
subiconcontent2 = StringField(ddl='varchar(300)')
subiconclass3 = StringField(ddl='varchar(100)')
subicontitle3 = StringField(ddl='varchar(100)')
subiconcontent3 = StringField(ddl='varchar(300)')
subiconclass4 = StringField(ddl='varchar(100)')
subicontitle4 = StringField(ddl='varchar(100)')
subiconcontent4 = StringField(ddl='varchar(300)')
subiconclass5 = StringField(ddl='varchar(100)')
subicontitle5 = StringField(ddl='varchar(100)')
subiconcontent5 = StringField(ddl='varchar(300)')
shoptotalrate = StringField(ddl='varchar(20)')
shopdescscore = StringField(ddl='varchar(20)')
shopdescscorediff = StringField(ddl='varchar(20)')
shopdesccompare = StringField(ddl='varchar(20)')
shopdeliveryscore = StringField(ddl='varchar(20)')
shopdeliveryscorediff = StringField(ddl='varchar(20)')
shopdeliverycompare = StringField(ddl='varchar(20)')
shopservicescore = StringField(ddl='varchar(20)')
shopservicescorediff = StringField(ddl='varchar(20)')
shopservicecompare = StringField(ddl='varchar(20)')
product_price_float = FloatField()
product_sales_qty = IntegerField()
shop_ave_score = FloatField()
created_at = DateTimeField()
name = StringField(ddl='varchar(50)')
image = StringField(ddl='varchar(500)')
created_at = FloatField(default=time.time)
class Blog(Model):
__table__ = 'blogs'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
user_id = StringField(ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(500)')
name = StringField(ddl='varchar(50)')
summary = StringField(ddl='varchar(200)')
content = TextField()
created_at = FloatField(default=time.time)
class Comment(Model):
__table__ = 'comments'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
blog_id = StringField(ddl='varchar(50)')
user_id = StringField(ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(500)')
content = TextField()
created_at = FloatField(default=time.time)
