// src/helpers/getPromptFromDB.ts
import { ToolPrompt } from "../models/ToolPrompt";
import { Language } from "../models/Language";

export async function getPromptRepository(variation: string, lang = "en") {
  const language = await Language.query().findOne({ lang_code: lang });
  const lang_id = language?.id;

  const prompt = await ToolPrompt.query().findOne({
    prompt_variation: variation,
    lang: lang_id,
  });


  if (!prompt) {
    throw new Error(`Prompt not found for variation: ${variation}`);
  }

  return prompt.prompt_context;
}