PostgreDriver
class PostgreDriver implements Driver
The driver for PostgreSQL database.
Driver options:
- host, hostaddr, port, dbname, user, password, connect_timeout, options, sslmode, service => see PostgreSQL API
- string => or use connection string
- schema => the schema search path
- charset => character encoding to set (default is utf8)
- persistent (bool) => try to find a persistent link?
- resource (resource) => existing connection resource
- connect_type (int) => see pg_connect()
Methods
No description
Disconnects from a database.
Pings database.
Executes the SQL query.
No description
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
Begins a transaction (if supported).
Commits statements in a transaction.
Rollback changes in a transaction.
Is in transaction?
Returns the connection resource.
Returns the connection reflector.
Result set driver factory.
Encodes data for use in a SQL statement.
No description
No description
No description
Encodes string for use in a LIKE statement.
Injects LIMIT/OFFSET to the SQL query.
Details
at line 40
__construct(array $config)
No description
at line 97
void
disconnect()
Disconnects from a database.
at line 106
bool
ping()
Pings database.
at line 116
ResultDriver|null
query(string $sql)
Executes the SQL query.
at line 135
static DriverException
createException(string $message, $code = null, string|null $sql = null)
No description
at line 163
int|null
getAffectedRows()
Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
at line 172
int|null
getInsertId(string|null $sequence)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
at line 191
void
begin(string|null $savepoint = null)
Begins a transaction (if supported).
at line 201
void
commit(string|null $savepoint = null)
Commits statements in a transaction.
at line 211
void
rollback(string|null $savepoint = null)
Rollback changes in a transaction.
at line 220
bool
inTransaction()
Is in transaction?
at line 230
mixed
getResource()
Returns the connection resource.
at line 241
Reflector
getReflector()
Returns the connection reflector.
at line 251
PostgreResult
createResultDriver(resource $resource)
Result set driver factory.
at line 263
string
escapeText(string $value)
Encodes data for use in a SQL statement.
at line 273
string
escapeBinary(string $value)
No description
at line 283
string
escapeIdentifier(string $value)
No description
at line 290
string
escapeBool(bool $value)
No description
at line 296
string
escapeDate(DateTimeInterface $value)
No description
at line 302
string
escapeDateTime(DateTimeInterface $value)
No description
at line 308
string
escapeDateInterval(DateInterval $value)
No description
at line 317
string
escapeLike(string $value, int $pos)
Encodes string for use in a LIKE statement.
at line 329
void
applyLimit(string $sql, int|null $limit, int|null $offset)
Injects LIMIT/OFFSET to the SQL query.
Traits
Better OOP experience.