fastapi-users-db-sqlalchemy

fastapi-users-db-sqlalchemy copied to clipboard

Synchronous Session support.

4

This PR implements support for SQLAlchemy synchronous `Session`, alongside existing support for `AsyncSession`. Based on @frankie567's answer in this discussion on "Synchronous SQLAlchemy?": https://github.com/fastapi-users/fastapi-users/discussions/1144#discussioncomment-4653607 * Copied `SQLAlchemyUserDatabase` --> `SQLAlchemySynchronousUserDatabase` and...

fotinakis

The email index is not used by `get_by_email()` method

2

## Describe the bug An index is created on the `email` field: https://github.com/fastapi-users/fastapi-users-db-sqlalchemy/blob/main/fastapi_users_db_sqlalchemy/__init__.py#L61 but the index can't be used by the `get_by_email()` method because the filtering uses a function on...

stephane

let’s not hardcode OAuthAccount type and use the protocol instead.

mchataigner

Hack on typing returns typing error on sqlalchemy `where` clause

1

## Describe the bug Currently the code hacks the handling of `User` attributes with a condition on `TYPE_CHECKING`. This hack should no longer exist because mypy now handles sqlalchemy field...

8area8

Happens only when using Postgresql, with Sqlite there are no problems. Problem exists probably also in other implementations (e.g. sqlmodel)

jenreh

fix: add mapped types in TYPE_CHECKING block for all cols

1

Hi @frankie567 👋🏻 I've been playing with fastapi-users and I have to remove unique constaint on email col due to soft deletes. Hence, I added my own email col however...

jd-solanki

This pull request increases the maximum length of the access_token and refresh_token fields in the SQLAlchemy OAuth account model from 1024 to 4096 characters. OAuth2 providers using long JWT tokens...

DarshanKumarGP

OAuth access_token and refresh_token columns too short for long RS256 tokens (VARCHAR(1024))

1

## Describe the bug When using OAuth2 providers such as Authentik with RS256-signed access tokens, the access_token (and sometimes refresh_token) exceeds 1024 characters. This results in a StringDataRightTruncation error in...

Sohail342

When using OAuth2 providers such as Authentik with RS256-signed access tokens, the access_token (and sometimes refresh_token) exceeds 1024 characters. This results in a StringDataRightTruncation error in PostgreSQL: ```bash psycopg.errors.StringDataRightTruncation: value...

Sohail342

This PR updates the `SQLAlchemyBaseOAuthAccountTable` class to increase the maximum length of the access and refresh token fields from 1024 to 4096 chars. This is necessary because, OAuth2 providers like...

maxdorninger