vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php line 77

  1. <?php
  3. declare(strict_types=1);
  5. namespace Doctrine\DBAL\Driver\API\PostgreSQL;
  7. use Doctrine\DBAL\Driver\API\ExceptionConverter as ExceptionConverterInterface;
  8. use Doctrine\DBAL\Driver\Exception;
  9. use Doctrine\DBAL\Exception\ConnectionException;
  10. use Doctrine\DBAL\Exception\DatabaseDoesNotExist;
  11. use Doctrine\DBAL\Exception\DeadlockException;
  12. use Doctrine\DBAL\Exception\DriverException;
  13. use Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException;
  14. use Doctrine\DBAL\Exception\InvalidFieldNameException;
  15. use Doctrine\DBAL\Exception\NonUniqueFieldNameException;
  16. use Doctrine\DBAL\Exception\NotNullConstraintViolationException;
  17. use Doctrine\DBAL\Exception\SchemaDoesNotExist;
  18. use Doctrine\DBAL\Exception\SyntaxErrorException;
  19. use Doctrine\DBAL\Exception\TableExistsException;
  20. use Doctrine\DBAL\Exception\TableNotFoundException;
  21. use Doctrine\DBAL\Exception\UniqueConstraintViolationException;
  22. use Doctrine\DBAL\Query;
  24. use function strpos;
  26. /** @internal */
  27. final class ExceptionConverter implements ExceptionConverterInterface
  28. {
  29.     /** @link http://www.postgresql.org/docs/9.4/static/errcodes-appendix.html */
  30.     public function convert(Exception $exception, ?Query $query): DriverException
  31.     {
  32.         switch ($exception->getSQLState()) {
  33.             case '40001':
  34.             case '40P01':
  35.                 return new DeadlockException($exception, $query);
  37.             case '0A000':
  38.                 // Foreign key constraint violations during a TRUNCATE operation
  39.                 // are considered "feature not supported" in PostgreSQL.
  40.                 if (strpos($exception->getMessage(), 'truncate') !== false) {
  41.                     return new ForeignKeyConstraintViolationException($exception, $query);
  42.                 }
  44.                 break;
  46.             case '23502':
  47.                 return new NotNullConstraintViolationException($exception, $query);
  49.             case '23503':
  50.                 return new ForeignKeyConstraintViolationException($exception, $query);
  52.             case '23505':
  53.                 return new UniqueConstraintViolationException($exception, $query);
  55.             case '3D000':
  56.                 return new DatabaseDoesNotExist($exception, $query);
  58.             case '3F000':
  59.                 return new SchemaDoesNotExist($exception, $query);
  61.             case '42601':
  62.                 return new SyntaxErrorException($exception, $query);
  64.             case '42702':
  65.                 return new NonUniqueFieldNameException($exception, $query);
  67.             case '42703':
  68.                 return new InvalidFieldNameException($exception, $query);
  70.             case '42P01':
  71.                 return new TableNotFoundException($exception, $query);
  73.             case '42P07':
  74.                 return new TableExistsException($exception, $query);
  76.             case '08006':
  77.                 return new ConnectionException($exception, $query);
  78.         }
  80.         // Prior to fixing https://bugs.php.net/bug.php?id=64705 (PHP 7.4.10),
  81.         // in some cases (mainly connection errors) the PDO exception wouldn't provide a SQLSTATE via its code.
  82.         // We have to match against the SQLSTATE in the error message in these cases.
  83.         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  84.             return new ConnectionException($exception, $query);
  85.         }
  87.         return new DriverException($exception, $query);
  88.     }
  89. }