db_dict.py 538 B

12345678910111213141516
  1. #!/usr/bin/env python3
  2. # -*- coding: utf-8 -*-
  3. from sqlalchemy.orm import Session
  4. from sqlalchemy import text, exists, and_, or_, not_
  5. from sqlalchemy.sql import func
  6. from database import get_db
  7. from extensions import logger
  8. import random
  9. from models import *
  10. def get_dict_label(db: Session, dict_type: str, dict_value: str) -> str:
  11. row = db.query(SysDictData).filter(and_(SysDictData.dict_type == dict_type, SysDictData.dict_value == dict_value)).first()
  12. if row is None:
  13. return ''
  14. else:
  15. return row.dict_label