class Authority(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text)
roles = db.relationship('Role',
secondary=role_authority,
back_populates='authorities')
def to_json(self):
dict = self.__dict__
return dict
class Traffic(db.Model):
id = db.Column(db.Integer, primary_key=True)
pathId = db.Column(db.Integer)
queryTime = db.Column(db.DateTime)
# 距离，米
distance = db.Column(db.Float)
# 耗时，秒
duration = db.Column(db.Float)
def to_json(self):
dict = self.__dict__
return dict
class DrivePath(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text)
# 源地址的经纬度
origin = db.Column(db.Text)
# 目标地址的经纬度
dest = db.Column(db.Text)
#
subType = db.Column(db.Text)
def to_json(self):
dict = self.__dict__
return dict
class Role(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text)
authorities = db.relationship('Authority',
secondary=role_authority,
back_populates='roles')
users = db.relationship('User',
secondary=user_role,
back_populates='roles')
def to_json(self):
dict = self.__dict__
return dict
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text)
password = db.Column(db.Text)
lastLogintime = db.Column(db.DateTime)
roles = db.relationship('Role',
secondary=user_role,
back_populates='users')
def to_json(self):
dict = self.__dict__
# if "_sa_instance_state" in dict:
# del dict["_sa_instance_state"]
return dict
# # 枪的状态
# class GunStatus(db.Model):
# id = db.Column(db.Integer, primary_key=True)
# stationId = db.Column(db.Integer)
# queryTime = db.Column(db.DateTime)
# gunName = db.Column(db.Text)
# power = db.Column(db.Integer)
# status = db.Column(db.Integer)
# def to_json(self):
# dict = self.__dict__
# # if "_sa_instance_state" in dict:
# # del dict["_sa_instance_state"]
# return dict
user_role = db.Table(
'user_role', db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
db.Column('role_id', db.Integer, db.ForeignKey('role.id')))
# 用户
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text)
password = db.Column(db.Text)
lastLogintime = db.Column(db.DateTime)
roles = db.relationship('Role',
secondary=user_role,
back_populates='users')
def to_json(self):
dict = self.__dict__