Method extractStatementSymbol

pkg/lsp/handler.go:1223–1303

extractStatementSymbol extracts a document symbol from a SQL statement

(stmt interface{}, index int, lines []string, content string)

// extractStatementSymbol extracts a document symbol from a SQL statement
func (h *Handler) extractStatementSymbol(stmt interface{}, index int, lines []string, content string) *DocumentSymbol {
	// Determine statement type and name
	var name string
	var detail string
	var kind SymbolKind

	// Use type switch to determine statement type
	typeName := fmt.Sprintf("%T", stmt)
	switch {
	case strings.Contains(typeName, "SelectStatement"):
		name = fmt.Sprintf("SELECT #%d", index+1)
		detail = "SELECT statement"
		kind = SymbolMethod
	case strings.Contains(typeName, "InsertStatement"):
		name = fmt.Sprintf("INSERT #%d", index+1)
		detail = "INSERT statement"
		kind = SymbolMethod
	case strings.Contains(typeName, "UpdateStatement"):
		name = fmt.Sprintf("UPDATE #%d", index+1)
		detail = "UPDATE statement"
		kind = SymbolMethod
	case strings.Contains(typeName, "DeleteStatement"):
		name = fmt.Sprintf("DELETE #%d", index+1)
		detail = "DELETE statement"
		kind = SymbolMethod
	case strings.Contains(typeName, "CreateTableStatement"):
		name = fmt.Sprintf("CREATE TABLE #%d", index+1)
		detail = "DDL statement"
		kind = SymbolStruct
	case strings.Contains(typeName, "CreateIndexStatement"):
		name = fmt.Sprintf("CREATE INDEX #%d", index+1)
		detail = "DDL statement"
		kind = SymbolStruct
	case strings.Contains(typeName, "DropStatement"):
		name = fmt.Sprintf("DROP #%d", index+1)
		detail = "DDL statement"
		kind = SymbolStruct
	case strings.Contains(typeName, "AlterStatement"):
		name = fmt.Sprintf("ALTER #%d", index+1)
		detail = "DDL statement"
		kind = SymbolStruct
	case strings.Contains(typeName, "TruncateStatement"):
		name = fmt.Sprintf("TRUNCATE #%d", index+1)
		detail = "DDL statement"
		kind = SymbolStruct
	case strings.Contains(typeName, "MergeStatement"):
		name = fmt.Sprintf("MERGE #%d", index+1)
		detail = "DML statement"
		kind = SymbolMethod
	default:
		name = fmt.Sprintf("Statement #%d", index+1)
		detail = typeName
		kind = SymbolVariable
	}

	// For now, use a simple range based on statement index
	// A more sophisticated implementation would track actual positions
	startLine := 0