Implementation of a QueryBuilder, Generates MySQL specific SQL.

QueryBuilders are used to convert a WebLab_Data_Query into database specific SQL.

see \global\WebLab_Data_Query
see \global\WebLab_Data_MySQL_QueryBuilder
author Jorgen Evens
package WebLab
subpackage Data_MySQLi

 Methods

Build a delete query using _query

delete() 
Inherited
inherited_from \WebLab_Data_MySQL_QueryBuilder::delete()

Build an insert query using _query

insert($update, $ignoreInUpdate) 
Inherited
inherited_from \WebLab_Data_MySQL_QueryBuilder::insert()

Parameters

$update

$ignoreInUpdate

Build a select query using _query

select() 
Inherited
inherited_from \WebLab_Data_MySQL_QueryBuilder::select()

Alter the query to which this builder belongs.

setQuery(\WebLab_Data_Query $query) : \WebLab_Data_QueryBuilder
Inherited
see \$_query
inherited_from \WebLab_Data_QueryBuilder::setQuery()
inherited_from \WebLab_Data_MySQL_QueryBuilder::setQuery()

Parameters

$query

\WebLab_Data_Query

New query

Returns

Build an update query using _query

update() 
Inherited
inherited_from \WebLab_Data_MySQL_QueryBuilder::update()

Decompile the query into an easier to use format.

_parseQuery() : object
Inherited
inherited_from \WebLab_Data_QueryBuilder::_parseQuery()
inherited_from \WebLab_Data_MySQL_QueryBuilder::_parseQuery()

Returns

object

 Properties

 

$_query : \WebLab_Data_Query
Inherited
inherited_from \WebLab_Data_QueryBuilder::$$_query
inherited_from \WebLab_Data_MySQL_QueryBuilder::$$_query