Class PostgresCompiler

Properties summary

• $_deleteParts protected
  array

  The list of query clauses to traverse for generating a DELETE statement

• $_insertParts protected
  array

  The list of query clauses to traverse for generating an INSERT statement

• $_orderedUnion protected
  bool

  Indicate whether or not this query dialect supports ordered unions.

• $_quotedSelectAliases protected
  bool

  Always quote aliases in SELECT clause.

• $_selectParts protected
  array

  The list of query clauses to traverse for generating a SELECT statement

• $_templates protected
  array

  List of sprintf templates that will be used for compiling the SQL for this query. There are some clauses that can be built as just as the direct concatenation of the internal parts, those are listed here.

• $_updateParts protected
  array

  The list of query clauses to traverse for generating an UPDATE statement

Method Summary

• _buildFromPart() protected

  Helper function used to build the string representation of a FROM clause, it constructs the tables list taking care of aliasing and converting expression objects to string.

• _buildHavingPart() protected

  Helper function used to build the string representation of a HAVING clause, it constructs the field list taking care of aliasing and converting expression objects to string.

• _buildInsertPart() protected

  Builds the SQL fragment for INSERT INTO.

• _buildJoinPart() protected

  Helper function used to build the string representation of multiple JOIN clauses, it constructs the joins list taking care of aliasing and converting expression objects to string in both the table to be joined and the conditions to be used.

• _buildModifierPart() protected

  Builds the SQL modifier fragment

• _buildSelectPart() protected

  Helper function used to build the string representation of a SELECT clause, it constructs the field list taking care of aliasing and converting expression objects to string. This function also constructs the DISTINCT clause for the query.

• _buildSetPart() protected

  Helper function to generate SQL for SET expressions.

• _buildUnionPart() protected

  Builds the SQL string for all the UNION clauses in this query, when dealing with query objects it will also transform them using their configured SQL dialect.

• _buildUpdatePart() protected

  Builds the SQL fragment for UPDATE.

• _buildValuesPart() protected

  Builds the SQL fragment for INSERT INTO.

• _buildWindowPart() protected

  Helper function to build the string representation of a window clause.

• _buildWithPart() protected

  Helper function used to build the string representation of a WITH clause, it constructs the CTE definitions list and generates the RECURSIVE keyword when required.

• _sqlCompiler() protected

  Returns a callable object that can be used to compile a SQL string representation of this query.

• _stringifyExpressions() protected

  Helper function used to covert ExpressionInterface objects inside an array into their string representation.

• compile() public

  Returns the SQL representation of the provided query after generating the placeholders for the bound values using the provided generator

Method Detail

_buildFromPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildHavingPart(mixed $parts, mixed $query, mixed $generator)

_buildInsertPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildJoinPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildModifierPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildSelectPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildSetPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildUnionPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildUpdatePart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildValuesPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildWindowPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_buildWithPart(array $parts, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_sqlCompiler(string $sql, \Cake\Database\Query $query, \Cake\Database\ValueBinder $generator)

_stringifyExpressions(array $expressions, \Cake\Database\ValueBinder $generator, bool $wrap)

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

Property Detail