class Comment(Model):
__table__ = 'comments'
id = IntegerField(primary_key=True, default=None)
user_id = IntegerField()
content = StringField()
create_time = FloatField(default=time.time())
class User(Model):
__table__ = 'users'
#id,username,password,admin,email,image,created_at(传入函数名即可)
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
username = StringField(ddl='varchar(40)')
password = StringField(ddl='varchar(40)')
admin = BooleanField()
email = StringField(ddl='varchar(40)')
image = StringField(ddl='varchar(500)')
created_at = FloatField(default=time.time)
#复写父类的save方法，添加查重方法
async def save(self):
if (await self.isSaved()) == False:
# return Model.save()
await super(User, self).save()
else:
raise SQLException('该用户已经被注册！')
#判断用户是否存在于数据库
async def isSaved(self):
sql = '%s where `%s`=?' % (self.__select__, 'email')
rs = await select(sql, [self.email])
if len(rs) == 0:
return False
return True
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)
#
# if __name__ == "__main__": # 一个类自带前后都有双下划线的方法，在子类继承该类的时候，这些方法会自动调用，比如__init__
#
# loop = asyncio.get_event_loop()
#
#
# # 创建实例
# @asyncio.coroutine
# def test():
# yield from create_pool(loop=loop, host='localhost', port=3306, user='******', password='******', db='awesome')
# u = User(name='Test', email='*****@*****.**', passwd='1234567890', image='about:blank')
#
# yield from u.save()
#
#
# loop.run_until_complete(test())
# loop.run_forever()
# # if loop.is_closed():
# # sys.exit(0)
class Quote(Model):
__table__ = 'quotes'
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)')
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='email')
passwd = StringField(ddl='varchar(50)', name='passwd')
admin = BooleanField(name='admin')
name = StringField(ddl='varchar(50)', name='name')
image = StringField(ddl='varchar(50)', name='image')
create_at = FloatField(default=time.time(), name='create_at')
class User(Model):
__table__ = 'users'
id = StringField(primary_key=True, default=next_id(), ddl='varchar(50)')
admin = BooleanField
name = StringField(ddl='varchar(50)')
password = StringField(ddl='varchar(50)')
email = StringField(ddl='varchar(50)')
image = StringField(ddl='varchar(300)')
created_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(300)')
sumarry = StringField(ddl='varchar(200)')
content = TextField()
created_time = FloatField(default=time.time)
class Comment(Model):
__table__ = 'comments'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
user_id = StringField(ddl='varchar(50)')
blog_id = StringField(ddl='varchar(50)')
user_name = StringField(ddl='varchar(50)')
user_image = StringField(ddl='varchar(500)')
context = TextField()
created_time = FloatField(default=time.time)
class User(Model):
__table__ = 'users'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
passwd = StringField(ddl='varchar(50)')
admin = BooleanField()
name = StringField(ddl='varchar(50)')
# 时间变量我们用float来存储，这样方便排序和类型转换
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)')
user_name = StringField(ddl='varchar(50)')
name = StringField(ddl='varchar(50)')
summary = StringField(ddl='varchar(50)')
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 User(Model):
__table__ = '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)', default='emptyImage')
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)")
passwd = StringField(ddl="varchar(50)")
admin = BoolanField()
name = StringField(ddl="varchar(50)")
image = StringField(ddl="varchar(500)")
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)')
passwd = StringField(ddl='varchar(50)')
admin = BooleanField()
name = StringField(ddl='varchar(50)')
image = StringField(ddl='varchar(500)')
#<built-in function time>
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 Blog(Model):
__table__ = 'blogs'
id = StringField(primary_key=True,
name='blogs',
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()
create_at = FloatField(default=time.time())
class Blog(Model):
__table__ = 'blogs'
id = StringField(primary_key=True,
default=next_id,
column_type='varchar(50)')
user_id = StringField(column_type='varchar(50)')
user_name = StringField(column_type='varchar(50)')
user_image = StringField(column_type='varchar(500)')
name = StringField(column_type='varchar(50)')
summary = StringField(column_type='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()
#日期和时间用float类型存储在数据库中，而不是datetime类型，
# 这么做的好处是不必关心数据库的时区以及时区转换问题，排序非常简单，显示的时候，
# 只需要做一个float到str的转换，也非常容易
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)
# if __name__ == '__main__':
# migrate = Migrate(app, db)
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)
class User(Model):
__table__ = '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)')
created_at = FloatField(default=time.time)
def __init__(self, **kw):
super().__init__(**kw)
self.instanceTestField = "instanceStrFiled"
def customMethod(self, paramStr):
print('params' + str(paramStr))
class User(Model):
__table__ = '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)')
created_at = FloatField(default=time.time)
def show(self):
print(1, '__mappings__:', self.__mappings__)
print(2, '__table__:', self.__table__)
print(3, '__primary_key__:', self.__primary_key__)
print(4, '__fields__:', self.__fields__)
print(5, '__select__:', self.__select__)
print(6, '__insert__:', self.__insert__)
print(7, '__update__:', self.__update__)
print(8, '__delete__:', self.__delete__)
