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
No description
No description
No description
No description
Returns select query hash for caching.
Returns SQL query.
No description
Adds SELECT clause, more calls append to the end.
No description
No description
Adds WHERE condition, more calls append with AND.
Adds JOIN condition.
No description
No description
Adds alias AS.
No description
Adds ORDER BY clause, more calls append to the end.
No description
No description
Sets LIMIT/OFFSET clause.
No description
No description
Sets GROUP BY and HAVING clause.
No description
No description
No description
No description
No description
No description
No description
No description
No description
No description
No description
No description
No description
No description
Details
at line 55
__construct(string $tableName, Explorer $explorer)
No description
at line 67
string
getTableName()
No description
at line 73
string
buildInsertQuery()
No description
at line 79
string
buildUpdateQuery()
No description
at line 95
string
buildDeleteQuery()
No description
at line 109
string
getSelectQueryHash(array|null $columns = null)
Returns select query hash for caching.
at line 143
string
buildSelectQuery(array|null $columns = null)
Returns SQL query.
at line 192
array
getParameters()
No description
at line 209
void
importConditions(SqlBuilder $builder)
No description
at line 221
bool
importGroupConditions(SqlBuilder $builder)
No description
at line 241
void
addSelect(string $columns, ...$params)
Adds SELECT clause, more calls append to the end.
at line 248
array
getSelect()
No description
at line 254
void
resetSelect()
No description
at line 264
bool
addWhere(string|array $condition, ...$params)
Adds WHERE condition, more calls append with AND.
at line 273
bool
addJoinCondition(string $tableChain, string|array $condition, ...$params)
Adds JOIN condition.
at line 284
protected bool
addCondition(string|array $condition, array $params, array $conditions, array $conditionsParameters)
No description
at line 407
array
getConditions()
No description
at line 416
void
addAlias(string $chain, string $alias)
Adds alias AS.
at line 427
protected void
checkUniqueTableName(string $tableName, string $chain)
No description
at line 448
void
addOrder(string|array $columns, ...$params)
Adds ORDER BY clause, more calls append to the end.
at line 455
void
setOrder(array $columns, array $parameters)
No description
at line 462
array
getOrder()
No description
at line 471
void
setLimit(int|null $limit, int|null $offset)
Sets LIMIT/OFFSET clause.
at line 478
int|null
getLimit()
No description
at line 484
int|null
getOffset()
No description
at line 493
void
setGroup(string|array $columns, ...$params)
Sets GROUP BY and HAVING clause.
at line 500
string
getGroup()
No description
at line 506
void
setHaving(string $having, ...$params)
No description
at line 513
string
getHaving()
No description
at line 522
protected string
buildSelect(array $columns)
No description
at line 528
protected array
parseJoinConditions(array $joins, array $joinConditions)
No description
at line 564
protected void
getSortedJoins(string $table, array $leftJoinDependency, array $tableJoins, array $finalJoins)
No description
at line 617
protected void
parseJoins(array $joins, string $query)
No description
at line 633
string
parseJoinsCb(array $joins, array $match)
No description
at line 751
protected string
buildQueryJoins(array $joins, array $leftJoinConditions = [])
No description
at line 765
protected array
buildJoinConditions()
No description
at line 776
protected string
buildConditions()
No description
at line 784
protected string
buildQueryEnd()
No description
at line 803
protected string
tryDelimit(string $s)
No description
at line 815
protected bool
addConditionComposition(array $columns, array $parameters, array $conditions, array $conditionsParameters)
No description