Function TestDialectRegistry

pkg/sql/keywords/snowflake_test.go:457–544

TestDialectRegistry tests the AllDialects and DialectKeywords registry functions.

(t *testing.T)

// TestDialectRegistry tests the AllDialects and DialectKeywords registry functions.
func TestDialectRegistry(t *testing.T) {
	t.Run("AllDialects returns expected list", func(t *testing.T) {
		dialects := AllDialects()
		if len(dialects) == 0 {
			t.Fatal("AllDialects() returned empty slice")
		}

		// Check that all expected dialects are present
		expectedDialects := map[SQLDialect]bool{
			DialectGeneric:    false,
			DialectPostgreSQL: false,
			DialectMySQL:      false,
			DialectMariaDB:    false,
			DialectSQLServer:  false,
			DialectOracle:     false,
			DialectSQLite:     false,
			DialectSnowflake:  false,
			DialectBigQuery:   false,
			DialectRedshift:   false,
			DialectClickHouse: false,
		}

		for _, d := range dialects {
			if _, ok := expectedDialects[d]; !ok {
				t.Errorf("Unexpected dialect %q in AllDialects()", d)
			}
			expectedDialects[d] = true
		}

		for d, found := range expectedDialects {
			if !found {
				t.Errorf("Expected dialect %q not found in AllDialects()", d)
			}
		}
	})

	t.Run("DialectKeywords for Snowflake", func(t *testing.T) {
		kws := DialectKeywords(DialectSnowflake)
		if kws == nil {
			t.Fatal("DialectKeywords(DialectSnowflake) returned nil")
		}
		if len(kws) == 0 {
			t.Fatal("DialectKeywords(DialectSnowflake) returned empty slice")
		}
	})

	t.Run("DialectKeywords for MySQL", func(t *testing.T) {
		kws := DialectKeywords(DialectMySQL)
		if kws == nil {
			t.Fatal("DialectKeywords(DialectMySQL) returned nil")
		}
	})

	t.Run("DialectKeywords for PostgreSQL", func(t *testing.T) {
		kws := DialectKeywords(DialectPostgreSQL)
		if kws == nil {
			t.Fatal("DialectKeywords(DialectPostgreSQL) returned nil")
		}