Function TestSQLFormatter_BasicFormatting

cmd/gosqlx/cmd/sql_formatter_test.go:27–110

TestSQLFormatter_BasicFormatting tests basic formatter functionality

(t *testing.T)

// TestSQLFormatter_BasicFormatting tests basic formatter functionality
func TestSQLFormatter_BasicFormatting(t *testing.T) {
	tests := []struct {
		name           string
		sql            string
		indentSpaces   int
		uppercase      bool
		expectKeywords []string
		shouldSkip     bool
	}{
		{
			name:           "simple SELECT with default options",
			sql:            "SELECT id, name FROM users WHERE active = true",
			indentSpaces:   2,
			uppercase:      false,
			expectKeywords: []string{"select", "from", "where"},
		},
		{
			name:           "SELECT with uppercase keywords",
			sql:            "select id from users",
			indentSpaces:   2,
			uppercase:      true,
			expectKeywords: []string{"SELECT", "FROM"},
		},
		{
			name:           "SELECT with different indent",
			sql:            "SELECT id FROM users",
			indentSpaces:   4,
			uppercase:      false,
			expectKeywords: []string{"select", "from"},
		},
	}

	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
			if tt.shouldSkip {
				t.Skip("Skipping due to parser limitations")
			}

			// Tokenize and parse
			tkz := tokenizer.GetTokenizer()
			defer tokenizer.PutTokenizer(tkz)

			tokens, err := tkz.Tokenize([]byte(tt.sql))
			if err != nil {
				t.Fatalf("Tokenization failed: %v", err)
			}

			p := parser.NewParser()
			astObj := ast.NewAST()
			defer ast.ReleaseAST(astObj)

			result, err := p.ParseFromModelTokens(tokens)
			if err != nil {
				t.Skipf("Parsing failed (may not be supported yet): %v", err)
				return
			}
			astObj.Statements = result.Statements