1. class
  2. Nette
  3. \
  4. Database
  5. \
  6. Table
  7. \
  8. SqlBuilder

SqlBuilder

class SqlBuilder extends Object

Builds SQL query.

SqlBuilder is based on great library NotORM http://www.notorm.com written by Jakub Vrana.

Properties

protected string $tableName
protected IReflection $databaseReflection
protected string $delimitedTable
protected array $select
protected array $where
protected array $conditions
protected array $parameters
protected array $order
protected int $limit
protected int $offset
protected string $group
protected string $having

Methods

__construct($tableName, Connection $connection, IReflection $reflection)

No description

buildInsertQuery()

No description

buildUpdateQuery()

No description

buildDeleteQuery()

No description

string
buildSelectQuery($columns = NULL)

Returns SQL query.

getParameters()

No description

importConditions(SqlBuilder $builder)

No description

addSelect($columns)

No description

getSelect()

No description

addWhere($condition, $parameters = array())

No description

getConditions()

No description

addOrder($columns)

No description

getOrder()

No description

setLimit($limit, $offset)

No description

getLimit()

No description

getOffset()

No description

setGroup($columns)

No description

getGroup()

No description

setHaving($having)

No description

getHaving()

No description

buildSelect(array $columns)

No description

parseJoins($joins, $query)

No description

parseJoinsCb($joins, $match)

No description

buildQueryJoins(array $joins)

No description

buildConditions()

No description

buildQueryEnd()

No description

tryDelimite($s)

No description

addWhereComposition(array $columns, array $parameters)

No description

Details

at line 72
__construct($tableName, Connection $connection, IReflection $reflection)

No description

Parameters

$tableName
Connection $connection
IReflection $reflection

at line 81
buildInsertQuery()

No description

at line 87
buildUpdateQuery()

No description

at line 96
buildDeleteQuery()

No description

at line 110
string buildSelectQuery($columns = NULL)

Returns SQL query.

Parameters

$columns

Return Value

string

at line 152
getParameters()

No description

at line 164
importConditions(SqlBuilder $builder)

No description

Parameters

SqlBuilder $builder

at line 175
addSelect($columns)

No description

Parameters

$columns

at line 185
getSelect()

No description

at line 191
addWhere($condition, $parameters = array())

No description

Parameters

$condition
$parameters

at line 310
getConditions()

No description

at line 316
addOrder($columns)

No description

Parameters

$columns

at line 323
getOrder()

No description

at line 329
setLimit($limit, $offset)

No description

Parameters

$limit
$offset

at line 336
getLimit()

No description

at line 342
getOffset()

No description

at line 348
setGroup($columns)

No description

Parameters

$columns

at line 355
getGroup()

No description

at line 361
setHaving($having)

No description

Parameters

$having

at line 368
getHaving()

No description

at line 377
protected buildSelect(array $columns)

No description

Parameters

array $columns

at line 383
protected parseJoins($joins, $query)

No description

Parameters

$joins
$query

at line 399
parseJoinsCb($joins, $match)

No description

Parameters

$joins
$match

at line 441
protected buildQueryJoins(array $joins)

No description

Parameters

array $joins

at line 456
protected buildConditions()

No description

at line 462
protected buildQueryEnd()

No description

at line 478
protected tryDelimite($s)

No description

Parameters

$s

at line 487
protected addWhereComposition(array $columns, array $parameters)

No description

Parameters

array $columns
array $parameters