wrappers.py 1.1 KB

1234567891011121314151617181920212223242526272829303132
  1. from contextvars import ContextVar
  2. from peewee import *
  3. from playhouse.db_url import connect
  4. from playhouse.pool import PooledPostgresqlExtDatabase
  5. from playhouse.pool import PooledSqliteDatabase
  6. db_state_default = {"closed": None, "conn": None, "ctx": None, "transactions": None}
  7. db_state = ContextVar("db_state", default=db_state_default.copy())
  8. class PeeweeConnectionState(object):
  9. def __init__(self, **kwargs):
  10. super().__setattr__("_state", db_state)
  11. super().__init__(**kwargs)
  12. def __setattr__(self, name, value):
  13. self._state.get()[name] = value
  14. def __getattr__(self, name):
  15. value = self._state.get()[name]
  16. return value
  17. def register_connection(db_url):
  18. db = connect(db_url)
  19. if isinstance(db, PostgresqlDatabase):
  20. # Directly use PostgresqlDatabase without pooling
  21. db.autoconnect = True
  22. elif isinstance(db, SqliteDatabase):
  23. # Directly use SqliteDatabase without pooling
  24. db.autoconnect = True
  25. else:
  26. raise ValueError('Unsupported database connection')
  27. return db