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
Compiles subquery, merges parameters and returns subquery SQL.
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 120
protected string
subquery(Subquery $subquery, bool $enclose = true)
Compiles subquery, merges parameters and returns subquery SQL.
at line 27
string
escapeIdentifier(string $identifier)
Returns an escaped identifier.
in Compiler at line 167
string
escapeIdentifiers(array $identifiers)
Returns an array of escaped identifiers.
in Compiler at line 183
protected bool
hasJsonPath(string $string)
Does the string have a JSON path?
in Compiler at line 196
protected string
buildJsonGet(string $column, array $segments)
Builds a JSON value getter.
in Compiler at line 210
protected string
buildJsonSet(string $column, array $segments, string $param)
Builds a JSON value setter.
in Compiler at line 221
string
escapeTableName(string $table)
Escapes a table name.
in Compiler at line 239
string
table(mixed $table)
Compiles a table.
in Compiler at line 265
string
escapeColumnName(string $column)
Escapes a column name.
in Compiler at line 290
string
columnName(string $column)
Compiles a column name.
in Compiler at line 310
string
columnNames(array $columns)
Returns a comma-separated list of column names.
in Compiler at line 329
string
column(mixed $column, bool $allowAlias = false)
Compiles a column.
in Compiler at line 356
string
columns(array $columns, bool $allowAlias = false)
Returns a comma-separated list of compiled columns.
in Compiler at line 374
protected string
commonTableExpressions(array $commonTableExpressions)
Compiles common table expressions.
in Compiler at line 406
protected string
setOperations(array $setOperations)
Compiles set operations.
in Compiler at line 430
protected string
param(mixed $param, bool $enclose = true)
Returns raw SQL or a paramter placeholder.
in Compiler at line 459
protected string
params(array $params, bool $enclose = true)
Returns a comma-separated list of parameters.
in Compiler at line 477
protected string
simpleParam(mixed $param)
Returns a parameter placeholder.
in Compiler at line 490
protected string
simpleParams(array $params)
Returns a comma-separated list of parameter placeholders.
in Compiler at line 508
protected string
from(mixed $table)
Compiles the FROM clause.
in Compiler at line 519
protected string
where(array $where)
Compiles WHERE conditions.
in Compiler at line 539
protected string
whereRaw(array $where)
Compiles a raw WHERE condition.
in Compiler at line 551
protected string
whereDate(array $where)
Compiles date comparison clauses.
in Compiler at line 562
protected string
whereColumn(array $where)
Compiles column comparison clauses.
in Compiler at line 582
protected string
between(array $where)
Compiles BETWEEN clauses.
in Compiler at line 594
protected string
betweenDate(array $where)
Compiles date range clauses.
in Compiler at line 605
protected string
in(array $where)
Compiles IN clauses.
in Compiler at line 618
protected string
null(array $where)
Compiles IS NULL clauses.
in Compiler at line 629
protected string
exists(array $where)
Compiles EXISTS clauses.
in Compiler at line 640
protected string
nestedWhere(array $where)
Compiles nested WHERE conditions.
in Compiler at line 651
protected string
whereConditions(array $wheres)
Compiles WHERE conditions.
in Compiler at line 673
protected string
wheres(array $wheres)
Compiles WHERE clauses.
in Compiler at line 689
protected string
joinCondition(array $condition)
Compiles a JOIN condition.
in Compiler at line 700
protected string
nestedJoinCondition(array $condition)
Compiles nested JOIN condition.
in Compiler at line 735
protected string
joins(array $joins)
Compiles JOIN clauses.
in Compiler at line 758
protected string
groupings(array $groupings)
Compiles GROUP BY clauses.
in Compiler at line 769
protected string
orderings(array $orderings)
Compiles ORDER BY clauses.
in Compiler at line 792
protected string
havingCondictions(array $havings)
Compiles HAVING conditions.
in Compiler at line 814
protected string
havings(array $havings)
Compiles HAVING clauses.
in Compiler at line 830
protected string
limit(int|null $limit)
Compiles LIMIT clauses.
in Compiler at line 841
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 862
array
select()
Compiles a SELECT query.
in Compiler at line 888
protected string
insertWithValues(array $values)
Returns a INSERT query with values.
in Compiler at line 903
protected string
insertWithoutValues()
Returns a INSERT query without values.
in Compiler at line 914
array
insert(array $values = [])
Compiles a INSERT query.
in Compiler at line 936
protected string
updateColumns(array $columns)
Compiles update columns.
in Compiler at line 967
array
update(array $values)
Compiles a UPDATE query.
in Compiler at line 984
array
delete()
Compiles a DELETE query.