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=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()#地址
''' 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])