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 16
string getSeparator()

Determines the line separator to use.

Return Value

string Non-empty whitespace character

at line 27
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 174
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 193
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 219
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 233
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 252
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 273
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 288
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 306
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