NuoDB
class NuoDB extends Compiler
Compiles NuoDB queries.
Constants
JSON_PATH_SEPARATOR |
JSON path separator. |
Properties
static protected | $dateFormat | {@inheritdoc} | |
protected Query | $query | Query builder. | from Compiler |
protected array | $params | Query parameters. | from Compiler |
Methods
Returns an escaped identifier.
Builds a JSON value setter.
Returns a comma-separated list of compiled columns.
Compiles common table expressions.
Returns raw SQL or a paramter placeholder.
Returns a comma-separated list of parameters.
Returns a comma-separated list of parameter placeholders.
Compiles locking clause.
Details
in Compiler at line 80
static string
setDateFormat(string $dateFormat)
Sets the date format.
in Compiler at line 90
static string
getDateFormat()
Gets the date format.
in Compiler at line 119
protected string
subselect(Query $query)
Compiles a subselect and merges the parameters.
in Compiler at line 135
protected string
subquery(Subquery $subquery, bool $enclose = true)
Compiles a subquery.
at line 27
string
escapeIdentifier(string $identifier)
Returns an escaped identifier.
in Compiler at line 180
string
escapeIdentifiers(array $identifiers)
Returns an array of escaped identifiers.
in Compiler at line 196
protected bool
hasJsonPath(string $string)
Does the string have a JSON path?
in Compiler at line 208
protected string
buildJsonGet(string $column, array $segments)
Builds a JSON value getter.
in Compiler at line 221
protected string
buildJsonSet(string $column, array $segments, string $param)
Builds a JSON value setter.
in Compiler at line 232
string
escapeTableName(string $table)
Escapes a table name.
in Compiler at line 276
string
tables(array $tables)
Returns a comma-separated list of tables.
in Compiler at line 294
string
escapeColumnName(string $column)
Escapes a column name.
in Compiler at line 319
string
columnName(string $column)
Compiles a column name.
in Compiler at line 339
string
columnNames(array $columns)
Returns a comma-separated list of column names.
in Compiler at line 358
string
column(string|Raw|Subquery $column, bool $allowAlias = false)
Compiles a column.
in Compiler at line 385
string
columns(array $columns, bool $allowAlias = false)
Returns a comma-separated list of compiled columns.
in Compiler at line 403
protected string
commonTableExpressions(array $commonTableExpressions)
Compiles common table expressions.
in Compiler at line 435
protected string
setOperations(array $setOperations)
Compiles set operations.
in Compiler at line 459
protected string
param(mixed $param, bool $enclose = true)
Returns raw SQL or a paramter placeholder.
in Compiler at line 488
protected string
params(array $params, bool $enclose = true)
Returns a comma-separated list of parameters.
in Compiler at line 506
protected string
simpleParam(mixed $param)
Returns a parameter placeholder.
in Compiler at line 519
protected string
simpleParams(array $params)
Returns a comma-separated list of parameter placeholders.
in Compiler at line 537
protected string
from(string|array|Subquery|Raw|null $table)
Compiles the FROM clause.
in Compiler at line 553
protected string
where(array $where)
Compiles WHERE conditions.
in Compiler at line 573
protected string
whereRaw(array $where)
Compiles a raw WHERE condition.
in Compiler at line 584
protected string
whereDate(array $where)
Compiles date comparison clauses.
in Compiler at line 595
protected string
whereColumn(array $where)
Compiles column comparison clauses.
in Compiler at line 615
protected string
between(array $where)
Compiles BETWEEN clauses.
in Compiler at line 626
protected string
betweenDate(array $where)
Compiles date range clauses.
in Compiler at line 637
protected string
in(array $where)
Compiles IN clauses.
in Compiler at line 650
protected string
null(array $where)
Compiles IS NULL clauses.
in Compiler at line 661
protected string
exists(array $where)
Compiles EXISTS clauses.
in Compiler at line 672
protected string
nestedWhere(array $where)
Compiles nested WHERE conditions.
in Compiler at line 683
protected string
whereConditions(array $wheres)
Compiles WHERE conditions.
in Compiler at line 705
protected string
wheres(array $wheres)
Compiles WHERE clauses.
in Compiler at line 721
protected string
joinCondition(array $condition)
Compiles a JOIN condition.
in Compiler at line 732
protected string
nestedJoinCondition(array $condition)
Compiles nested JOIN condition.
in Compiler at line 767
protected string
joins(array $joins)
Compiles JOIN clauses.
in Compiler at line 790
protected string
groupings(array $groupings)
Compiles GROUP BY clauses.
in Compiler at line 801
protected string
orderings(array $orderings)
Compiles ORDER BY clauses.
in Compiler at line 824
protected string
havingCondictions(array $havings)
Compiles HAVING conditions.
in Compiler at line 846
protected string
havings(array $havings)
Compiles HAVING clauses.
in Compiler at line 862
protected string
limit(int|null $limit)
Compiles LIMIT clauses.
in Compiler at line 873
protected string
offset(int|null $offset)
Compiles OFFSET clauses.
at line 35
string
lock(bool|string|null $lock)
Compiles locking clause.
in Compiler at line 894
array
select()
Compiles a SELECT query.
in Compiler at line 920
protected string
insertWithValues(array $values)
Returns a INSERT query with values.
in Compiler at line 935
protected string
insertWithoutValues()
Returns a INSERT query without values.
in Compiler at line 946
array
insert(array $values = [])
Compiles a INSERT query.
in Compiler at line 968
protected string
updateColumns(array $columns)
Compiles update columns.
in Compiler at line 999
array
update(array $values)
Compiles a UPDATE query.
in Compiler at line 1016
array
delete()
Compiles a DELETE query.