Class QueryFixer

QueryFixer class Fixes SQL queries that fail to execute

Index

Constructors

Methods

Constructors

constructor

new QueryFixer(contextUser: UserInfo, config: QueryGenConfig): QueryFixer
Parameters
- contextUser: UserInfo
- config: QueryGenConfig
Returns QueryFixer
- Defined in QueryGen/src/core/QueryFixer.ts:26

Methods

fixQuery

fixQuery(
    query: GeneratedQuery,
    errorMessage: string,
    entityMetadata: EntityMetadataForPrompt[],
    businessQuestion: BusinessQuestion,
): Promise<GeneratedQuery>
Fix a SQL query that failed to execute Uses AI to analyze the error and generate a corrected query
Parameters
- query: GeneratedQuery
  The query that failed
- errorMessage: string
  The error message from execution
- entityMetadata: EntityMetadataForPrompt[]
  Entity metadata for context
- businessQuestion: BusinessQuestion
  Original business question for context
Returns Promise<GeneratedQuery>
Corrected SQL query with updated metadata
- Defined in QueryGen/src/core/QueryFixer.ts:41