app/database/settings.py

from __future__ import annotations
from .client import get_service_client


async def get_setting(key: str) -> str | None:
    client = get_service_client()
    resp = client.table("settings").select("value").eq("key", key).execute()
    return resp.data[0]["value"] if resp.data else None


async def set_setting(key: str, value: str) -> None:
    client = get_service_client()
    client.table("settings").upsert(
        {"key": key, "value": value}
    ).execute()


async def get_all_settings() -> dict[str, str]:
    client = get_service_client()
    resp = client.table("settings").select("*").execute()
    return {s["key"]: s["value"] for s in resp.data}