Function TestSuggestKeyword

pkg/errors/hints_test.go:22–88

(t *testing.T)

)

func TestSuggestKeyword(t *testing.T) {
	tests := []struct {
		name  string
		input string
		want  string
	}{
		{
			name:  "exact match",
			input: "SELECT",
			want:  "SELECT",
		},
		{
			name:  "single character typo",
			input: "SELCT",
			want:  "SELECT",
		},
		{
			name:  "transposed characters",
			input: "FORM",
			want:  "FROM",
		},
		{
			name:  "case insensitive",
			input: "form",
			want:  "FROM",
		},
		{
			name:  "multiple typos",
			input: "SLECT",
			want:  "SELECT",
		},
		{
			name:  "common typo - WAHER",
			input: "WAHER",
			want:  "WHERE",
		},
		{
			name:  "common typo - JION",
			input: "JION",
			want:  "JOIN",
		},
		{
			name:  "common typo - UPDTE",
			input: "UPDTE",
			want:  "UPDATE",
		},
		{
			name:  "completely unrelated word",
			input: "SOMETHING",
			want:  "", // Should not suggest anything
		},
		{
			name:  "empty string",
			input: "",
			want:  "",
		},
	}