Error while adding access token to the database: AttributeError: 'function' object has no attribute 'create'

[NateXVI]

I recreated the full example from the documentation. Now I am trying to switch the transport to a cookie transport (which seems to have worked) and the strategy to the database strategy (which is not working).

After making a user and then trying to sign in results in this error:

Traceback (most recent call last):
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/uvicorn/protocols/http/httptools_impl.py", line 426, in run_asgi
    result = await app(  # type: ignore[func-returns-value]
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/uvicorn/middleware/proxy_headers.py", line 84, in __call__
    return await self.app(scope, receive, send)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/fastapi/applications.py", line 292, in __call__
    await super().__call__(scope, receive, send)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/applications.py", line 122, in __call__
    await self.middleware_stack(scope, receive, send)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/middleware/errors.py", line 184, in __call__
    raise exc
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/middleware/errors.py", line 162, in __call__
    await self.app(scope, receive, _send)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/middleware/cors.py", line 91, in __call__
    await self.simple_response(scope, receive, send, request_headers=headers)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/middleware/cors.py", line 146, in simple_response
    await self.app(scope, receive, send)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/middleware/exceptions.py", line 79, in __call__
    raise exc
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/middleware/exceptions.py", line 68, in __call__
    await self.app(scope, receive, sender)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/fastapi/middleware/asyncexitstack.py", line 20, in __call__
    raise e
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/fastapi/middleware/asyncexitstack.py", line 17, in __call__
    await self.app(scope, receive, send)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/routing.py", line 718, in __call__
    await route.handle(scope, receive, send)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/routing.py", line 276, in handle
    await self.app(scope, receive, send)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/starlette/routing.py", line 66, in app
    response = await func(request)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/fastapi/routing.py", line 273, in app
    raw_response = await run_endpoint_function(
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/fastapi/routing.py", line 190, in run_endpoint_function
    return await dependant.call(**values)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/fastapi_users/router/auth.py", line 69, in login
    response = await backend.login(strategy, user)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/fastapi_users/authentication/backend.py", line 45, in login
    token = await strategy.write_token(user)
  File "/home/user/tests/fastapi-users-creating-session-error/.venv/lib/python3.10/site-packages/fastapi_users/authentication/strategy/db/strategy.py", line 45, in write_token
    access_token = await self.database.create(access_token_dict)
AttributeError: 'function' object has no attribute 'create'

It seems like there is a problem with the session returned from get_access_token_db, but I've looked over my code and the docs multiple times and I can't figure it out.

Here is a link to a repo with the bare bones code: https://github.com/NateXVI/fastapi-users-creating-session-error

[NateXVI]

I figured out the problem. I passed the get_access_token_db function into the DatabaseStrategy class, but I needed to pass the database session returned from the function instead.

-  def get_db_strategy() -> DatabaseStrategy:
-     return DatabaseStrategy(get_access_token_db, lifetime_seconds=3600)
+ def get_db_strategy(session=Depends(get_access_token_db)) -> DatabaseStrategy:
+     return DatabaseStrategy(session, lifetime_seconds=3600)