MySQLQueryBuilder
class MySQLQueryBuilder extends DBQueryBuilder (View source)
Builds a SQL query string from a SQLExpression object
Traits
Provides extensions to this object to integrate it with standard config API methods.
Constants
| MAX_ROWS |
Max number of rows allowed in MySQL |
Config options
| trace_query_origin | bool | If true, a comment is added to each query indicating where that query's execution originated. |
from DBQueryBuilder |
Properties
Methods
Get a configuration accessor for this class. Short hand for Config::inst()->get($this->class, .....).
Gets the uninherited value for the given config option
Builds an SQL comment indicating where the query was executed from.
Returns the WITH clauses ready for inserting into a query.
Returns the SELECT clauses ready for inserting into a query.
Return the DELETE clause ready for inserting into a query.
Return the UPDATE clause ready for inserting into a query.
Return the FROM clause ready for inserting into a query.
Returns the WHERE clauses ready for inserting into a query.
Return the UNION clause(s) ready for inserting into a query.
Returns the ORDER BY clauses ready for inserting into a query.
Returns the GROUP BY clauses ready for inserting into a query.
Returns the HAVING clauses ready for inserting into a query.
Return the LIMIT clause ready for inserting into a query.
Details
static Config_ForClass
config()
Get a configuration accessor for this class. Short hand for Config::inst()->get($this->class, .....).
mixed
uninherited(string $name)
Gets the uninherited value for the given config option
string
getSeparator()
Determines the line separator to use.
string
buildSQL(SQLExpression $query, array $parameters)
Builds a sql query with the specified connection
protected string
buildTraceComment()
Builds an SQL comment indicating where the query was executed from.
protected string
buildSelectQuery(SQLSelect $query, array $parameters)
Builds a query from a SQLSelect expression
protected string
buildDeleteQuery(SQLDelete $query, array $parameters)
Builds a query from a SQLDelete expression
protected string
buildInsertQuery(SQLInsert $query, array $parameters)
Builds a query from a SQLInsert expression
protected string
buildUpdateQuery(SQLUpdate $query, array $parameters)
Builds a query from a SQLUpdate expression
protected string
buildWithFragment(SQLSelect $query, array $parameters)
Returns the WITH clauses ready for inserting into a query.
protected string
buildSelectFragment(SQLSelect $query, array $parameters)
Returns the SELECT clauses ready for inserting into a query.
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.
protected string
buildUnionFragment(SQLSelect $query, array $parameters)
Return the UNION clause(s) 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.