python-fastapi-mm-zhcs-yj-api/utils/riskManagement_uitl.py

from models import *

def area_code_get_ancestors_names(db,area_info, ancestors_name=''):
    print(area_info)
    if area_info is None:
        print(ancestors_name)
        return ancestors_name

    else:
        ancestors_name = area_info.area_name + ancestors_name
        return area_code_get_ancestors_names(db,area_code_get_area_info(db,area_info.parent_code), ancestors_name)

def area_code_get_area_info(db,area_code):
    # 机构id获取机构信息
    query = db.query(GovdataArea)
    query = query.filter(GovdataArea.status == '1')
    query = query.filter(GovdataArea.area_code == area_code)
    return query.first()