tableWidgetDispalyRead.py 911 B

123456789101112131415161718
  1. from .flightDB import flightDB
  2. def tableWidgetDispalyRead(fdb:flightDB,date):
  3. if date == "1":
  4. tableWidgetDispalydata1 = fdb.queryTabel("display", "A", "ID = '1'")[0][0] if len(
  5. fdb.queryTabel("display", "A", "ID = '1'")) != 0 else {}
  6. if date == "2":
  7. tableWidgetDispalydata1 = fdb.queryTabel("display", "A", "ID = '2'")[0][0] if len(
  8. fdb.queryTabel("display", "A", "ID = '2'")) != 0 else {}
  9. if date == "3":
  10. tableWidgetDispalydata1 = fdb.queryTabel("display", "A", "ID = '3'")[0][0] if len(
  11. fdb.queryTabel("display", "A", "ID = '3'")) != 0 else {}
  12. if "\'" in tableWidgetDispalydata1:
  13. tableWidgetDispalydata1 = tableWidgetDispalydata1.replace("\'", '"')
  14. tableWidgetDispalydata1 = tableWidgetDispalydata1.replace("'", '"')
  15. tableWidgetDispalydata1 = eval(tableWidgetDispalydata1)
  16. return tableWidgetDispalydata1