Function AssertFormattedSQL

pkg/gosqlx/testing/testing.go:116–137

AssertFormattedSQL asserts that the SQL formats to match the expected output. This validates both that the SQL is valid and that it formats correctly. Example: testing.AssertFormattedSQL(t, "select * from users", "SELECT * FROM users;")

(t TestingT, sql, expected string)

//	    "select * from users",
//	    "SELECT * FROM users;")
func AssertFormattedSQL(t TestingT, sql, expected string) bool {
	t.Helper()

	opts := gosqlx.DefaultFormatOptions()
	formatted, err := gosqlx.Format(sql, opts)
	if err != nil {
		t.Errorf("Failed to format SQL:\n  SQL: %s\n  Error: %v",
			truncateSQL(sql), err)
		return false
	}

	// Normalize whitespace for comparison
	formattedNorm := strings.TrimSpace(formatted)
	expectedNorm := strings.TrimSpace(expected)

	if formattedNorm != expectedNorm {
		t.Errorf("Formatted SQL does not match expected:\n  Input: %s\n  Expected: %s\n  Got: %s",
			truncateSQL(sql), expectedNorm, formattedNorm)
		return false
	}
	return true
}

// AssertTables asserts that the SQL contains references to the expected tables.
// This extracts table names from the AST and compares them (order-independent).