from supabase import create_client

from ..common.config import Config

supabase = create_client(Config.SUPABASE_URL, Config.SUPABASE_KEY)


def get_license(license_key: str):
    result = (
        supabase.table("licenses").select("*").eq("license_key", license_key).execute()
    )
    return result.data[0] if result.data else None


def get_first_activated_device(license_id: str):
    result = (
        supabase.table("license_activations")
        .select("*")
        .eq("license_id", license_id)
        .order("created_at", desc=False)
        .limit(1)
        .execute()
    )
    return result.data[0] if result.data else None


def insert_activation(license_id, license_key, device_info, ip, is_valid=True):
    supabase.table("license_activations").insert(
        {
            "license_id": license_id,
            "license_key": license_key,
            "device_id": device_info.get("device_id"),
            "device_name": device_info.get("machine_id"),
            "ip_address": ip,
            "is_valid": is_valid,
        }
    ).execute()