python-fastapi-mm-zhcs-yj-api/common/db/db_emergency_plan.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
from sqlalchemy.orm import Session
from sqlalchemy import text, exists, and_, or_, not_
from sqlalchemy.sql import func
from database import get_db
from models import *
from extensions import logger
from utils import *

def get_plan_name_by_id(db: Session, plan_id: int) -> str:
    row = db.query(EmergencyPlan).filter(EmergencyPlan.id == plan_id).first()
    if row is not None:
        return row.plan_name
    
    return ''