135 lines
3.4 KiB
PHP
Executable File
135 lines
3.4 KiB
PHP
Executable File
<?php
|
|
|
|
namespace Illuminate\Database;
|
|
|
|
use Exception;
|
|
use Illuminate\Database\Query\Grammars\PostgresGrammar as QueryGrammar;
|
|
use Illuminate\Database\Query\Processors\PostgresProcessor;
|
|
use Illuminate\Database\Schema\Grammars\PostgresGrammar as SchemaGrammar;
|
|
use Illuminate\Database\Schema\PostgresBuilder;
|
|
use Illuminate\Database\Schema\PostgresSchemaState;
|
|
use Illuminate\Filesystem\Filesystem;
|
|
|
|
class PostgresConnection extends Connection
|
|
{
|
|
/**
|
|
* {@inheritdoc}
|
|
*/
|
|
public function getDriverTitle()
|
|
{
|
|
return 'PostgreSQL';
|
|
}
|
|
|
|
/**
|
|
* Escape a binary value for safe SQL embedding.
|
|
*
|
|
* @param string $value
|
|
* @return string
|
|
*/
|
|
protected function escapeBinary($value)
|
|
{
|
|
$hex = bin2hex($value);
|
|
|
|
return "'\x{$hex}'::bytea";
|
|
}
|
|
|
|
/**
|
|
* Escape a bool value for safe SQL embedding.
|
|
*
|
|
* @param bool $value
|
|
* @return string
|
|
*/
|
|
protected function escapeBool($value)
|
|
{
|
|
return $value ? 'true' : 'false';
|
|
}
|
|
|
|
/**
|
|
* Determine if the given database exception was caused by a unique constraint violation.
|
|
*
|
|
* @param \Exception $exception
|
|
* @return bool
|
|
*/
|
|
protected function isUniqueConstraintError(Exception $exception)
|
|
{
|
|
return '23505' === $exception->getCode();
|
|
}
|
|
|
|
/**
|
|
* Extract the index and columns that caused a unique constraint violation.
|
|
*
|
|
* @param Exception $exception
|
|
* @return array{index: string|null, columns: list<string>}
|
|
*/
|
|
protected function parseUniqueConstraintViolation(Exception $exception): array
|
|
{
|
|
[$index, $columns] = [null, []];
|
|
|
|
if (preg_match('#unique constraint "([^"]+)"#i', $message = $exception->getMessage(), $matches)) {
|
|
$index = $matches[1];
|
|
}
|
|
|
|
if (preg_match('#Key \(([^)]+)\)=#i', $message, $matches)) {
|
|
$columns = array_map(trim(...), explode(',', $matches[1]));
|
|
}
|
|
|
|
return ['columns' => $columns, 'index' => $index];
|
|
}
|
|
|
|
/**
|
|
* Get the default query grammar instance.
|
|
*
|
|
* @return \Illuminate\Database\Query\Grammars\PostgresGrammar
|
|
*/
|
|
protected function getDefaultQueryGrammar()
|
|
{
|
|
return new QueryGrammar($this);
|
|
}
|
|
|
|
/**
|
|
* Get a schema builder instance for the connection.
|
|
*
|
|
* @return \Illuminate\Database\Schema\PostgresBuilder
|
|
*/
|
|
public function getSchemaBuilder()
|
|
{
|
|
if (is_null($this->schemaGrammar)) {
|
|
$this->useDefaultSchemaGrammar();
|
|
}
|
|
|
|
return new PostgresBuilder($this);
|
|
}
|
|
|
|
/**
|
|
* Get the default schema grammar instance.
|
|
*
|
|
* @return \Illuminate\Database\Schema\Grammars\PostgresGrammar
|
|
*/
|
|
protected function getDefaultSchemaGrammar()
|
|
{
|
|
return new SchemaGrammar($this);
|
|
}
|
|
|
|
/**
|
|
* Get the schema state for the connection.
|
|
*
|
|
* @param \Illuminate\Filesystem\Filesystem|null $files
|
|
* @param callable|null $processFactory
|
|
* @return \Illuminate\Database\Schema\PostgresSchemaState
|
|
*/
|
|
public function getSchemaState(?Filesystem $files = null, ?callable $processFactory = null)
|
|
{
|
|
return new PostgresSchemaState($this, $files, $processFactory);
|
|
}
|
|
|
|
/**
|
|
* Get the default post processor instance.
|
|
*
|
|
* @return \Illuminate\Database\Query\Processors\PostgresProcessor
|
|
*/
|
|
protected function getDefaultPostProcessor()
|
|
{
|
|
return new PostgresProcessor;
|
|
}
|
|
}
|