INFO w/ solution: Authentication breaks with sqlalchemy 2.0.38

[marco-jeffrey]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched in the documentation/README.
• I already searched in Google "How to do X" and didn't find any information.
• I already read and followed all the tutorial in the docs/README and didn't find an answer.

Commit to Help

• I commit to help with one of those options 👆

Example Code

None, just install with latest libs and try to trigger any endpoint that has get_current_user dep

Description

I just got the latest template running locally. Authentication breaks when trying to receive the user from the db by id in backend/app/api/deps.py:get_current_user

this is the current implementation:

def get_current_user(session: SessionDep, token: TokenDep) -> User:
    try:
        payload = jwt.decode(
            token, settings.SECRET_KEY, algorithms=[security.ALGORITHM]
        )
        token_data = TokenPayload(**payload)
    except (InvalidTokenError, ValidationError):
        raise HTTPException(
            status_code=status.HTTP_403_FORBIDDEN,
            detail="Could not validate credentials",
        )
    user = session.get(User, token_data.sub)
    if not user:
        raise HTTPException(status_code=404, detail="User not found")
    if not user.is_active:
        raise HTTPException(status_code=400, detail="Inactive user")
    return user

with the new sqlalchemy version 2.0.38 the session.get now expects the id to be passed as a UUID instance and not a string.

To fix it for me locally i just create an instance of the UUID to pass as the parameter. I have not tested yet if this breaks with earlier versions. Ofc we could also pin sqlalchemy<2.0.38

I dont think i know enough about the libs to make any suggestions

Operating System

macOS

Operating System Details

None

Python Version

3.13

Additional Context

No response

[marco-jeffrey]

Ok, maybe i was a bit too quick with the post. I just checked the other past versions until sqlalchemy 2.0.35 and they all dont work. The reason is probably that i changed to sqlite locally because postgres makes no sense for me, although I would have thought that DBs would be interchangeable here in the template. Still maybe it will help others changing to sqlite for development

Shall I delete or leave it up?