class Comment(Model):
__table__ = 'comment'
id = StringField(primary_key=True, default=next_id, col_type='varchar(50)')
blog_id = StringField(col_type='varchar(50)')
user_id = StringField(col_type='varchar(50)')
user_name = StringField(col_type='varchar(50)')
user_image = StringField(col_type='varchar(500)')
content = TextField()
created_at = FloatField(default=time.time)
class User(Model):
__table__ = 'user'
id = StringField(primary_key=True, default=next_id, col_type='varchar(50)')
email = StringField(col_type='varchar(50)')
password = StringField(col_type='varchar(50)')
admin = BoolField()
name = StringField(col_type='varchar(50)')
image = StringField(col_type='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)', default='')
user_name = StringField(ddl='varchar(50)', default='')
user_image = StringField(ddl='varchar(500)', default='')
name = StringField(ddl='varchar(50)', default='')
summary = StringField(ddl='varchar(200)')
content = TextField()
created_at = FloatField(default=time.time)
class User(Model):
__tablename__ = 'users'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
email = StringField(ddl='varchar(50)')
passwd = StringField(ddl='varchar(50)')
admin = BooleanField()
name = StringField(ddl='varchar(50)')
image = StringField(ddl='varchar(500)')
# 日期和时间用float类型存储在数据库中，而不是datetime类型，这么做的好处是不必关心数据库的时区以及时区转换问题，排序非常简单
# 显示的时候，只需要做一个float到str的转换
created_at = FloatField(
default=time.time) #传入time.time是因为getvalueordefault会调用time()方法
class Blog(Model):
__table__ = 'blog'
id = StringField(primary_key=True, default=next_id, col_type='varchar(50)')
user_id = StringField(col_type='varchar(50)')
user_name = StringField(col_type='varchar(50)')
user_image = StringField(col_type='varchar(500)')
cat_id = StringField(col_type='varchar(50)')
cat_name = StringField(col_type='varchar(50)')
view_count = IntField()
title = StringField(col_type='varchar(50)')
summary = StringField(col_type='varchar(200)')
content = TextField()
created_at = FloatField(default=time.time)
class Category(Model):
__table__ = 'category'
id = StringField(primary_key=True, default=next_id, col_type='varchar(50)')
name = StringField(col_type='varchar(50)')
created_at = FloatField(default=time.time)