# get_llm_capability_options.dspy — appcodes_kv 下拉选项（parentid=llm_capability）
dbname = get_module_dbname('pipeline_llm')
try:
    async with get_sor_context(request._run_ns, dbname) as sor:
        recs = await sor.sqlExe(
            "SELECT k, v FROM appcodes_kv WHERE parentid=${p}$ ORDER BY k",
            {"p": "llm_capability"})
        await sor.sqlExe("COMMIT", {})
except Exception as e:
    return {"success": False, "message": str(e), "data": []}
return [{"value": getattr(r, "k", ""), "text": getattr(r, "v", "") or getattr(r, "k", "")} for r in (recs or [])]