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

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
from models import *

def get_person_info_by_id(db,id):
    query = db.query(ThreeProofingResponsiblePerson)
    query = query.filter_by(id = id,del_flag = '0')
    return query.first()
def get_type_info_by_id(db,id):
    query = db.query(ThreeProofingResponsibleType)
    query = query.filter_by(id = id,del_flag = '0')
    return query.first()
def get_type_parent_id_by_type_id(db,type_id):
    query = db.query(ThreeProofingResponsibleType)
    query = query.filter_by(id = type_id,del_flag = '0')
    return query.first().type_parent_id
def get_person_type_by_person_id(db,person_id):
    query = db.query(ThreeProofingResponsiblePersonType)
    query = query.filter_by(person_id = person_id,del_flag = '0')
    return query.all()
def get_person_list_by_type_parent_id(db,type_parent_id):
    query = db.query(ThreeProofingResponsiblePersonType)
    query = query.filter_by(type_parent_id = type_parent_id,del_flag = '0')
    return [info.person_id for info in query.all()]
def get_type_parent_id_by_person_id(db,person_id):
    query = db.query(ThreeProofingResponsiblePersonType)
    query = query.filter_by(person_id=person_id, del_flag='0')
    return [info.type_parent_id for info in query.all()]
def id_get_area_info(db,id):
    query = db.query(GovdataArea)
    query = query.filter(GovdataArea.id == id)
    return query.first()