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

SqlBuilder

class SqlBuilder

Builds SQL query.

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

Properties

protected $tableName
protected $conventions
protected $delimitedTable
protected $select
protected $where
protected $joinCondition
protected $conditions
protected $parameters
protected $order
protected $limit
protected $offset
protected $group
protected $having
protected $reservedTableNames
protected $aliases
protected $currentAlias

Methods

__construct(string $tableName, Explorer $explorer)

No description

string
getTableName()

No description

string
buildInsertQuery()

No description

string
buildUpdateQuery()

No description

string
buildDeleteQuery()

No description

string
getSelectQueryHash(array|null $columns = null)

Returns select query hash for caching.

string
buildSelectQuery(array|null $columns = null)

Returns SQL query.

array
getParameters()

No description

void
importConditions(SqlBuilder $builder)

No description

bool
importGroupConditions(SqlBuilder $builder)

No description

void
addSelect(string $columns, ...$params)

Adds SELECT clause, more calls append to the end.

array
getSelect()

No description

void
resetSelect()

No description

bool
addWhere(string|array $condition, ...$params)

Adds WHERE condition, more calls append with AND.

bool
addJoinCondition(string $tableChain, string|array $condition, ...$params)

Adds JOIN condition.

bool
addCondition(string|array $condition, array $params, array $conditions, array $conditionsParameters)

No description

array
getConditions()

No description

void
addAlias(string $chain, string $alias)

Adds alias AS.

void
checkUniqueTableName(string $tableName, string $chain)

No description

void
addOrder(string|array $columns, ...$params)

Adds ORDER BY clause, more calls append to the end.

void
setOrder(array $columns, array $parameters)

No description

array
getOrder()

No description

void
setLimit(int|null $limit, int|null $offset)

Sets LIMIT/OFFSET clause.

int|null
getLimit()

No description

int|null
getOffset()

No description

void
setGroup(string|array $columns, ...$params)

Sets GROUP BY and HAVING clause.

string
getGroup()

No description

void
setHaving(string $having, ...$params)

No description

string
getHaving()

No description

string
buildSelect(array $columns)

No description

array
parseJoinConditions(array $joins, array $joinConditions)

No description

void
getSortedJoins(string $table, array $leftJoinDependency, array $tableJoins, array $finalJoins)

No description

void
parseJoins(array $joins, string $query)

No description

string
parseJoinsCb(array $joins, array $match)

No description

string
buildQueryJoins(array $joins, array $leftJoinConditions = [])

No description

array
buildJoinConditions()

No description

string
buildConditions()

No description

string
buildQueryEnd()

No description

string
tryDelimite(string $s)

No description

bool
addConditionComposition(array $columns, array $parameters, array $conditions, array $conditionsParameters)

No description

Details

at line 55
 __construct(string $tableName, Explorer $explorer)

No description

Parameters

string $tableName
Explorer $explorer

at line 67
 string getTableName()

No description

Return Value

string

at line 73
 string buildInsertQuery()

No description

Return Value

string

at line 79
 string buildUpdateQuery()

No description

Return Value

string

at line 95
 string buildDeleteQuery()

No description

Return Value

string

at line 109
 string getSelectQueryHash(array|null $columns = null)

Returns select query hash for caching.

Parameters

array|null $columns

Return Value

string

at line 143
 string buildSelectQuery(array|null $columns = null)

Returns SQL query.

Parameters

array|null $columns

Return Value

string

at line 192
 array getParameters()

No description

Return Value

array

at line 209
 void importConditions(SqlBuilder $builder)

No description

Parameters

SqlBuilder $builder

Return Value

void

at line 221
 bool importGroupConditions(SqlBuilder $builder)

No description

Parameters

SqlBuilder $builder

Return Value

bool

at line 241
 void addSelect(string $columns, ...$params)

Adds SELECT clause, more calls append to the end.

Parameters

string $columns
...$params

Return Value

void

at line 248
 array getSelect()

No description

Return Value

array

at line 254
 void resetSelect()

No description

Return Value

void

at line 264
 bool addWhere(string|array $condition, ...$params)

Adds WHERE condition, more calls append with AND.

Parameters

string|array $condition
...$params

Return Value

bool

at line 273
 bool addJoinCondition(string $tableChain, string|array $condition, ...$params)

Adds JOIN condition.

Parameters

string $tableChain
string|array $condition
...$params

Return Value

bool

at line 284
 protected bool addCondition(string|array $condition, array $params, array $conditions, array $conditionsParameters)

No description

Parameters

string|array $condition
array $params
array $conditions
array $conditionsParameters

Return Value

bool

at line 421
 array getConditions()

No description

Return Value

array

at line 430
 void addAlias(string $chain, string $alias)

Adds alias AS.

Parameters

string $chain
string $alias

Return Value

void

at line 441
 protected void checkUniqueTableName(string $tableName, string $chain)

No description

Parameters

string $tableName
string $chain

Return Value

void

at line 462
 void addOrder(string|array $columns, ...$params)

Adds ORDER BY clause, more calls append to the end.

Parameters

string|array $columns
...$params

Return Value

void

at line 469
 void setOrder(array $columns, array $parameters)

No description

Parameters

array $columns
array $parameters

Return Value

void

at line 476
 array getOrder()

No description

Return Value

array

at line 485
 void setLimit(int|null $limit, int|null $offset)

Sets LIMIT/OFFSET clause.

Parameters

int|null $limit
int|null $offset

Return Value

void

at line 492
 int|null getLimit()

No description

Return Value

int|null

at line 498
 int|null getOffset()

No description

Return Value

int|null

at line 507
 void setGroup(string|array $columns, ...$params)

Sets GROUP BY and HAVING clause.

Parameters

string|array $columns
...$params

Return Value

void

at line 514
 string getGroup()

No description

Return Value

string

at line 520
 void setHaving(string $having, ...$params)

No description

Parameters

string $having
...$params

Return Value

void

at line 527
 string getHaving()

No description

Return Value

string

at line 536
 protected string buildSelect(array $columns)

No description

Parameters

array $columns

Return Value

string

at line 542
 protected array parseJoinConditions(array $joins, array $joinConditions)

No description

Parameters

array $joins
array $joinConditions

Return Value

array

at line 578
 protected void getSortedJoins(string $table, array $leftJoinDependency, array $tableJoins, array $finalJoins)

No description

Parameters

string $table
array $leftJoinDependency
array $tableJoins
array $finalJoins

Return Value

void

at line 631
 protected void parseJoins(array $joins, string $query)

No description

Parameters

array $joins
string $query

Return Value

void

at line 647
 string parseJoinsCb(array $joins, array $match)

No description

Parameters

array $joins
array $match

Return Value

string

at line 765
 protected string buildQueryJoins(array $joins, array $leftJoinConditions = [])

No description

Parameters

array $joins
array $leftJoinConditions

Return Value

string

at line 779
 protected array buildJoinConditions()

No description

Return Value

array

at line 790
 protected string buildConditions()

No description

Return Value

string

at line 798
 protected string buildQueryEnd()

No description

Return Value

string

at line 817
 protected string tryDelimite(string $s)

No description

Parameters

string $s

Return Value

string

at line 829
 protected bool addConditionComposition(array $columns, array $parameters, array $conditions, array $conditionsParameters)

No description

Parameters

array $columns
array $parameters
array $conditions
array $conditionsParameters

Return Value

bool