YvvandClaude Opus 5.5
67ddee28b2
- crates/ld-engine : formule inertielle (parité avec la maquette, garde C), coquille / changement de fond, assistant d'édition à règles, composition d'un document sous vote permanent (adoptions, aperçus, rivales). - crates/trustin-access : qui voit, qui ouvre, qui gère les accès. - crates/ld-server : API axum + SQLite, connexion Ğ1 (client OAuth2 de connect.monnaie-libre.fr), invitations, entrée en vigueur automatique, signalements de contradiction, traductions éditoriales, publication git, taille de la toile lue sur la chaîne. - seeds/acte-engagement-certification.json : 33 articles, fr + en + es ; en vigueur : préambule, E1, E2 (seed a minima). - maquette/ : frontend, backend et docker v2 déplacés tels quels. Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
61 lines
1.8 KiB
Python
61 lines
1.8 KiB
Python
"""Organization service: CRUD + membership helpers."""
|
|
|
|
from __future__ import annotations
|
|
|
|
import uuid
|
|
from typing import Sequence
|
|
|
|
from sqlalchemy import select
|
|
from sqlalchemy.ext.asyncio import AsyncSession
|
|
|
|
from app.models.organization import OrgMember, Organization
|
|
|
|
|
|
async def list_organizations(db: AsyncSession) -> Sequence[Organization]:
|
|
result = await db.execute(select(Organization).order_by(Organization.name))
|
|
return result.scalars().all()
|
|
|
|
|
|
async def get_organization(db: AsyncSession, org_id: uuid.UUID) -> Organization | None:
|
|
return await db.get(Organization, org_id)
|
|
|
|
|
|
async def get_organization_by_slug(db: AsyncSession, slug: str) -> Organization | None:
|
|
result = await db.execute(select(Organization).where(Organization.slug == slug))
|
|
return result.scalar_one_or_none()
|
|
|
|
|
|
async def create_organization(db: AsyncSession, **kwargs) -> Organization:
|
|
org = Organization(**kwargs)
|
|
db.add(org)
|
|
await db.commit()
|
|
await db.refresh(org)
|
|
return org
|
|
|
|
|
|
async def is_member(db: AsyncSession, org_id: uuid.UUID, identity_id: uuid.UUID) -> bool:
|
|
result = await db.execute(
|
|
select(OrgMember).where(
|
|
OrgMember.org_id == org_id,
|
|
OrgMember.identity_id == identity_id,
|
|
)
|
|
)
|
|
return result.scalar_one_or_none() is not None
|
|
|
|
|
|
async def add_member(
|
|
db: AsyncSession, org_id: uuid.UUID, identity_id: uuid.UUID, role: str = "member"
|
|
) -> OrgMember:
|
|
member = OrgMember(org_id=org_id, identity_id=identity_id, role=role)
|
|
db.add(member)
|
|
await db.commit()
|
|
await db.refresh(member)
|
|
return member
|
|
|
|
|
|
async def list_members(db: AsyncSession, org_id: uuid.UUID) -> Sequence[OrgMember]:
|
|
result = await db.execute(
|
|
select(OrgMember).where(OrgMember.org_id == org_id).order_by(OrgMember.created_at)
|
|
)
|
|
return result.scalars().all()
|