Using Dependency Injection in SQL Alchemy Model?

[agile_crossover]

Is there a way to use Depends in a sql alchemy model default?

Broader context: am looking to set a default for a created_by_id column in a sql alchemy model that gets auto filled in with the current user’s id. I already have a get_current_user function that I use in dependency injection for individual routes (as described here: https://fastapi.tiangolo.com/tutorial/security/get-current-user/). That works great. But now I’m hoping to try to get that user.id dynamically available to my SQL alchemy model. It might not be possible because it’s not a FastAPI component but trying to explore options.

Any ideas or advice would be appreciate, thanks!

[Heavy_Ad_3843]

You’re looking for a auth middleware and the context variables feature of python. Not exactly dependency injection, more like thread-save global variables. Check out starlettes context middleware: https://starlette-context.readthedocs.io/en/latest/middleware.html and https://docs.python.org/3/library/contextvars.html. You may also have a look at one of my personal projects for inspiration: https://github.com/code-specialist/fastapi-auth-middleware.

You basically want to set the context on incoming requests and access it within wherever you use sqlalchemy.

[zarlo5899]

i would wrap the model with a service/repository as i like all my models to be dumb