Function TestNormalizeCheckExpr

schema/generator_test.go:187–326

(t *testing.T)

}

func TestNormalizeCheckExpr(t *testing.T) {
	tests := []struct {
		name     string
		input    string
		expected string
	}{
		{
			name:     "Remove ::text cast from string literal",
			input:    "status = 'active'::text",
			expected: "status = 'active'",
		},
		{
			name:     "Remove ::text cast from ARRAY elements",
			input:    "status = ANY (ARRAY['active'::text, 'pending'::text])",
			expected: "status = ANY (ARRAY['active', 'pending'])",
		},
		{
			name:     "Remove ::character varying cast",
			input:    "name = 'test'::character varying",
			expected: "name = 'test'",
		},
		{
			name:     "Remove ::character varying(255) cast",
			input:    "name = 'test'::character varying(255)",
			expected: "name = 'test'",
		},
		{
			name:     "Remove double parentheses",
			input:    "((status = 'active'))",
			expected: "(status = 'active')",
		},
		{
			name:     "Handle AND expression with casts",
			input:    "status = 'active'::text and name = 'test'::text",
			expected: "status = 'active' and name = 'test'",
		},
		{
			name:     "Handle OR expression with casts",
			input:    "status = 'active'::text or status = 'pending'::text",
			expected: "status in ('active', 'pending')",
		},
		{
			name:     "Handle NOT expression with cast",
			input:    "not status = 'inactive'::text",
			expected: "not status = 'inactive'",
		},
		{
			name:     "Handle complex comparison with casts",
			input:    "status = ANY (ARRAY['active'::text, 'pending'::text, 'processing'::text])",
			expected: "status = ANY (ARRAY['active', 'pending', 'processing'])",
		},
		{
			name:     "Handle IS NULL with cast",
			input:    "status::text is null",
			expected: "status is null",
		},
		{
			name:     "Handle BETWEEN with casts",