from typing import Optional, Sequence
from uuid import UUID
from sqlalchemy import select, and_
from sqlalchemy.ext.asyncio import AsyncSession
from modules.tenants.models import Tenant, TenantMember, Invitation


class TenantRepository:
    def __init__(self, db: AsyncSession):
        self.db = db

    async def get_by_id(self, tenant_id: UUID) -> Optional[Tenant]:
        stmt = select(Tenant).where(Tenant.id == tenant_id)
        result = await self.db.execute(stmt)
        return result.scalar_one_or_none()

    async def get_by_slug(self, slug: str) -> Optional[Tenant]:
        stmt = select(Tenant).where(Tenant.slug == slug.lower().strip())
        result = await self.db.execute(stmt)
        return result.scalar_one_or_none()

    async def create(self, tenant: Tenant) -> Tenant:
        self.db.add(tenant)
        await self.db.flush()
        return tenant


class TenantMemberRepository:
    def __init__(self, db: AsyncSession):
        self.db = db

    async def create(self, member: TenantMember) -> TenantMember:
        self.db.add(member)
        await self.db.flush()
        return member

    async def get_membership(self, tenant_id: UUID, user_id: UUID) -> Optional[TenantMember]:
        stmt = select(TenantMember).where(
            TenantMember.tenant_id == tenant_id,
            TenantMember.user_id == user_id,
            TenantMember.is_active == True,
        )
        result = await self.db.execute(stmt)
        return result.scalar_one_or_none()

    async def get_user_memberships(self, user_id: UUID) -> Sequence[TenantMember]:
        stmt = (
            select(TenantMember)
            .where(TenantMember.user_id == user_id, TenantMember.is_active == True)
        )
        result = await self.db.execute(stmt)
        return result.scalars().all()

    async def get_tenant_members(self, tenant_id: UUID) -> Sequence[TenantMember]:
        stmt = (
            select(TenantMember)
            .where(TenantMember.tenant_id == tenant_id, TenantMember.is_active == True)
        )
        result = await self.db.execute(stmt)
        return result.scalars().all()

    async def delete_membership(self, tenant_id: UUID, user_id: UUID) -> bool:
        membership = await self.get_membership(tenant_id, user_id)
        if membership:
            membership.is_active = False
            await self.db.flush()
            return True
        return False
