import asyncio
import sys
from pathlib import Path

# Add project root to sys.path
sys.path.insert(0, str(Path(__file__).resolve().parent.parent))

import modules  # noqa: register all models
from sqlalchemy import select
from core.constants import ROLE_PERMISSIONS_MAP, SystemRole
from infrastructure.database.session import get_db_session
from modules.permissions.models import Permission, Role


async def seed_permissions_and_roles():
    print("🌱 Seeding permissions and roles...")
    async with get_db_session() as session:
        # Collect all unique permission codes
        unique_perms = set()
        for perms in ROLE_PERMISSIONS_MAP.values():
            unique_perms.update(perms)

        perm_objects = {}
        for code in unique_perms:
            stmt = select(Permission).where(Permission.code == code)
            res = await session.execute(stmt)
            perm = res.scalar_one_or_none()
            if not perm:
                perm = Permission(code=code, description=f"Permission for {code}")
                session.add(perm)
                await session.flush()
                print(f"  + Created permission: {code}")
            perm_objects[code] = perm

        # Create system roles (tenant_id = None means global/system template)
        for role_name, perms in ROLE_PERMISSIONS_MAP.items():
            stmt = select(Role).where(Role.tenant_id.is_(None), Role.name == role_name)
            res = await session.execute(stmt)
            role = res.scalar_one_or_none()
            if not role:
                role = Role(
                    tenant_id=None,
                    name=role_name,
                    description=f"Default system role for {role_name}",
                )
                role.permissions = [perm_objects[p] for p in perms if p in perm_objects]
                session.add(role)
                print(f"  + Created system role: {role_name}")
            else:
                role.permissions = [perm_objects[p] for p in perms if p in perm_objects]

        await session.commit()
    print("✅ Seeding completed successfully.")


if __name__ == "__main__":
    asyncio.run(seed_permissions_and_roles())
