图1图2图3ormclassSelect(db.Model):__tablename__='select_project'#表名select_id=db.Column(db.Integer,primary_key=True,autoincrement=True)select_name=db.Column(db.String(200),nullable=False)#类别名称，不能为空roles=db.Column(db.Integer,nullable=False)#级别，不能为空defsingle_to_dict(self):return{c.name:getattr(self,c.name)forcinself.__table__.columns}defto_dict(self):model_dict=dict(self.__dict__)delmodel_dict['_sa_instance_state']returnmodel_dictclassResources(db.Model):__tablename__='resources'#tablenameid=db.Column(db.Integer,primary_key=True,autoincrement=True)resources_name=db.Column(db.String(200),nullable=False)#类别名称，不能为空parent_id=db.Column(db.integer,nullable=False)#父id，不能为空。###obj到jsondefto_json_all(msg:list):importjsondata={}iftype(msg)==list:foriinrange(len(msg)):temp_dict={}j=0对于k,vinmsg[i].__dict__.items():ifj>0:temp_dict[k]=vj+=1data[i]=temp_dictelse:temp_dict={}j=0fork,vinmsg.__dict__.items():如果j>0:temp_dict[k]=vj+=1data[0]=temp_dictreturnjson.dumps(data,ensure_ascii=False)select_projectresourcesview@silence.route('/silence_add',methods=['GET'])@silence.route('/silence_add/',methods=['GET'])@login_required@permission_required(Permission.AVERAGE_USER)defsilence_add1():returnrender_template('silence_add.html',select_project=Select.query.all())@silence.route('/select_project/',methods=['POST'])defselect_project1():select_id=request.form.get('select_id')#接收ajax提交的数据--地区idprint("##id",select_id)resources_obj=Resources.query.filter_by(parent_id=select_id).all()#resources_json=resources_obj.single_to_dict()data=to_json_all(resources_obj)#打包成json格式print("##data",data)returndatahtml
