class User(UserMixin, db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(64), unique=True, index=True)
username = db.Column(db.String(64), unique=True, index=True)
password_hash = db.Column(db.String(128))
chinese_name = db.Column(db.String(64))
cellphone = db.Column(db.String(64))
actived = db.Column(db.Boolean, default=False)
position = db.Column(db.String(64))
location = db.Column(db.String(64))
acitve = db.Column(db.Integer)
admin = db.Column(db.Integer, index=True, default=0)
member_since = db.Column(db.DateTime(), default=datetime.now)
last_seen = db.Column(db.DateTime(), default=datetime.now)
@property
def password(self):
raise AttributeError('密码禁止读取！')
@password.setter
def password(self, password):
self.password_hash = generate_password_hash(password)
def verify_password(self, password):
if self.password_hash is None:
return False
return check_password_hash(self.password_hash, password)
class User(UserMixin, db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(64), unique=True, index=True)
username = db.Column(db.String(64), unique=True, index=True)
chinese_name = db.Column(db.String(64))
cellphone = db.Column(db.String(64))
actived = db.Column(db.Boolean, default=False)
position = db.Column(db.String(64))
location = db.Column(db.String(64))
acitve = db.Column(db.Integer)
admin = db.Column(db.Integer, index=True, default=0)
member_since = db.Column(db.DateTime(), default=datetime.now)
last_seen = db.Column(db.DateTime(), default=datetime.now)
class Record(db.Model):
__tablename__ = 'dns_records'
id = db.Column(db.Integer, primary_key=True)
record_id = db.Column(db.String(64), index=True)
host = db.Column(db.String(64))
record_type = db.Column(db.String(64))
TTL = db.Column(db.String(64))
value = db.Column(db.String(64))
line_type = db.Column(db.String(64), default='')
comment = db.Column(db.String(64))
creator = db.Column(db.String(64))
updator = db.Column(db.String(64))
status = db.Column(db.String(64), default='enabled')
enabled = db.Column(db.String(64), default='1')
alive = db.Column(db.String(64), default='ON')
create_time = db.Column(db.DateTime(), default=datetime.now)
update_time = db.Column(db.DateTime(), default=datetime.now)
zone_id = db.Column(db.Integer, db.ForeignKey('dns_zones.id'))
class Logs(db.Model):
__tablename__ = 'logs'
id = db.Column(db.Integer, primary_key=True)
operation_time = db.Column(db.DateTime(), default=datetime.now)
operation_type = db.Column(db.String(64))
operator = db.Column(db.String(64))
target_type = db.Column(db.String(64))
target_name = db.Column(db.String(64))
target_id = db.Column(db.String(64))
target_detail = db.Column(db.Text())