Class Postgres

Constants summary

• int|null
  MAX_ALIAS_LENGTH
  63
• int[]
  RETRY_ERROR_CODES
  []

Properties summary

• $_autoQuoting protected
  bool

  Indicates whether or not the driver is doing automatic identifier quoting for all queries

• $_baseConfig protected
  array

  Base configuration settings for Postgres driver

• $_config protected
  array

  Configuration data.

• $_connection protected
  \PDO

  Instance of PDO.

• $_endQuote protected
  string

  String used to end a database identifier quoting to make it safe

• $_schemaDialect protected
  \Cake\Database\Schema\PostgresSchemaDialect

  The schema dialect class for this driver

• $_startQuote protected
  string

  String used to start a database identifier quoting to make it safe

• $_version protected
  string|null

  The server version

• $connectRetries protected
  int

  The last number of connection retry attempts.

• $supportsCTEs protected
  bool|null

  Whether or not the server supports common table expressions.

Method Summary

• __construct() public

  Constructor

• __debugInfo() public

  Returns an array that can be used to describe the internal state of this object.

• __destruct() public

  Destructor

• _connect() protected

  Establishes a connection to the database server

• _deleteQueryTranslator() protected

  Apply translation steps to delete queries.

• _expressionTranslators() protected

  Returns an associative array of methods that will transform Expression objects to conform with the specific SQL dialect. Keys are class names and values a method in this class.

• _insertQueryTranslator() protected

  Apply translation steps to insert queries.

• _removeAliasesFromConditions() protected

  Removes aliases from the WHERE clause of a query.

• _selectQueryTranslator() protected

  Apply translation steps to select queries.

• _transformDistinct() protected

  Returns the passed query after rewriting the DISTINCT clause, so that drivers that do not support the "ON" part can provide the actual way it should be done

• _transformFunctionExpression() protected

  Receives a FunctionExpression and changes it so that it conforms to this SQL dialect.

• _updateQueryTranslator() protected

  Apply translation steps to update queries.

• beginTransaction() public

  Starts a transaction.

• commitTransaction() public

  Commits a transaction.

• compileQuery() public

  Transforms the passed query to this Driver's dialect and returns an instance of the transformed query and the full compiled SQL string.

• connect() public

  Establishes a connection to the database server

• disableAutoQuoting() public

  Disable auto quoting of identifiers in queries.

• disableForeignKeySQL() public

  Get the SQL for disabling foreign keys.

• disconnect() public

  Disconnects from database server.

• enableAutoQuoting() public

  Sets whether or not this driver should automatically quote identifiers in queries.

• enableForeignKeySQL() public

  Get the SQL for enabling foreign keys.

• enabled() public

  Returns whether php is able to use this driver for connecting to database

• getConnectRetries() public

  Returns the number of connection retry attempts made.

• getConnection() public

  Get the internal PDO connection instance.

• getMaxAliasLength() public

  Returns the maximum alias length allowed.

• isAutoQuotingEnabled() public

  Returns whether or not this driver should automatically quote identifiers in queries.

• isConnected() public

  Checks whether or not the driver is connected.

• lastInsertId() public

  Returns last id generated for a table or sequence in database.

• newCompiler() public

  Returns an instance of a QueryCompiler.

• newTableSchema() public

  Constructs new TableSchema.

• prepare() public

  Prepares a sql statement to be executed.

• queryTranslator() public

  Returns a callable function that will be used to transform a passed Query object.

• quote() public

  Returns a value in a safe representation to be used in a query string

• quoteIdentifier() public

  Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words

• releaseSavePointSQL() public

  Returns a SQL snippet for releasing a previously created save point

• rollbackSavePointSQL() public

  Returns a SQL snippet for rollbacking a previously created save point

• rollbackTransaction() public

  Rollbacks a transaction.

• savePointSQL() public

  Returns a SQL snippet for creating a new transaction savepoint

• schema() public

  Returns the schema name that's being used.

• schemaDialect() public

  Get the schema dialect.

• schemaValue() public

  Escapes values for use in schema definitions.

• setConnection() public

  Set the internal PDO connection instance.

• setEncoding() public

  Sets connection encoding

• setSchema() public

  Sets connection default schema, if any relation defined in a query is not fully qualified postgres will fallback to looking the relation into defined default schema

• supportsCTEs() public

  Returns true if the server supports common table expressions.

• supportsDynamicConstraints() public

  Returns whether the driver supports adding or dropping constraints to already created tables.

• supportsQuoting() public

  Checks if the driver supports quoting, as PDO_ODBC does not support it.

• supportsSavePoints() public

  Returns whether this driver supports save points for nested transactions.

• version() public

  Returns connected server version.

Method Detail

__construct(array $config)

__debugInfo()

__destruct()

_connect(string $dsn, array $config)

_deleteQueryTranslator(\Cake\Database\Query $query)

_expressionTranslators()

_insertQueryTranslator(\Cake\Database\Query $query)

_removeAliasesFromConditions(\Cake\Database\Query $query)

_selectQueryTranslator(\Cake\Database\Query $query)

_transformDistinct(\Cake\Database\Query $query)

_transformFunctionExpression(\Cake\Database\Expression\FunctionExpression $expression)

_updateQueryTranslator(\Cake\Database\Query $query)

beginTransaction()

commitTransaction()

compileQuery(\Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

connect()

disableAutoQuoting()

disableForeignKeySQL()

disconnect()

enableAutoQuoting(bool $enable)

enableForeignKeySQL()

enabled()

getConnectRetries()

getConnection()

getMaxAliasLength()

isAutoQuotingEnabled()

isConnected()

lastInsertId(?string $table, ?string $column)

newCompiler()

newTableSchema(string $table, array $columns)

prepare(mixed $query)

queryTranslator(string $type)

quote(mixed $value, mixed $type)

quoteIdentifier(string $identifier)

releaseSavePointSQL(mixed $name)

rollbackSavePointSQL(mixed $name)

rollbackTransaction()

savePointSQL(mixed $name)

schema()

schemaDialect()

schemaValue(mixed $value)

setConnection(mixed $connection)

setEncoding(string $encoding)

setSchema(string $schema)

supportsCTEs()

supportsDynamicConstraints()

supportsQuoting()

supportsSavePoints()

version()

Property Detail