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__)