Testing the untestable: Fixed retry code

fixed-retry-code.php

<?php

$pdo = $this->connect();
while (true) {
  try {
    $stmt = $pdo->prepare('SELECT …'); // <- must be inside the loop
    $stmt->execute();
    while ($row = $stmt->fetch()) {
      write_row_to_csv($row);
    }
    break; //success
  } catch (\Throwable $e) {
    $retries++;
    if ($retries > 10) {
      throw new \Exception('failed to retry');
    }
    sleep(10);
    $pdo = $this->connect();
  }
}