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)
class Blog(Model):
__table__ = 'blogs'
#id,user_id,user_name,user_image,name,summary,content,created_at
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
user_id = StringField(ddl='varchar(50)')
user_name = StringField(ddl='varchar(40)')
user_image = StringField(ddl='varchar(500)')
name = StringField(ddl='varchar(40)')
summary = StringField(ddl='varchar(200)')
content = TextField() #默认是text类型
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()
#日期和时间用float类型存储在数据库中，而不是datetime类型，
# 这么做的好处是不必关心数据库的时区以及时区转换问题，排序非常简单，显示的时候，
# 只需要做一个float到str的转换，也非常容易
created_at = FloatField(default=time.time)
class Blog(Model):
__table__ = 'blogs'
id = StringField(name='id',
primary_key=True,
default=next_id,
ddl="varchar(50)")
user_id = StringField(name='user_id', ddl="varchar(50)")
user_name = StringField(name='user_name', ddl="varchar(50)")
user_image = StringField(name='user_image', ddl="varchar(500)")
name = StringField(name='name', ddl="varchar(50)")
summary = StringField(name='summary', ddl="varchar(200)")
content = TextField(name='content')
created_at = FloatField(name='created_at', default=time.time)
