class Flag(Model): __table__ = 'flags' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') nick = StringField(ddl='varchar(50)') tradeId = StringField(ddl='varchar(50)') created_at = FloatField(default=time.time) createTime = StringField(ddl='varchar(50)') flag = IntegerField() price = FloatField() shop = StringField(ddl='varchar(50)') status = StringField(ddl='varchar(50)')
class Blog(Model): __table__ = "blogs" id = StringField(primary_key=True, default=next_id, ddl="varchar(50)") user_id = StringField(ddl="varchar(50)") # 作者id 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 Reply(Model): __table__ = 'reply' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') comment_id = StringField(ddl='varchar(50)') user_id = StringField(ddl='varchar(50)') reply_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 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)") name = StringField(ddl="varchar(50)") content = TextField() created_at = FloatFlied(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)
class Blog(Model): __table__ = "blog" 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(100)") content = TextField() create_time = FloatField(default=time.time)
class Goods(Model): __table__ = 'goods' id = StringField(primary_key=True, default=random_id, ddl='varchar(50)') owner_account = StringField(updatable=False, ddl='varchar(50)') goods_name = StringField(ddl='varchar(20)') img_filename = StringField(ddl='varchar(50') goods_price = FloatField(default=0.0, ddl='real(4)') buyer_account = StringField(ddl='varchar(50)') description = StringField(updatable=False,ddl='varchar(200)') status = IntegerField(default=0)
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() label = StringField(ddl='varchar(50)') read_total = IntegerField(default=0) limit = BooleanField() created_at = FloatField(default=time.time) latestupdated_at = FloatField(default=time.time)
class User(Model): __table__ = 'users' # id = IntegerField('id', primary_key=True) # name = StringField('name', ddl='varchar(50)') id = IntegerField(primary_key=True) name = StringField(ddl='varchar(50)') def __str__(self): # 用self.getValue(k)就可以,用self.k就不行,会报错找不到那个key # 我觉得我有点知道了:因为初始化的时候,id和name是对象User的属性,是通过setattr()方法设置的属性,但是不是字典user['xxx']里面的属性,所以获取self.k会报错,只能通过getattr()去获取; # 但是当修改属性user.name = 'shihongyuan',又是调用的__setattr__,就赋予了user['xxx']属性,可以通过这个获取,并且会覆盖以前通过setattr()方法设置的同名的属性,也可以通过getattr()获取最新的属性 return '%s ==> %s' % (self.__class__.__name__, list( map(lambda k: self.getValueOrDefault(k), self.__model_fields__)))
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(100)") name = StringField(column_type="varchar(50)") summary = StringField(column_type="varchar(200)") 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)') created_at = FloatField(default=time.time) status = IntegerField() # 1:正常账号 confirm = StringField(ddl='varchar(50)')
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)', default='') admin = BooleanField(default=0) name = StringField(ddl='varchar(50)') image = StringField(ddl='varchar(500)', default='') created_at = FloatField(default=time.time) site = StringField(ddl='varchar(500)', default='') private = BooleanField(default=1)
class Book(Model): __table__ = 'books' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') name = StringField(ddl='varchar(50)') image = StringField(ddl='varchar(500)') author = StringField(ddl='varchar(50)') content = TextField() year = IntegerField() url = StringField(ddl='varchar(500)') introduction = StringField(ddl='varchar(500)') created_at = FloatField(default=time.time)
class Blog(Model): __table__ = 'blogs' # 表名 id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') # ID主键 user_id = StringField(ddl='varchar(50)') # 用户ID 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 Blog(Model): """docstring for Blog""" __table__ = 'BYXBlog' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') userId = StringField(ddl='varchar(50)') username = StringField(ddl='varchar(50)') img = StringField(ddl='varchar(500)') title = StringField(ddl='varchar(50)') summary = StringField(ddl='varchar(200)') content = TextField() createdAt = 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)') avatar_url = StringField(column_type='varchar(100)') title = StringField(column_type='varchar(50)') summary = StringField(column_type='varchar(200)') content = TextField() created_at = FloatField(default=time.time)
class Blog(Model): __table__ = 'blogs' id = StringField(is_primary_key=True, default_value=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(50)') name = StringField(column_type='varchar(50)') summary = StringField(column_type='varchar(200)') content = TextField() created_at = FloatField(default_value=time.time)
class Goods(Model): __table__ = 'goods' id = IntegerField(primary_key=True,insertable=False,ddl='int(11)') goods_id = StringField(updatable=False,ddl='varchar(50)') goods_name = StringField(updatable=False,ddl='varchar(20)') owner_account = StringField(updatable=False, ddl='varchar(50)') buyer_account = StringField(ddl='varchar(50)') img_filename = StringField(updatable=False,ddl='varchar(50') description = StringField(updatable=False,default='',ddl='varchar(500)') goods_price = FloatField(updatable=False,default=0.0, ddl='real') status = IntegerField(default=0,ddl='tinyint(1)') deal_time = TimeField(default=0,ddl='timestamp')
class Blog(Model): __table__ = 'blogs' id = StringField(column_type='varchar(50)', default=generate_id, primary_key=True) 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)', default='') content = TextField() createtime = FloatField(default=time.time)
class Blog(Model): __table__ = 'blogs' id = StringField(primary_key=True, default=gen_id, column_type='varchar(64)') user_id = StringField(column_type='varchar(64)') user_name = StringField(column_type='varchar(64)') user_image = StringField(column_type='varchar(512)') name = StringField(column_type='varchar(64)') summary = StringField(column_type='varchar(256)') content = TextField() 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(50)') name = StringField(ddl='varchar(50)') summary = StringField(ddl='varchar(200)') content = TextField() # 创建时间created_at的默认值是函数time.time # 日期和时间用float类型存储在数据库中,而不是datetime类型 created_at = FloatField(default=time.time)
class StockTradeRecord(Model): __table__ = 'stock_trade_records' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') account_id = StringField(ddl='varchar(50)') stock_code = StringField(ddl='varchar(50)') stock_name = StringField(ddl='varchar(50)') stock_amount = IntegerField() stock_price = FloatField() stock_date = StringField(default=today, ddl='varchar(50)') stock_operation = BooleanField() # True: buy, False: sell trade_series = StringField(ddl='varchar(50)') created_at = FloatField(default=time.time)
class Blog(Model): # blog表,包括id user_id user_name user_image name summary content created_at #id是主键 __table__ = 'blogs' id = StringField(primary_key=True, default=next_id, ddl="varchar(50)") user_id = StringField(ddl='varchar(50)') #作者id 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 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)') summary=StringField(ddl='varchar(500)') name=StringField(ddl='varchar(50)') private=BooleanField() content=TextField() created_at=FloatField(default=time.time) clicked=IntegerField(default=0) comments=IntegerField(default=0)
class User(Model): id = IntegeField(name='id', primary_key=True, default=next_id) name = StringField(name='name') password = StringField(name='password') email = StringField(name='email') admin = IntegeField(name='admin', column_type='Number(2)', default=0) image = StringField(name='image') createtime = StringField( name='createtime', default=lambda: datetime.now().strftime('%Y-%m-%d %H:%M:%S,%f')) updatetime = StringField( name='updatetime', default=lambda: datetime.now().strftime('%Y-%m-%d %H:%M:%S,%f'))
class User(Model): #用户表 __table__ = 'users' id = StringField(primary_key=True, default=next_id, ddl='varchar(60)') name = StringField(ddl='varchar(50)') nickname = StringField(ddl='varchar(50)') password = StringField(ddl='varchar(50)') email = StringField(ddl='varchar(50)') image = StringField(ddl='varchar(500)') created_time = FloatField(default=time.time()) is_del = BooleanField() is_admin = BooleanField()
class Task(Model): __table__ = 'task' id = StringField(primary_key=True, default=next_id(), ddl='varchar(50)') taskname = StringField(ddl='varchar(32)') taskcontent = StringField(ddl='varchar(255)') fileid = StringField(ddl='varchar(50)') deadline = FloatField(default=time.time()) userid = StringField(ddl='varchar(50)') create_date = FloatField(default=time.time()) level = IntegerField(default=0) parentid = StringField(ddl='varchar(50)') progress = IntegerField(default=0)
class Blog(Model): __table__ = 'blogs' id = StringField(primary_key=True, default=next_id, column_type='varchar(50)') user_id = StringField(column_type='varchar(50)') tag = 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 = TextField() content = TextField() created_at = FloatField(default=time.time) scan_count = IntegerField()
class Blog(Model): __table__ = "blogs" __schema__ = [ 'id', 'user_id', 'user_name', 'user_image', 'title', 'category', 'digest', 'content', 'created_at' ] ''' ''' id = StringField(primary_key=True, ddl="varchar(50)", default=next_id) user_id = StringField(ddl="varchar(50)") user_name = StringField(ddl="varchar(50)") user_image = StringField(ddl="varchar(500)") title = StringField(ddl="varchar(500)") category = StringField(ddl="varchar(50)") digest = StringField(ddl="varchar(500)") content = TextField() created_at = FloatField(default=time.time)
class DstInOutStake(Model): __table__ = 'dst_in_out_stake' id = StringField(ddl='varchar(50)', primary_key=True, default=next_id) txid = StringField(ddl='varchar(80)') userid = StringField(ddl='varchar(50)', default=const.POS_NOUSER_ID) username = StringField(ddl='varchar(50)', default=const.POS_NOUSER_NAME) change_amount = FloatField() stake = FloatField() start_amount = FloatField() pos_profit = FloatField() fix_amount = FloatField() fix_stake = FloatField() start_balance = FloatField() stage_pos_profit = FloatField() txtime = IntegerField() txtime_str = StringField(ddl='varchar(50)') pos_time = IntegerField() pos_time_str = StringField(ddl='varchar(50)') isprocess = BooleanField() isonchain = BooleanField() change_username = StringField(ddl='varchar(50)') comment = StringField(ddl='varchar(200)')