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)
class User(Model):
__table__ = 'users'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
email = StringField(ddl='varchar(50)')
name = StringField(ddl='varchar(50)')
passwd = StringField(ddl='varchar(32)')
admin = BooleanField()
image = StringField(ddl='varchar(500)')
created_at = FloatField(default=time.time)
class App(Model):
"""
应用模型
"""
__table__ = 'app'
id = IntegerField(primary_key=True)
app_name = StringField(ddl='varchar(50)')
app_key = StringField(ddl='varchar(50)')
app_type = IntegerField()
user_id = StringField(ddl='varchar(50)')
app_icon = StringField(ddl='varchar(500)')
create_time = FloatField(default=time.time)
class PatchRecord(Model):
"""
补丁包记录
"""
__table__ = 'patch_record'
id = IntegerField(primary_key=True)
app_version_code = StringField(ddl='varchar(45)')
app_id = IntegerField()
patch_version_num = IntegerField()
update_time = FloatField(default=time.time)
patch_link = StringField(ddl='varchar(500)')
describe = TextField()
is_effective = BooleanField(default=True)
class AppVersion(Model):
"""
应用版本模型
"""
__table__ = 'app_version'
id = IntegerField(primary_key=True)
app_id = IntegerField()
version_code = StringField(ddl='varchar(45)')
create_time = 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)