PostgresConnection

class PostgresConnection extends Connection (View source)

Traits

DetectsLostConnections

Properties

protected PDO $pdo The active PDO connection. from Connection
protected PDO $readPdo The active PDO connection used for reads. from Connection
protected callable $reconnector The reconnector instance for the connection. from Connection
protected Grammar $queryGrammar The query grammar implementation. from Connection
protected Grammar $schemaGrammar The schema grammar implementation. from Connection
protected Processor $postProcessor The query post processor implementation. from Connection
protected Dispatcher $events The event dispatcher instance. from Connection
protected int $fetchMode The default fetch mode of the connection. from Connection
protected int $transactions The number of active transactions. from Connection
protected array $queryLog All of the queries run against the connection. from Connection
protected bool $loggingQueries Indicates whether queries are being logged. from Connection
protected bool $pretending Indicates if the connection is in a "dry run". from Connection
protected string $database The name of the connected database. from Connection
protected Connection $doctrineConnection The instance of Doctrine connection. from Connection
protected string $tablePrefix The table prefix for the connection. from Connection
protected array $config The database connection configuration options. from Connection

Methods

bool causedByLostConnection(Exception $e)

Determine if the given exception was caused by a lost connection.

 from DetectsLostConnections
void __construct(PDO $pdo, string $database = '', string $tablePrefix = '', array $config = [])

Create a new database connection instance.

 from Connection
void useDefaultQueryGrammar()

Set the query grammar to the default implementation.

 from Connection
Grammar getDefaultQueryGrammar()

Get the default query grammar instance.
void useDefaultSchemaGrammar()

Set the schema grammar to the default implementation.

 from Connection
Grammar getDefaultSchemaGrammar()

Get the default schema grammar instance.
void useDefaultPostProcessor()

Set the query post processor to the default implementation.

 from Connection
Processor getDefaultPostProcessor()

Get the default post processor instance.
Builder getSchemaBuilder()

Get a schema builder instance for the connection.
Builder table(string $table)

Begin a fluent query against a database table.

 from Connection
Builder query()

Get a new query builder instance.

 from Connection
Expression raw(mixed $value)

Get a new raw query expression.

 from Connection
mixed selectOne(string $query, array $bindings = [])

Run a select statement and return a single result.

 from Connection
array selectFromWriteConnection(string $query, array $bindings = [])

Run a select statement against the database.

 from Connection
array select(string $query, array $bindings = [], bool $useReadPdo = true)

Run a select statement against the database.

 from Connection
PDO getPdoForSelect(bool $useReadPdo = true)

Get the PDO connection to use for a select query.

 from Connection
bool insert(string $query, array $bindings = [])

Run an insert statement against the database.

 from Connection
int update(string $query, array $bindings = [])

Run an update statement against the database.

 from Connection
int delete(string $query, array $bindings = [])

Run a delete statement against the database.

 from Connection
bool statement(string $query, array $bindings = [])

Execute an SQL statement and return the boolean result.

 from Connection
int affectingStatement(string $query, array $bindings = [])

Run an SQL statement and get the number of rows affected.

 from Connection
bool unprepared(string $query)

Run a raw, unprepared query against the PDO connection.

 from Connection
array prepareBindings(array $bindings)

Prepare the query bindings for execution.

 from Connection
mixed transaction(Closure $callback)

Execute a Closure within a transaction.

 from Connection
void beginTransaction()

Start a new database transaction.

 from Connection
void commit()

Commit the active database transaction.

 from Connection
void rollBack()

Rollback the active database transaction.

 from Connection
int transactionLevel()

Get the number of active transactions.

 from Connection
array pretend(Closure $callback)

Execute the given callback in "dry run" mode.

 from Connection
mixed run(string $query, array $bindings, Closure $callback)

Run a SQL statement and log its execution context.

 from Connection
mixed runQueryCallback(string $query, array $bindings, Closure $callback)

Run a SQL statement.

 from Connection
mixed tryAgainIfCausedByLostConnection(QueryException $e, string $query, array $bindings, Closure $callback)

Handle a query exception that occurred during query execution.

 from Connection
void disconnect()

Disconnect from the underlying PDO connection.

 from Connection
void reconnect()

Reconnect to the database.

 from Connection
void reconnectIfMissingConnection()

Reconnect to the database if a PDO connection is missing.

 from Connection
void logQuery(string $query, array $bindings, float|null $time = null)

Log a query in the connection's query log.

 from Connection
void listen(Closure $callback)

Register a database query listener with the connection.

 from Connection
void fireConnectionEvent(string $event)

Fire an event for this connection.

 from Connection
float getElapsedTime(int $start)

Get the elapsed time since a given starting point.

 from Connection
bool isDoctrineAvailable()

Is Doctrine available?

 from Connection
Column getDoctrineColumn(string $table, string $column)

Get a Doctrine Schema Column instance.

 from Connection
AbstractSchemaManager getDoctrineSchemaManager()

Get the Doctrine DBAL schema manager for the connection.

 from Connection
Connection getDoctrineConnection()

Get the Doctrine DBAL database connection instance.

 from Connection
PDO getPdo()

Get the current PDO connection.

 from Connection
PDO getReadPdo()

Get the current PDO connection used for reading.

 from Connection
$this setPdo(PDO|null $pdo)

Set the PDO connection.

 from Connection
$this setReadPdo(PDO|null $pdo)

Set the PDO connection used for reading.

 from Connection
$this setReconnector(callable $reconnector)

Set the reconnect instance on the connection.

 from Connection
string|null getName()

Get the database connection name.

 from Connection
mixed getConfig(string $option)

Get an option from the configuration options.

 from Connection
string getDriverName()

Get the PDO driver name.

 from Connection
Grammar getQueryGrammar()

Get the query grammar used by the connection.

 from Connection
void setQueryGrammar(Grammar $grammar)

Set the query grammar used by the connection.

 from Connection
Grammar getSchemaGrammar()

Get the schema grammar used by the connection.

 from Connection
void setSchemaGrammar(Grammar $grammar)

Set the schema grammar used by the connection.

 from Connection
Processor getPostProcessor()

Get the query post processor used by the connection.

 from Connection
void setPostProcessor(Processor $processor)

Set the query post processor used by the connection.

 from Connection
Dispatcher getEventDispatcher()

Get the event dispatcher used by the connection.

 from Connection
void setEventDispatcher(Dispatcher $events)

Set the event dispatcher instance on the connection.

 from Connection
bool pretending()

Determine if the connection in a "dry run".

 from Connection
int getFetchMode()

Get the default fetch mode for the connection.

 from Connection
int setFetchMode(int $fetchMode)

Set the default fetch mode for the connection.

 from Connection
array getQueryLog()

Get the connection query log.

 from Connection
void flushQueryLog()

Clear the query log.

 from Connection
void enableQueryLog()

Enable the query log on the connection.

 from Connection
void disableQueryLog()

Disable the query log on the connection.

 from Connection
bool logging()

Determine whether we're logging queries.

 from Connection
string getDatabaseName()

Get the name of the connected database.

 from Connection
string setDatabaseName(string $database)

Set the name of the connected database.

 from Connection
string getTablePrefix()

Get the table prefix for the connection.

 from Connection
void setTablePrefix(string $prefix)

Set the table prefix in use by the connection.

 from Connection
Grammar withTablePrefix(Grammar $grammar)

Set the table prefix and return the grammar.

 from Connection
Driver getDoctrineDriver()

Get the Doctrine DBAL driver.

Details

protected bool causedByLostConnection(Exception $e)

Determine if the given exception was caused by a lost connection.

Parameters

Exception $e

Return Value

bool

void __construct(PDO $pdo, string $database = '', string $tablePrefix = '', array $config = [])

Create a new database connection instance.

Parameters

PDO $pdo
string $database
string $tablePrefix
array $config

Return Value

void

void useDefaultQueryGrammar()

Set the query grammar to the default implementation.

Return Value

void

protected Grammar getDefaultQueryGrammar()

Get the default query grammar instance.

Return Value

Grammar

void useDefaultSchemaGrammar()

Set the schema grammar to the default implementation.

Return Value

void

protected Grammar getDefaultSchemaGrammar()

Get the default schema grammar instance.

Return Value

Grammar

void useDefaultPostProcessor()

Set the query post processor to the default implementation.

Return Value

void

protected Processor getDefaultPostProcessor()

Get the default post processor instance.

Return Value

Processor

Builder getSchemaBuilder()

Get a schema builder instance for the connection.

Return Value

Builder

Builder table(string $table)

Begin a fluent query against a database table.

Parameters

string $table

Return Value

Builder

Builder query()

Get a new query builder instance.

Return Value

Builder

Expression raw(mixed $value)

Get a new raw query expression.

Parameters

mixed $value

Return Value

Expression

mixed selectOne(string $query, array $bindings = [])

Run a select statement and return a single result.

Parameters

string $query
array $bindings

Return Value

mixed

array selectFromWriteConnection(string $query, array $bindings = [])

Run a select statement against the database.

Parameters

string $query
array $bindings

Return Value

array

array select(string $query, array $bindings = [], bool $useReadPdo = true)

Run a select statement against the database.

Parameters

string $query
array $bindings
bool $useReadPdo

Return Value

array

protected PDO getPdoForSelect(bool $useReadPdo = true)

Get the PDO connection to use for a select query.

Parameters

bool $useReadPdo

Return Value

PDO

bool insert(string $query, array $bindings = [])

Run an insert statement against the database.

Parameters

string $query
array $bindings

Return Value

bool

int update(string $query, array $bindings = [])

Run an update statement against the database.

Parameters

string $query
array $bindings

Return Value

int

int delete(string $query, array $bindings = [])

Run a delete statement against the database.

Parameters

string $query
array $bindings

Return Value

int

bool statement(string $query, array $bindings = [])

Execute an SQL statement and return the boolean result.

Parameters

string $query
array $bindings

Return Value

bool

int affectingStatement(string $query, array $bindings = [])

Run an SQL statement and get the number of rows affected.

Parameters

string $query
array $bindings

Return Value

int

bool unprepared(string $query)

Run a raw, unprepared query against the PDO connection.

Parameters

string $query

Return Value

bool

array prepareBindings(array $bindings)

Prepare the query bindings for execution.

Parameters

array $bindings

Return Value

array

mixed transaction(Closure $callback)

Execute a Closure within a transaction.

Parameters

Closure $callback

Return Value

mixed

Exceptions

Throwable

void beginTransaction()

Start a new database transaction.

Return Value

void

Exceptions

Exception

void commit()

Commit the active database transaction.

Return Value

void

void rollBack()

Rollback the active database transaction.

Return Value

void

int transactionLevel()

Get the number of active transactions.

Return Value

int

array pretend(Closure $callback)

Execute the given callback in "dry run" mode.

Parameters

Closure $callback

Return Value

array

protected mixed run(string $query, array $bindings, Closure $callback)

Run a SQL statement and log its execution context.

Parameters

string $query
array $bindings
Closure $callback

Return Value

mixed

Exceptions

QueryException

protected mixed runQueryCallback(string $query, array $bindings, Closure $callback)

Run a SQL statement.

Parameters

string $query
array $bindings
Closure $callback

Return Value

mixed

Exceptions

QueryException

protected mixed tryAgainIfCausedByLostConnection(QueryException $e, string $query, array $bindings, Closure $callback)

Handle a query exception that occurred during query execution.

Parameters

QueryException $e
string $query
array $bindings
Closure $callback

Return Value

mixed

Exceptions

QueryException

void disconnect()

Disconnect from the underlying PDO connection.

Return Value

void

void reconnect()

Reconnect to the database.

Return Value

void

Exceptions

LogicException

protected void reconnectIfMissingConnection()

Reconnect to the database if a PDO connection is missing.

Return Value

void

void logQuery(string $query, array $bindings, float|null $time = null)

Log a query in the connection's query log.

Parameters

string $query
array $bindings
float|null $time

Return Value

void

void listen(Closure $callback)

Register a database query listener with the connection.

Parameters

Closure $callback

Return Value

void

protected void fireConnectionEvent(string $event)

Fire an event for this connection.

Parameters

string $event

Return Value

void

protected float getElapsedTime(int $start)

Get the elapsed time since a given starting point.

Parameters

int $start

Return Value

float

bool isDoctrineAvailable()

Is Doctrine available?

Return Value

bool

Column getDoctrineColumn(string $table, string $column)

Get a Doctrine Schema Column instance.

Parameters

string $table
string $column

Return Value

Column

AbstractSchemaManager getDoctrineSchemaManager()

Get the Doctrine DBAL schema manager for the connection.

Return Value

AbstractSchemaManager

Connection getDoctrineConnection()

Get the Doctrine DBAL database connection instance.

Return Value

Connection

PDO getPdo()

Get the current PDO connection.

Return Value

PDO

PDO getReadPdo()

Get the current PDO connection used for reading.

Return Value

PDO

$this setPdo(PDO|null $pdo)

Set the PDO connection.

Parameters

PDO|null $pdo

Return Value

$this

Exceptions

RuntimeException

$this setReadPdo(PDO|null $pdo)

Set the PDO connection used for reading.

Parameters

PDO|null $pdo

Return Value

$this

$this setReconnector(callable $reconnector)

Set the reconnect instance on the connection.

Parameters

callable $reconnector

Return Value

$this

string|null getName()

Get the database connection name.

Return Value

string|null

mixed getConfig(string $option)

Get an option from the configuration options.

Parameters

string $option

Return Value

mixed

string getDriverName()

Get the PDO driver name.

Return Value

string

Grammar getQueryGrammar()

Get the query grammar used by the connection.

Return Value

Grammar

void setQueryGrammar(Grammar $grammar)

Set the query grammar used by the connection.

Parameters

Grammar $grammar

Return Value

void

Grammar getSchemaGrammar()

Get the schema grammar used by the connection.

Return Value

Grammar

void setSchemaGrammar(Grammar $grammar)

Set the schema grammar used by the connection.

Parameters

Grammar $grammar

Return Value

void

Processor getPostProcessor()

Get the query post processor used by the connection.

Return Value

Processor

void setPostProcessor(Processor $processor)

Set the query post processor used by the connection.

Parameters

Processor $processor

Return Value

void

Dispatcher getEventDispatcher()

Get the event dispatcher used by the connection.

Return Value

Dispatcher

void setEventDispatcher(Dispatcher $events)

Set the event dispatcher instance on the connection.

Parameters

Dispatcher $events

Return Value

void

bool pretending()

Determine if the connection in a "dry run".

Return Value

bool

int getFetchMode()

Get the default fetch mode for the connection.

Return Value

int

int setFetchMode(int $fetchMode)

Set the default fetch mode for the connection.

Parameters

int $fetchMode

Return Value

int

array getQueryLog()

Get the connection query log.

Return Value

array

void flushQueryLog()

Clear the query log.

Return Value

void

void enableQueryLog()

Enable the query log on the connection.

Return Value

void

void disableQueryLog()

Disable the query log on the connection.

Return Value

void

bool logging()

Determine whether we're logging queries.

Return Value

bool

string getDatabaseName()

Get the name of the connected database.

Return Value

string

string setDatabaseName(string $database)

Set the name of the connected database.

Parameters

string $database

Return Value

string

string getTablePrefix()

Get the table prefix for the connection.

Return Value

string

void setTablePrefix(string $prefix)

Set the table prefix in use by the connection.

Parameters

string $prefix

Return Value

void

Grammar withTablePrefix(Grammar $grammar)

Set the table prefix and return the grammar.

Parameters

Grammar $grammar

Return Value

Grammar

protected Driver getDoctrineDriver()

Get the Doctrine DBAL driver.

Return Value

Driver

© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.3/Illuminate/Database/PostgresConnection.html