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__