Function TestHandler_SignatureHelp

pkg/lsp/handler_test.go:171–299

TestHandler_SignatureHelp tests function signature help

(t *testing.T)

// TestHandler_SignatureHelp tests function signature help
func TestHandler_SignatureHelp(t *testing.T) {
	tests := []struct {
		name            string
		sql             string
		position        Position
		expectSignature bool
		expectedFunc    string
		expectedParam   int
	}{
		{
			name:            "COUNT function returns signature",
			sql:             "SELECT COUNT(*) FROM users",
			position:        Position{Line: 0, Character: 13}, // Inside COUNT(*)
			expectSignature: true,
			expectedFunc:    "COUNT",
			expectedParam:   0,
		},
		{
			name:            "SUM function returns signature",
			sql:             "SELECT SUM(amount) FROM orders",
			position:        Position{Line: 0, Character: 11}, // Inside SUM(
			expectSignature: true,
			expectedFunc:    "SUM",
			expectedParam:   0,
		},
		{
			name:            "AVG function returns signature",
			sql:             "SELECT AVG(salary) FROM employees",
			position:        Position{Line: 0, Character: 11}, // Inside AVG(
			expectSignature: true,
			expectedFunc:    "AVG",
			expectedParam:   0,
		},
		{
			name:            "MIN function returns signature",
			sql:             "SELECT MIN(price) FROM products",
			position:        Position{Line: 0, Character: 11}, // Inside MIN(
			expectSignature: true,
			expectedFunc:    "MIN",
			expectedParam:   0,
		},
		{
			name:            "MAX function returns signature",
			sql:             "SELECT MAX(score) FROM tests",
			position:        Position{Line: 0, Character: 11}, // Inside MAX(
			expectSignature: true,
			expectedFunc:    "MAX",
			expectedParam:   0,
		},
		{
			name:            "COALESCE with multiple parameters",
			sql:             "SELECT COALESCE(name, email, 'unknown') FROM users",
			position:        Position{Line: 0, Character: 25}, // After first comma
			expectSignature: true,
			expectedFunc:    "COALESCE",
			expectedParam:   1,
		},
		{