Method getCodeActionsForDiagnostic

pkg/lsp/handler.go:1629–1690

getCodeActionsForDiagnostic generates code actions for a specific diagnostic

(uri string, diag Diagnostic)

// getCodeActionsForDiagnostic generates code actions for a specific diagnostic
func (h *Handler) getCodeActionsForDiagnostic(uri string, diag Diagnostic) []CodeAction {
	actions := []CodeAction{}
	msg := strings.ToLower(diag.Message)

	// Common SQL error fixes
	if strings.Contains(msg, "unexpected") || strings.Contains(msg, "expected") {
		// Suggest adding missing semicolon
		if strings.Contains(msg, "semicolon") || strings.Contains(msg, ";") {
			actions = append(actions, CodeAction{
				Title:       "Add missing semicolon",
				Kind:        CodeActionQuickFix,
				Diagnostics: []Diagnostic{diag},
				Edit: &WorkspaceEdit{
					Changes: map[string][]TextEdit{
						uri: {
							{
								Range:   Range{Start: diag.Range.End, End: diag.Range.End},
								NewText: ";",
							},
						},
					},
				},
			})
		}
	}

	// Suggest uppercase for keywords
	if strings.Contains(msg, "keyword") {
		content, ok := h.server.Documents().GetContent(uri)
		if ok {
			lines := strings.Split(content, "\n")
			if diag.Range.Start.Line < len(lines) {
				line := lines[diag.Range.Start.Line]
				start := diag.Range.Start.Character
				end := diag.Range.End.Character
				if start < len(line) && end <= len(line) && start < end {
					word := line[start:end]
					upper := strings.ToUpper(word)
					if word != upper {
						actions = append(actions, CodeAction{
							Title:       fmt.Sprintf("Convert '%s' to uppercase", word),
							Kind:        CodeActionQuickFix,
							Diagnostics: []Diagnostic{diag},
							Edit: &WorkspaceEdit{
								Changes: map[string][]TextEdit{
									uri: {
										{
											Range:   diag.Range,
											NewText: upper,
										},
									},
								},
							},
						})
					}
				}
			}
		}