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

Open in your IDE?
  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. /**
  27.  * @internal
  28.  */
  29. final class ExceptionConverter implements ExceptionConverterInterface
  30. {
  31.     /**
  32.      * @link http://www.postgresql.org/docs/9.4/static/errcodes-appendix.html
  33.      */
  34.     public function convert(Exception $exception, ?Query $query): DriverException
  35.     {
  36.         switch ($exception->getSQLState()) {
  37.             case '40001':
  38.             case '40P01':
  39.                 return new DeadlockException($exception, $query);
  41.             case '0A000':
  42.                 // Foreign key constraint violations during a TRUNCATE operation
  43.                 // are considered "feature not supported" in PostgreSQL.
  44.                 if (strpos($exception->getMessage(), 'truncate') !== false) {
  45.                     return new ForeignKeyConstraintViolationException($exception, $query);
  46.                 }
  48.                 break;
  50.             case '23502':
  51.                 return new NotNullConstraintViolationException($exception, $query);
  53.             case '23503':
  54.                 return new ForeignKeyConstraintViolationException($exception, $query);
  56.             case '23505':
  57.                 return new UniqueConstraintViolationException($exception, $query);
  59.             case '3D000':
  60.                 return new DatabaseDoesNotExist($exception, $query);
  62.             case '3F000':
  63.                 return new SchemaDoesNotExist($exception, $query);
  65.             case '42601':
  66.                 return new SyntaxErrorException($exception, $query);
  68.             case '42702':
  69.                 return new NonUniqueFieldNameException($exception, $query);
  71.             case '42703':
  72.                 return new InvalidFieldNameException($exception, $query);
  74.             case '42P01':
  75.                 return new TableNotFoundException($exception, $query);
  77.             case '42P07':
  78.                 return new TableExistsException($exception, $query);
  80.             case '08006':
  81.                 return new ConnectionException($exception, $query);
  82.         }
  84.         // Prior to fixing https://bugs.php.net/bug.php?id=64705 (PHP 7.3.22 and PHP 7.4.10),
  85.         // in some cases (mainly connection errors) the PDO exception wouldn't provide a SQLSTATE via its code.
  86.         // We have to match against the SQLSTATE in the error message in these cases.
  87.         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  88.             return new ConnectionException($exception, $query);
  89.         }
  91.         return new DriverException($exception, $query);
  92.     }
  93. }