Function TestParser_ComplexQuery

cmd/gosqlx/cmd/parser_cmd_test.go:268–292

TestParser_ComplexQuery tests parsing complex queries

(t *testing.T)

// TestParser_ComplexQuery tests parsing complex queries
func TestParser_ComplexQuery(t *testing.T) {
	complexQueries := []string{
		"SELECT u.name, COUNT(o.id) FROM users u LEFT JOIN orders o ON u.id = o.user_id GROUP BY u.name",
		"WITH temp AS (SELECT id FROM users) SELECT * FROM temp",
		"SELECT name, ROW_NUMBER() OVER (ORDER BY salary DESC) FROM employees",
		"INSERT INTO users (name, email) VALUES ('John', 'john@example.com')",
		"UPDATE users SET active = true WHERE id = 1",
		"DELETE FROM users WHERE created_at < '2020-01-01'",
	}

	for _, query := range complexQueries {
		t.Run(query[:30]+"...", func(t *testing.T) {
			var outBuf, errBuf bytes.Buffer
			parser := NewParser(&outBuf, &errBuf, CLIParserOptions{Format: "table"})

			result, err := parser.Parse(query)
			if err != nil {
				t.Errorf("Failed to parse complex query: %v", err)
			}
			if result != nil && result.AST != nil {
				ast.ReleaseAST(result.AST)
			}
		})
	}
}

// TestConvertStatement tests statement conversion
func TestConvertStatement(t *testing.T) {