1. class
  2. SilverStripe
  3. \
  4. ORM
  5. \
  6. Connect
  7. \
  8. DBQueryBuilder

DBQueryBuilder

class DBQueryBuilder

Builds a SQL query string from a SQLExpression object

Methods

string
getSeparator()

Determines the line separator to use.

string
buildSQL(SQLExpression $query, array $parameters)

Builds a sql query with the specified connection

string
buildDeleteFragment(SQLDelete $query, array $parameters)

Return the DELETE clause ready for inserting into a query.

string
buildUpdateFragment(SQLUpdate $query, array $parameters)

Return the UPDATE clause ready for inserting into a query.

string
buildFromFragment(SQLConditionalExpression $query, array $parameters)

Return the FROM clause ready for inserting into a query.

string
buildWhereFragment(SQLConditionalExpression $query, array $parameters)

Returns the WHERE clauses ready for inserting into a query.

string
buildOrderByFragment(SQLSelect $query, array $parameters)

Returns the ORDER BY clauses ready for inserting into a query.

string
buildGroupByFragment(SQLSelect $query, array $parameters)

Returns the GROUP BY clauses ready for inserting into a query.

string
buildHavingFragment(SQLSelect $query, array $parameters)

Returns the HAVING clauses ready for inserting into a query.

string
buildLimitFragment(SQLSelect $query, array $parameters)

Return the LIMIT clause ready for inserting into a query.

Details

at line 24
string getSeparator()

Determines the line separator to use.

Return Value

string Non-empty whitespace character

at line 36
string buildSQL(SQLExpression $query, array $parameters)

Builds a sql query with the specified connection

Parameters

SQLExpression $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string The resulting SQL as a string

at line 195
string buildDeleteFragment(SQLDelete $query, array $parameters)

Return the DELETE clause ready for inserting into a query.

Parameters

SQLDelete $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string Completed delete part of statement

at line 215
string buildUpdateFragment(SQLUpdate $query, array $parameters)

Return the UPDATE clause ready for inserting into a query.

Parameters

SQLUpdate $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string Completed from part of statement

at line 242
string buildFromFragment(SQLConditionalExpression $query, array $parameters)

Return the FROM clause ready for inserting into a query.

Parameters

SQLConditionalExpression $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string Completed from part of statement

at line 257
string buildWhereFragment(SQLConditionalExpression $query, array $parameters)

Returns the WHERE clauses ready for inserting into a query.

Parameters

SQLConditionalExpression $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string Completed where condition

at line 279
string buildOrderByFragment(SQLSelect $query, array $parameters)

Returns the ORDER BY clauses ready for inserting into a query.

Parameters

SQLSelect $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string Completed order by part of statement

at line 303
string buildGroupByFragment(SQLSelect $query, array $parameters)

Returns the GROUP BY clauses ready for inserting into a query.

Parameters

SQLSelect $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string Completed group part of statement

at line 321
string buildHavingFragment(SQLSelect $query, array $parameters)

Returns the HAVING clauses ready for inserting into a query.

Parameters

SQLSelect $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string

at line 342
string buildLimitFragment(SQLSelect $query, array $parameters)

Return the LIMIT clause ready for inserting into a query.

Parameters

SQLSelect $query The expression object to build from
array $parameters Out parameter for the resulting query parameters

Return Value

string The finalised limit SQL fragment