from peewee import *
db = MySQLDatabase(“91jiafan”, host=”127.0.0.1″, port=3306, user=”root”, password=”123456″)
class BaseModel(Model): class Meta: database = db #table_name = “product”
#设计数据表的时候有几个重要点一定要注意 “”” char类型， 要设置最大长度 对于无法确定最大长度的字段，可以设置为Text 设计表的时候 采集到的数据要尽量先做格式化处理 default和null=True “””
class Product(BaseModel): name = CharField(max_length=200) # 产品名 #name = CharField(max_length=20,primary_key=True) # 产品名 price = FloatField(default=0.0) # 价格 #content = TextField(default=””) #id = IntegerField(primary_key=True) sales_num = IntegerField(default=0) # 销量 merchant = CharField() # 商家 main_Products = CharField() # 主营 merchant_Place = CharField(max_length=200) # 地址
class Product_attributes(BaseModel): product_id = IntegerField(primary_key=True) # 产品识别ID price_base = FloatField(default=0.0) # 基准价格 attributes = CharField(max_length=300) # 商品描述
buyer_num = IntegerField(default=0) # 购买人数 sale_num = IntegerField(default=0) # 销售数量 buyer_rate = FloatField(default=0.0) # 商品复购率
‘‘‘ class Topic(BaseModel): title = CharField() content = TextField(default=””) id = IntegerField(primary_key=True) author = CharField() create_time = DateTimeField() answer_nums = IntegerField(default=0) click_nums = IntegerField(default=0) praised_nums = IntegerField(default=0) jtl = FloatField(default=0.0) # 结帖率 score = IntegerField(default=0) # 赏分 status = CharField() # 状态 last_answer_time = DateTimeField()
class Answer(BaseModel): topic_id = IntegerField() author = CharField() content = TextField(default=””) create_time = DateTimeField() parised_nums = IntegerField(default=0) #点赞数
class Author(BaseModel): name = CharField() id = CharField(primary_key=True) click_nums = IntegerField(default=0) #访问数 original_nums = IntegerField(default=0) #原创数 forward_nums = IntegerField(default=0) # 转发数 rate = IntegerField(default=-1) # 排名 answer_nums = IntegerField(default=0) # 评论数 parised_nums = IntegerField(default=0) # 获赞数 desc = TextField(null=True) industry = CharField(null=True) location = CharField(null=True) follower_nums = IntegerField(default=0) # 粉丝数 following_nums = IntegerField(default=0) # 关注数 ‘‘‘
if __name__ == “__main__”: #db.create_tables([Topic, Answer, Author]) db.create_tables([Product,Product_attributes])