belgie-alchemy 0.11.0

SQLAlchemy building blocks for Belgie

Belgie Alchemy

[!WARNING] Belgie Alchemy is a low-level SQLAlchemy layer. You own the concrete models, migrations, and schema changes in your app. It provides mixins and adapters, not a database framework.

Belgie Alchemy is the SQLAlchemy package behind Belgie's auth, organization, and team features. It gives you explicit adapter wiring and small composable mixins so you can build app-owned models without giving up type safety or clear schema boundaries.

Installation

uv add belgie[alchemy]

uv add belgie[alchemy,organization,team]

[!NOTE] Application code should import from belgie.alchemy. The implementation package is belgie_alchemy, but the public re-exports live under belgie.alchemy.

What It Provides

• BelgieAdapter for core auth records.
• OrganizationAdapter for organization membership and invitations.
• TeamAdapter for organization-scoped teams.
• UserMixin, AccountMixin, SessionMixin, and OAuthStateMixin for auth models.
• OrganizationMixin, OrganizationMemberMixin, and OrganizationInvitationMixin for organization models.
• TeamMixin and TeamMemberMixin for team models.

Quick Start

from brussels.base import DataclassBase
from brussels.mixins import PrimaryKeyMixin, TimestampMixin

from belgie.alchemy import AccountMixin, BelgieAdapter, OAuthStateMixin, SessionMixin, UserMixin


class User(DataclassBase, PrimaryKeyMixin, TimestampMixin, UserMixin):
    pass


class Account(DataclassBase, PrimaryKeyMixin, TimestampMixin, AccountMixin):
    pass


class Session(DataclassBase, PrimaryKeyMixin, TimestampMixin, SessionMixin):
    pass


class OAuthState(DataclassBase, PrimaryKeyMixin, TimestampMixin, OAuthStateMixin):
    pass


adapter = BelgieAdapter(
    user=User,
    account=Account,
    session=Session,
    oauth_state=OAuthState,
)

This keeps your schema in your application while Belgie handles the adapter contract. You can add custom columns and relationships on top of the mixins without changing how the adapter works.

Auth Models

The auth mixins map to the common Belgie records:

• UserMixin adds email, profile, scopes, and related account/session/state relationships.
• AccountMixin stores provider linkage and token fields.
• SessionMixin stores session expiry plus request metadata.
• OAuthStateMixin stores OAuth state, PKCE verifier, redirect URL, and optional user linkage.

The default PostgreSQL variants use CITEXT for case-insensitive email, provider, and provider_account_id columns.

[!NOTE] If you use the default PostgreSQL column variants, make sure the citext extension is installed in your database.

Organization And Team

Use the organization and team mixins when your app needs shared org membership plus team-scoped access:

[!NOTE] The snippet below assumes you have already defined User, Account, Session, OAuthState, Organization, OrganizationMember, OrganizationInvitation, Team, and TeamMember from the mixins above.

from belgie.alchemy import (
    AccountMixin,
    BelgieAdapter,
    OAuthStateMixin,
    OrganizationInvitationMixin,
    OrganizationMemberMixin,
    OrganizationMixin,
    SessionMixin,
    TeamMemberMixin,
    TeamMixin,
    UserMixin,
)
from belgie.alchemy.organization import OrganizationAdapter
from belgie.alchemy.team import TeamAdapter

core_adapter = BelgieAdapter(
    user=User,
    account=Account,
    session=Session,
    oauth_state=OAuthState,
)

organization_adapter = OrganizationAdapter(
    core=core_adapter,
    organization=Organization,
    member=OrganizationMember,
    invitation=OrganizationInvitation,
)

team_adapter = TeamAdapter(
    core=core_adapter,
    organization_adapter=organization_adapter,
    team=Team,
    team_member=TeamMember,
)

When you enable both plugins, use the team-capable adapter for both. If you only need organizations, the organization adapter is sufficient.

The default PostgreSQL variants also use CITEXT for organization slug values and pending invitation email addresses. Pending invitations are unique per (organization_id, email) while their status is pending.

Examples

• examples/alchemy/auth_models.py for a compact auth-model reference.
• examples/organization_team for a runnable organization + team app.