class User(Model):
__table__ = 'users'
id = IntegerField(primary_key=True)
email = StringField(column_type='varchar(50)')
password = StringField(column_type='varchar(50)')
admin = BooleanField()
name = StringField(column_type='varchar(50)')
image = StringField(column_type='varchar(500)')
created_at = FloatField(default=time.time)
class User(Model):
__table__ = 'user'
id = AutoIncrementPrimaryField()
email = StringField(ddl='varchar(50)', unique=True)
passwd = StringField(ddl='varchar(50)')
isAdmin = BooleanField()
name = StringField(ddl='varchar(50)')
avatar = StringField(ddl='varchar(500)')
create_time = FloatField(default=time.time)
class User(Model):
__table__ = "users"
studentNo = StringField(ddl="varchar(50)")
email = StringField(ddl="varchar(50)")
passwd = StringField(ddl="varchar(50)")
gender = BooleanField()
name = StringField(primarykey=True, ddl="varchar(50)")
# image = StringField(ddl="varchar(500)")
phone = StringField(ddl="varchar(14)")
school = StringField(ddl="varchar(50)", default='UESTC')
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(500)')
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)")
name = StringField(ddl="varchar(50)")
email = StringField(ddl="varchar(50)")
passwd = StringField(ddl="varchar(50)")
image = StringField(ddl="varchar(500)")
admin = BooleanField()
created_at = FloatField(default=time.time)
class User(Model):
__table__ = 'users'
"""docstring for User"""
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) # 创建时间默认是为当前时间
class User(Model):
__table__ = 'users'
#def __init__(self, name, column_type, primary_key, default):
id = StringField(primary_key=True, default=next_id())
email = StringField()
passwd = StringField()
admin = BooleanField()
name = StringField()
image = StringField(ddl='varchar(500)')
created_at = FloatField(default=time.time)
class Comment(Model): __table__ = 'comment' 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 = 'varcahr(50)') created_at = FloatField(default = time.time)
class User(Model): #对应 User表
__table__ = 'users'
# __table__,id,email等定义的变量及其值传到 metaclass中的attrs作为键值对存在
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)
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)');
create_at = FloatField(default=time.time);
class User(Model):
__table__ = 'users'
id = StringField(primary_key=True, default=next_id(), ddl='varchar(50)')
phone = StringField(ddl='varchar(50)')
email = StringField(ddl='varchar(50)')
password = StringField(ddl='varchar(50)')
admin = BooleanField()
name = StringField(ddl='varchar(50)')
image = StringField(ddl='varchar(500)')
create_time = StringField(default=get_time())
class Blog(Model):
__table__
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)')
summary = StringField(ddl='varchar(200)')
content = TextField()
create_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)') # passwd 列
admin = BooleanField() # admin 列
name = StringField(ddl='varchar(50)') # name 列
image = StringField(ddl='varchar(500)') # image 列
created_at = FloatField(default=time.time) # created_at(time) 列
class User(Model):
__table__ = 'users'
#根据系统当前时间15位和一个随机得到的UUID 填充3个0 组成一个长度为50的字符串
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)
class User(Model):
__table__ = 'users' # 表名
id = StringField(primary_key=True, default=next_id,
ddl='varchar(50)') # ID主键
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) # 创建时间
class User(Model):
__table__ = 'users'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
#主键id的缺省值是next_id,当生成对象时，没有指定值就找缺省
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) #创建时间
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)')
# 时间和日期用float类型存储在数据库中,不要datetime类型的好处是不必关心数据库的时区和时区转换,显示时只需要做一个float到str的转换
created_at = FloatField(default=time.time)
class User(Model):
__table__ = 'users'
#定义属性的类型和默认参数！这些参数会传入metaclass来生成User类
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)
class FBUser(Model):
__table__ = 'FBUsers'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
email = StringField(ddl='varchar(50)')
passwd = StringField(ddl='varchar(50)')
name = StringField(ddl='varchar(50)')
birthday = StringField(ddl='varchar(50)')
number = IntegerField(default=99)
created_at = FloatField(default=time.time)
admin = BooleanField()
class User(Model):
#mysql中表的名字，这里的table是model的属性，详见orm源码
__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)
class User(Model):
#定义在User类中的__table__、id和name等是类的属性，不是实例的属性
__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) #日期和时间用float类型存储在数据库中
class User(Model):
"""User类映射MySQL数据库中的User表"""
__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) # 列
class Project(Model):
__table__ = 'projects'
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)')
title = StringField(ddl='varchar(50)')
summary = StringField(ddl='varchar(200)')
status = BooleanField()
created_at = FloatField(default=time.time)
class User(Model):
__table__ = 'users'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
school_num = StringField(ddl='varchar(50)')
passwd = StringField(ddl='varchar(50)')
admin = BooleanField()
name = StringField(ddl='varchar(50)')
image = StringField(ddl='varchar(500)')
message = TextField()
content = StringField(default='无', ddl='varchar(500)')
created_at = FloatField(default=time.time)
class User(Model):
__table__ = 'users'
# __table__, id, email... 是类User的属性，不是该类的实例的属性，在类级别定义的属性
# 用来描述User对象的表的映射关系，而实例属性必须通过__init__()方法初始化
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)
class FBUser(Model):
__table__ = 'TBUsers'
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)')
age = FloatField(time.time)
Number = TinyIntegerField(default=0)
created_at = FloatField(default=time.time)
class Chart(Model):
__table__ = 'charts'
id = StringField(primary_key=True, default=next_id, ddl='varchar(50)')
project_id = StringField(ddl='varchar(50)')
user_id = StringField(ddl='varchar(50)')
index = IntegerField()
status = BooleanField()
created_at = FloatField(default=time.time)
type = StringField(ddl='varchar(50)')
option = TextField()
description = TextField()
class User(Model):
__table__ = 'users'
id = StringField(primary_key=True,
default=next_id(),
ddl='varchar(50)',
name='id')
email = StringField(ddl='varchar(50)', name='email')
password = StringField(ddl='varchar(50)', name='password')
admin = BooleanField(name='admin')
name = StringField(name='name', ddl='varchar(50)')
image = StringField(name='image', ddl='varchar(500)')
created_at = FloatField(name='created_at', default=time.time())
class User(Model):
# User表，包括id email passwd admin name image create_at这几列
#其中id是主键
__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)
class User(Model):
__table__ = 'users'
# next_id(funtion name as the args)
id = StringField(primary_key=True, default=next_id, column_type='varchar(50)')
email = StringField(column_type='varchar(50)')
passwd = StringField(column_type='varchar(50)')
admin = BooleanField()
name = StringField(column_type='varchar(50)')
image = StringField(column_type='varchar(500)')
# time.time(funtion name as the args)
created_at = FloatField(default=time.time)
