Example #1
0
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)')
Example #2
0
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)
Example #4
0
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)
Example #5
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()
    created_at = FloatField(default=time.time)
Example #6
0
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)
Example #7
0
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)
Example #8
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)
Example #9
0
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__)))
Example #10
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)")
    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)')
Example #12
0
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)
Example #13
0
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)
Example #14
0
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)  # 创建时间
Example #15
0
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)
Example #16
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)')
    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)
Example #17
0
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)
Example #18
0
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')
Example #19
0
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)
Example #20
0
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)
Example #21
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(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)
Example #22
0
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)
Example #23
0
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)  #文章创建日期,便于后期排序
Example #24
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)')
	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)
Example #25
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'))
Example #26
0
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()
Example #27
0
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)
Example #28
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()
Example #29
0
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)
Example #30
0
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)')