import os
from typing import Generator

os.environ.setdefault("WEB_SENTINEL_POSTGRES_URL", "sqlite:///./test_admin_clients.db")
os.environ.setdefault("WEB_SENTINEL_ADMIN_JWT_SECRET", "test-secret")

from fastapi.testclient import TestClient
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

from admin.backend.app.database import get_session
from admin.backend.app.main import create_app
from admin.backend.app.models import Base
from admin.backend.app.models.admin_user import AdminUser
from admin.backend.app.models.license import License
from admin.backend.app.security import hash_password

engine = create_engine(os.environ["WEB_SENTINEL_POSTGRES_URL"], future=True)
TestingSession = sessionmaker(bind=engine, autoflush=False, autocommit=False, future=True)

Base.metadata.create_all(bind=engine)


def override_session() -> Generator:
    db = TestingSession()
    try:
        yield db
    finally:
        db.close()


app = create_app()
app.dependency_overrides[get_session] = override_session
client = TestClient(app)


def setup_module() -> None:
    Base.metadata.create_all(bind=engine)
    with TestingSession() as session:
        session.query(License).delete()
        session.query(AdminUser).delete()
        session.add(
            AdminUser(
                email="sysop@web-sentinel.com",
                hashed_password=hash_password("secret"),
                role="super-admin",
            )
        )
        session.add_all(
            [
                License(email="client1@example.com", api_key="ws_live_1", tier="PRO", status="active"),
                License(email="client1@example.com", api_key="ws_live_2", tier="PRO", status="active"),
                License(email="client2@example.com", api_key="ws_live_3", tier="FREE", status="suspended"),
            ]
        )
        session.commit()


def teardown_module() -> None:
    Base.metadata.drop_all(bind=engine)


def _login() -> str:
    response = client.post(
        "/api/v1/auth/login",
        data={"username": "sysop@web-sentinel.com", "password": "secret"},
        headers={"Content-Type": "application/x-www-form-urlencoded"},
    )
    assert response.status_code == 200
    return response.json()["access_token"]


def test_list_clients_with_filters_and_detail():
    token = _login()
    response = client.get("/api/v1/clients/", headers={"Authorization": f"Bearer {token}"})
    assert response.status_code == 200
    data = response.json()
    assert data["total"] == 2
    assert any(item["email"] == "client1@example.com" for item in data["items"])

    filtered = client.get(
        "/api/v1/clients/",
        params={"status": "active"},
        headers={"Authorization": f"Bearer {token}"},
    )
    assert filtered.status_code == 200
    filtered_data = filtered.json()
    assert filtered_data["total"] == 1
    assert filtered_data["items"][0]["email"] == "client1@example.com"

    detail = client.get(
        "/api/v1/clients/client1@example.com",
        headers={"Authorization": f"Bearer {token}"},
    )
    assert detail.status_code == 200
    detail_payload = detail.json()
    assert detail_payload["total_licenses"] == 2
    assert len(detail_payload["licenses"]) == 2


def test_create_invite_export_and_reset_clients():
    token = _login()
    created = client.post(
        "/api/v1/clients/",
        json={"email": "client-new@example.com", "tier": "starter"},
        headers={"Authorization": f"Bearer {token}"},
    )
    assert created.status_code == 201
    created_payload = created.json()
    assert created_payload["email"] == "client-new@example.com"

    duplicate = client.post(
        "/api/v1/clients/",
        json={"email": "client-new@example.com"},
        headers={"Authorization": f"Bearer {token}"},
    )
    assert duplicate.status_code == 400

    invitation = client.post(
        "/api/v1/clients/invitations",
        json={"email": "invitee@example.com"},
        headers={"Authorization": f"Bearer {token}"},
    )
    assert invitation.status_code == 202

    export_json = client.get(
        "/api/v1/clients/export",
        params={"format": "json"},
        headers={"Authorization": f"Bearer {token}"},
    )
    assert export_json.status_code == 200
    assert export_json.json()["count"] >= 3

    export_csv = client.get(
        "/api/v1/clients/export",
        params={"format": "csv", "status": "active"},
        headers={"Authorization": f"Bearer {token}"},
    )
    assert export_csv.status_code == 200
    assert "content" in export_csv.json()

    reset = client.post(
        "/api/v1/clients/client1@example.com/reset-api-keys",
        headers={"Authorization": f"Bearer {token}"},
    )
    assert reset.status_code == 200
    payload = reset.json()
    assert payload["count"] == 2

    legacy_key = client.get(
        "/api/v1/licenses/ws_live_1",
        headers={"Authorization": f"Bearer {token}"},
    )
    assert legacy_key.status_code == 404