Oracle
class Oracle extends Compiler
Compiles Oracle queries.
Traits
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.
Builds a JSON value getter.
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 the FROM clause.
Compiles date comparison clauses.
Compiles date range clauses.
Compiles ORDER BY clauses.
Compiles LIMIT clauses.
Compiles OFFSET clauses.
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.
in Compiler at line 156
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?
at line 29
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.
at line 37
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.
at line 53
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.
at line 45
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.
at line 74
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.
at line 87
protected string
limit(int|null $limit)
Compiles LIMIT clauses.
at line 107
protected string
offset(int|null $offset)
Compiles OFFSET clauses.
at line 61
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.
in JsonPathBuilderTrait at line 26
protected string
buildJsonPath(array $segments)
Builds a JSON path.