db.py 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. from sqlalchemy import create_engine, event
  2. from sqlalchemy.orm import Session, declarative_base, sessionmaker
  3. from .config import settings
  4. from .logging_setup import db_operation, db_query, log_query_error, query_origin
  5. def install_engine_logging(engine):
  6. if getattr(engine, '_gc_logging', False): return
  7. engine._gc_logging = True
  8. @event.listens_for(engine, 'before_cursor_execute')
  9. def executing(conn, cursor, statement, parameters, context, executemany):
  10. context._gc_operation = 'execute'
  11. @event.listens_for(engine, 'after_cursor_execute')
  12. def executed(conn, cursor, statement, parameters, context, executemany):
  13. context._gc_operation = 'fetch'
  14. @event.listens_for(engine, 'handle_error')
  15. def query_failed(context):
  16. # Observational only: never replace exceptions or affect connection invalidation.
  17. error = context.sqlalchemy_exception or context.original_exception
  18. options = getattr(context.execution_context, 'execution_options', {}) or {}
  19. active = db_query.get() or {}
  20. statement = context.statement if context.statement is not None else active.get('statement')
  21. log_query_error(error, statement, options.get('query_name') or active.get('query_name'),
  22. db_operation.get() or getattr(context.execution_context, '_gc_operation', 'connect_or_transaction'))
  23. class LoggingSession(Session):
  24. def execute(self, statement, params=None, *, execution_options=None, **kwargs):
  25. options = dict(execution_options or {})
  26. origin = options.setdefault('query_name', getattr(statement, '_execution_options', {}).get('query_name') or query_origin())
  27. token = db_operation.set('execute')
  28. query_token = db_query.set({'statement': statement, 'query_name': origin})
  29. try:
  30. return super().execute(statement, params, execution_options=options, **kwargs)
  31. except Exception as error:
  32. log_query_error(error, statement, origin, 'execute')
  33. raise
  34. finally:
  35. db_query.reset(query_token)
  36. db_operation.reset(token)
  37. def _transaction_operation(self, operation):
  38. token = db_operation.set(operation)
  39. try:
  40. return getattr(super(), operation)()
  41. except Exception as error:
  42. log_query_error(error, operation=operation)
  43. raise
  44. finally:
  45. db_operation.reset(token)
  46. def commit(self): return self._transaction_operation('commit')
  47. def rollback(self): return self._transaction_operation('rollback')
  48. def flush(self, objects=None):
  49. token = db_operation.set('flush')
  50. try:
  51. return super().flush(objects)
  52. except Exception as error:
  53. log_query_error(error, operation='flush')
  54. raise
  55. finally:
  56. db_operation.reset(token)
  57. engine = create_engine(
  58. settings.DATABASE_URL,
  59. connect_args={"check_same_thread": False} if settings.DATABASE_URL.startswith("sqlite") else {},
  60. hide_parameters=True,
  61. )
  62. install_engine_logging(engine)
  63. SessionLocal = sessionmaker(bind=engine, class_=LoggingSession, autoflush=False, autocommit=False)
  64. Base = declarative_base()
  65. def get_session():
  66. db = SessionLocal()
  67. try:
  68. yield db
  69. finally:
  70. db.close()