app.db¶

Attributes¶

`DATABASE_URL`
`Base`
`engine`
`async_session_maker`

Classes¶

`User`	Base SQLAlchemy users table definition.
`Entry`

Functions¶

`create_db_and_tables`()
`get_async_session`(...)
`get_entry_db`([session])
`get_user_db`([session])

Module Contents¶

app.db.DATABASE_URL¶

app.db.Base: sqlalchemy.ext.declarative.DeclarativeMeta¶

class app.db.User¶

Bases: fastapi_users.db.SQLAlchemyBaseUserTableUUID, Base

Base SQLAlchemy users table definition.

__tablename__ = 'user'¶

nickname: sqlalchemy.orm.Mapped[str]¶

class app.db.Entry¶

Bases: Base

__tablename__ = 'entry'¶

id: sqlalchemy.orm.Mapped[int]¶

account_id: sqlalchemy.orm.Mapped[sqlalchemy.UUID]¶

account_email: sqlalchemy.orm.Mapped[str]¶

account_name: sqlalchemy.orm.Mapped[str]¶

score: sqlalchemy.orm.Mapped[int]¶

problem: sqlalchemy.orm.Mapped[str]¶

variant: sqlalchemy.orm.Mapped[str]¶

app.db.engine¶

app.db.async_session_maker¶

async app.db.create_db_and_tables()¶

async app.db.get_async_session() → collections.abc.AsyncGenerator[sqlalchemy.ext.asyncio.AsyncSession, None]¶

async app.db.get_entry_db(session: sqlalchemy.ext.asyncio.AsyncSession = Depends(get_async_session))¶

async app.db.get_user_db(session: sqlalchemy.ext.asyncio.AsyncSession = Depends(get_async_session))¶