Get or Create Score

async def get_or_create_ranking_score(website_url: str) -> int

async def get_or_create_ranking_score(website_url: str) -> int:
    await ensure_initialized()
    if not supabase_ranking:
        return random.randint(32, 49)
    
    try:
        existing = await supabase_ranking.table("pre_payment_rankings") \
            .select("score").eq("website_url", website_url).execute()
        
        if existing.data and len(existing.data) > 0:
            return int(existing.data[0]["score"])
        
        new_score = random.randint(32, 49)
        await supabase_ranking.table("pre_payment_rankings").insert({
            "website_url": website_url,
            "score": new_score,
        }).execute()
        
        return new_score
    except Exception as e:
        return random.randint(32, 49)  # Fallback