db_healthcheck.py 732 B

123456789101112131415161718192021222324252627282930
  1. import logging
  2. from sqlalchemy import text
  3. from sqlalchemy.exc import OperationalError
  4. from app import db
  5. # Set up logger
  6. logger = logging.getLogger(__name__)
  7. def check_database_connection():
  8. """检查数据库连接状态"""
  9. try:
  10. with db.engine.connect() as connection:
  11. connection.execute(text("SELECT 1"))
  12. return True
  13. except OperationalError as e:
  14. logger.error(f"数据库连接失败: {str(e)}")
  15. return False
  16. def check_db_connection():
  17. try:
  18. with db.engine.connect() as conn:
  19. conn.execute(text("SELECT 1"))
  20. return True
  21. except OperationalError as e:
  22. logger.error(f"数据库连接失败: {str(e)}")
  23. return False