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 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 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 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 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): __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 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 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 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(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 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): 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(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 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(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}"