db.py 525 B

123456789101112131415161718192021222324252627
  1. """数据库连接(只读告警数据)。"""
  2. import pymysql
  3. from config import (
  4. DB_CONNECT_TIMEOUT,
  5. DB_HOST,
  6. DB_NAME,
  7. DB_PASSWORD,
  8. DB_PORT,
  9. DB_USER,
  10. )
  11. def connect():
  12. return pymysql.connect(
  13. host=DB_HOST,
  14. port=DB_PORT,
  15. user=DB_USER,
  16. password=DB_PASSWORD,
  17. database=DB_NAME,
  18. charset="utf8mb4",
  19. cursorclass=pymysql.cursors.DictCursor,
  20. connect_timeout=DB_CONNECT_TIMEOUT,
  21. read_timeout=600,
  22. autocommit=True,
  23. )