Package com.alibaba.cloud.ai.prompt

Class PromptHelper

java.lang.Object

com.alibaba.cloud.ai.prompt.PromptHelper

public class PromptHelper
extends Object

Constructor Summary

Constructors

Constructor	Description
PromptHelper()

Method Summary

Modifier and Type	Method	Description
static String	buildBusinessKnowledgePrompt(List<BusinessKnowledgeDTO> businessKnowledgeDTOS)
static String	buildDateTimeExtractPrompt(String question)
static String	buildMacSqlTablePrompt(TableDTO tableDTO)
static String	buildMixMacSqlDbPrompt(SchemaDTO schemaDTO, Boolean withColumnType)
static String	buildMixMacSqlTablePrompt(TableDTO tableDTO, Boolean withColumnType)
static String	buildMixSelectorPrompt(List<String> evidences, String question, SchemaDTO schemaDTO)
static List<String>	buildMixSqlGeneratorPrompt(String question, DbConfig dbConfig, SchemaDTO schemaDTO, List<String> evidenceList)
static String	buildQueryToKeywordsPrompt(String question)
static String	buildReportGeneratorPromptWithCustom(String userRequirementsAndPlan, String analysisStepsAndData, String summaryAndRecommendations, String customPrompt)	构建带自定义提示词的报告生成提示词
static String	buildRewritePrompt(String query, SchemaDTO schemaDTO, List<String> evidenceList)
static String	buildSemanticConsistenPrompt(String nlReq, String sql)
static String	buildSemanticModelPrompt(List<SemanticModelDTO> semanticModelDTOS)
static String	buildSqlErrorFixerPrompt(String question, DbConfig dbConfig, SchemaDTO schemaDTO, List<String> evidenceList, String errorSql, String errorMessage)
static String	mixSqlGeneratorSystemCheckPrompt(String question, DbConfig dbConfig, SchemaDTO schemaDTO, List<String> evidenceList)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

PromptHelper

public PromptHelper()

Method Details

buildRewritePrompt

public static String buildRewritePrompt(String query,
 SchemaDTO schemaDTO,
 List<String> evidenceList)

buildMacSqlTablePrompt

public static String buildMacSqlTablePrompt(TableDTO tableDTO)

buildQueryToKeywordsPrompt

public static String buildQueryToKeywordsPrompt(String question)

buildMixSelectorPrompt

public static String buildMixSelectorPrompt(List<String> evidences,
 String question,
 SchemaDTO schemaDTO)

buildDateTimeExtractPrompt

public static String buildDateTimeExtractPrompt(String question)

buildMixMacSqlDbPrompt

public static String buildMixMacSqlDbPrompt(SchemaDTO schemaDTO,
 Boolean withColumnType)

buildMixMacSqlTablePrompt

public static String buildMixMacSqlTablePrompt(TableDTO tableDTO,
 Boolean withColumnType)

buildMixSqlGeneratorPrompt

public static List<String> buildMixSqlGeneratorPrompt(String question,
 DbConfig dbConfig,
 SchemaDTO schemaDTO,
 List<String> evidenceList)

mixSqlGeneratorSystemCheckPrompt

public static String mixSqlGeneratorSystemCheckPrompt(String question,
 DbConfig dbConfig,
 SchemaDTO schemaDTO,
 List<String> evidenceList)

buildSemanticConsistenPrompt

public static String buildSemanticConsistenPrompt(String nlReq,
 String sql)

buildReportGeneratorPromptWithCustom

public static String buildReportGeneratorPromptWithCustom(String userRequirementsAndPlan,
 String analysisStepsAndData,
 String summaryAndRecommendations,
 String customPrompt)

构建带自定义提示词的报告生成提示词

Parameters:

userRequirementsAndPlan - 用户需求和计划

analysisStepsAndData - 分析步骤和数据

summaryAndRecommendations - 总结和建议

customPrompt - 用户自定义的提示词内容，如果为null则使用默认提示词

Returns:

构建的提示词

buildSqlErrorFixerPrompt

public static String buildSqlErrorFixerPrompt(String question,
 DbConfig dbConfig,
 SchemaDTO schemaDTO,
 List<String> evidenceList,
 String errorSql,
 String errorMessage)

buildBusinessKnowledgePrompt

public static String buildBusinessKnowledgePrompt(List<BusinessKnowledgeDTO> businessKnowledgeDTOS)

buildSemanticModelPrompt

public static String buildSemanticModelPrompt(List<SemanticModelDTO> semanticModelDTOS)