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)