class User(db.Model):
userid = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column(db.String(100), nullable=False, unique=True)
password = db.Column(db.String(100), nullable=False)
email = db.Column(db.String(100), nullable=True)
login_time = db.Column(db.Integer)
# 表格更名
__tablename__ = 'user'
# 初始化每个实例。
def __init__(self, username, password, email):
self.username = username
self.password = password
self.email = email
def get(self, userid):
return self.query.filter_by(userid=userid).first()
def add(self, user):
db.session.add(user)
return session_commit(db)
def update(self):
return session_commit(db)
def delete(self, userid):
self.query.filter_by(userid=userid).delete()
return session_commit(db)
class Studyroom(db.Model):
id = db.Column(db.Integer, primary_key=True)
open = db.Column(db.Integer, nullable=False)
spots = db.Column(db.Integer, nullable=False)
def __repr__(self):
return f"Studyroom('{self.id}')"
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), index=True, unique=True)
email = db.Column(db.String(120), index=True, unique=True)
password_hash = db.Column(db.String(128))
def __repr__(self):
return '<User {}>'.format(self.username)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(15), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(80), nullable=False)
def __repr__(self):
return f"User('{self.username}')"
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.String(140))
timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
def __repr__(self):
return '<Post {}>'.format(self.body)
class blog(db.Model):
id=db.Column(db.Integer,primary_key=True)
title=db.Column(db.String(100),unique=True)
content=db.Column(db.String(2000))
def __init__(self,v_title,v_content):
self.title=v_title
self.content=v_content
def __repr__(self):
return '<Blog %r>' %self.title
class Entry(db.Model):
__tablename__ = 'entries'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.Text)
text = db.Column(db.Text)
def __repr__(self):
return '<Entry id={id} title={title!r}>'.format(id=self.id,
title=self.title)
class post(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(20), nullable=False)
date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
content = db.Column(db.Text, nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"User('{self.title}','{self.date}')"
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
image_file = db.Column(db.String(20), nullable=False, default='default.jpg')
password = db.Column(db.String(60), nullable=False)
def __repr__(self):
return f"User('{self.username}', '{self.email}')"
class user(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True)
passwd = db.Column(db.String(20))
def __init__(self, uname, upasswd):
self.username = uname
self.passwd = upasswd
def __repr__(self):
return '<User %r>' % self.username
class Contact(db.Model):
__tablename__ = 'contacts'
id = db.Column('id', db.Integer, primary_key=True)
firstname = db.Column('firstname', db.String)
lastname = db.Column('lastname', db.String)
email = db.Column('email', db.String)
notes = db.Column('notes', db.String)
def __repr__(self):
return f"<Contact {self.firstname} {self.lastname}: {self.email}"
class Blog(db.Model):
blodid = db.Column(db.Integer, primary_key=True, autoincrement=True)
blogtopic = db.Column(db.String(100), nullable=False)
blogcontent = db.Column(db.Text, nullable=False)
# 表格更名
__tablename__ = 'blog'
def __init__(self, blogtopic, blogcontent):
self.blogtopic = blogtopic
self.blogcontent = blogcontent
class User(db.Model):
__tablename__ = 'stu'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, default='loser')
password = db.Column(db.String(24))
email = db.Column(db.String(120), unique=True, default='*****@*****.**')
def __init__(self, username, password, email):
self.username = username
self.password = password
self.email = email
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), index=True, unique=True)
email = db.Column(db.String(120), index=True, unique=True)
password_hash = db.Column(db.String(128))
def __repr__(self):
return '<User {}>'.format(self.username)
def set_password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
def to_dict(self):
data = {
'id': self.id,
'username': self.username,
'email': self.email,
}
return data
class user(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(20), unique=True, nullable=False)
image_file = db.Column(db.String(20), nullable=False, default='def.jpg')
password = db.Column(db.String(30), nullable=False)
posts = db.relationship('post', backref='author', lazy=True)
def __repr__(self):
return f"User('{self.username}','{self.email}','{self.image_file}')"
def get_reset_token(self, expires_sec=1800):
s = serializer(app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id})
@staticmethod
def verify_reset_token(token):
s = serializer(current_app.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except Exception as e:
raise e
class ServiceCheckResult(db.Model):
"""
存储服务监控信息
service_name：服务名
service_state：服务状态
image_url：图片存放路径
classes：班次（分为‘白班’、‘夜班’）
on_watch：值班人员
date：交班时间
"""
__tablename__ = 'service_check_result'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
service_name = db.Column(db.String(16))
service_state = db.Column(db.String(32))
image_url = db.Column(db.String(256), nullable=True)
classes = db.Column(db.String(32))
on_watch = db.Column(db.String(16))
date = db.Column(db.String(32))
def __repr__(self):
return '<ServiceCheckResult %r>' % self.service_name
@staticmethod
def from_json(json_post):
"""由用户post的json数据返回ServiceCheckResult对象"""
service_name = json_post.get('service_name')
service_state = json_post.get('service_state')
image_url = json_post.get('image_url')
classes = json_post.get('classes')
on_watch = json_post.get('on_watch')
date = json_post.get('date')
return ServiceCheckResult(service_name=service_name,
service_state=service_state,
image_url=image_url,
classes=classes,
on_watch=on_watch,
date=date)
class User(UserMixin, db.Model):
# User继承UserMixin和db.Model类的功能属性
__tablename__ = 'users'
uid = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(64), unique=True, index=True)
###加入email属性，用来储存用户的email
username = db.Column(db.String(64), unique=True, index=True)
role_id = db.Column(db.Integer, db.ForeignKey('roles.id'))
password_hash = db.Column(db.String(128))
token = db.Column(db.String(256))
@property
def password(self):
raise AttributeError('password is not a readable attribute')
@password.setter
def password(self, password):
# 生成密码的哈希值
self.password_hash = generate_password_hash(password)
def verify_password(self, password):
return check_password_hash(self.password_hash, password)
# 一般token是存放到redis里的，这里没有装Redis
# 注意 ：存到redis里要设置过期时间：
def generate_auth_token(self, username, uid): # 生成token
payload = {'username': username, 'id': uid}
expires = datetime.timedelta(days=365)
access_token = create_access_token(
identity=payload, fresh=False,
expires_delta=False) # 生成token,关闭过期时间
return access_token
@staticmethod
def verify_auth_token(): # 验证token
try:
data = get_jwt_identity() # 解析token
except:
return None # valid token, but expired
user = User.query.get(data['username'])
return user
def __repr__(self):
return '<User %r>' % self.username
class User(UserMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), index=True, unique=True)
email = db.Column(db.String(128), index=True, unique=True)
password_hash = db.Column(db.String(128))
posts = db.relationship('Post', backref='author', lazy='dynamic')
about_me = db.Column(db.String(256), )
last_seen = db.Column(db.DateTime, default=datetime.utcnow)
def avatar(self, size):
digest = md5(self.email.lower().encode('utf-8')).hexdigest()
return 'https://www.gravatar.com/avatar/{}?d=identicon&s={}'.format(
digest, size)
def set_password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
def __repr__(self):
return '<user {}>'.format(self.username)
class CheckDetails(db.Model):
"""
hardware:硬件
system：系统
network：网络
service：服务
is_handle：是否处理
is_report：故障报告
alert_source：告警源
on_watch：值班人员
date：交班日期
"""
__tablename__ = 'check_details'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
hardware = db.Column(db.Text())
system = db.Column(db.Text())
network = db.Column(db.Text())
service = db.Column(db.Text())
is_handle = db.Column(db.Integer, default=1)
is_report = db.Column(db.Integer, default=0)
alert_source = db.Column(db.String(32))
classes = db.Column(db.String(32))
on_watch = db.Column(db.String(16))
date = db.Column(db.String(32))
def __repr__(self):
return '<CheckDetails %r>' % self.__tablename__
@staticmethod
def from_json(json_post):
"""由用户post的json数据返回checkdetail对象"""
hardware = json_post.get('hardware')
system = json_post.get('system')
network = json_post.get('network')
service = json_post.get('service')
is_handle = json_post.get('is_handle')
is_report = json_post.get('is_report')
alert_source = json_post.get('alert_source')
on_watch = json_post.get('on_watch')
date = json_post.get('date')
classes = json_post.get('classes')
return CheckDetails(hardware=hardware,
system=system,
network=network,
service=service,
is_handle=is_handle,
is_report=is_report,
alert_source=alert_source,
on_watch=on_watch,
date=date,
classes=classes)
class IdcCheckResult(db.Model):
"""
存储巡检结果:
temperature:温度
humidity:湿度
idc:机房
check_user:巡检人员
check_time:巡检时间
on_watch：值班人员
date：交班日期
"""
__tablename__ = 'idc_check_result'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
ca_temperature = db.Column(db.String(16))
ca_humidity = db.Column(db.String(16))
two_temperature = db.Column(db.String(16))
two_humidity = db.Column(db.String(16))
five_temperature = db.Column(db.String(16))
five_humidity = db.Column(db.String(16))
check_user = db.Column(db.String(32))
check_time = db.Column(db.DATETIME())
classes = db.Column(db.String(32))
on_watch = db.Column(db.String(16))
date = db.Column(db.String(32))
def __repr__(self):
return '<IdcCheckResult %r>' % self.__tablename__
@staticmethod
def from_json(json_post):
"""由用户post的json数据返回IdcCheckResult对象"""
ca_temperature = json_post.get('ca_temperature')
ca_humidity = json_post.get('ca_humidity')
two_temperature = json_post.get('two_temperature')
two_humidity = json_post.get('two_humidity')
five_temperature = json_post.get('five_temperature')
five_humidity = json_post.get('five_humidity')
check_user = json_post.get('check_user')
check_time = json_post.get('check_time')
on_watch = json_post.get('on_watch')
date = json_post.get('date')
classes = json_post.get('classes')
return IdcCheckResult(ca_temperature=ca_temperature,
ca_humidity=ca_humidity,
two_temperature=two_temperature,
two_humidity=two_humidity,
five_temperature=five_temperature,
five_humidity=five_humidity,
check_user=check_user,
check_time=check_time,
on_watch=on_watch,
date=date,
classes=classes)
class user(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), index=True, unique=True)
email = db.Column(db.String(120), index=True, unique=True)
password_hash = db.Column(db.String(128))
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
string1 = db.Column(db.String(100), nullable=False)
def __repr__(self):
return f"{self.string1}"