Method GetStatementsForChecks

backend/component/sheet/sheet.go:63–88

GetStatementsForChecks gets the unified Statements (with both text and AST) with caching. This is the new unified API that returns complete ParsedStatement objects. Use this for new code that needs both text and AST information.

(dbType storepb.Engine, statement string)

// This is the new unified API that returns complete ParsedStatement objects.
// Use this for new code that needs both text and AST information.
func (sm *Manager) GetStatementsForChecks(dbType storepb.Engine, statement string) ([]base.ParsedStatement, []*storepb.Advice) {
	var result *StatementResult
	h := xxh3.HashString(statement)
	key := astHashKey{hash: h, engine: dbType}
	sm.Lock()
	if v, ok := sm.statementCache.Get(key); ok {
		result = v
	} else {
		result = &StatementResult{}
		sm.statementCache.Add(key, result)
	}
	sm.Unlock()

	result.Lock()
	defer result.Unlock()
	if result.statements != nil || result.advices != nil {
		return result.statements, result.advices
	}
	statements, err := base.ParseStatements(dbType, statement)
	if err != nil {
		result.advices = convertErrorToAdvice(err)
	} else {
		result.statements = statements
	}
	return result.statements, result.advices
}

func convertErrorToAdvice(err error) []*storepb.Advice {
	if syntaxErr, ok := err.(*base.SyntaxError); ok {