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
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 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 76
static
setDateFormat(string $dateFormat)
Sets the date format.
in Compiler at line 86
static string
getDateFormat()
Gets the date format.
in Compiler at line 115
protected string
subselect(Query $query)
Compiles a subselect and merges the parameters.
in Compiler at line 131
protected string
subquery(Subquery $subquery, bool $enclose = true)
Compiles a subquery.
in Compiler at line 160
string
escapeIdentifier(string $identifier)
Returns an escaped identifier.
in Compiler at line 171
string
escapeIdentifiers(array $identifiers)
Returns an array of escaped identifiers.
in Compiler at line 187
protected bool
hasJsonPath(string $string)
Does the string have a JSON path?
at line 27
protected string
buildJsonGet(string $column, array $segments)
Builds a JSON value getter.
in Compiler at line 212
protected string
buildJsonSet(string $column, array $segments, string $param)
Builds a JSON value setter.
in Compiler at line 223
string
escapeTableName(string $table)
Escapes a table name.
in Compiler at line 267
string
tables(array $tables)
Returns a comma-separated list of tables.
in Compiler at line 285
string
escapeColumnName(string $column)
Escapes a column name.
in Compiler at line 310
string
columnName(string $column)
Compiles a column name.
in Compiler at line 330
string
columnNames(array $columns)
Returns a comma-separated list of column names.
in Compiler at line 349
string
column(Raw|Subquery|string $column, bool $allowAlias = false)
Compiles a column.
in Compiler at line 376
string
columns(array $columns, bool $allowAlias = false)
Returns a comma-separated list of compiled columns.
in Compiler at line 394
protected string
commonTableExpressions(array $commonTableExpressions)
Compiles common table expressions.
in Compiler at line 426
protected string
setOperations(array $setOperations)
Compiles set operations.
in Compiler at line 450
protected string
param(mixed $param, bool $enclose = true)
Returns raw SQL or a paramter placeholder.
in Compiler at line 479
protected string
params(array $params, bool $enclose = true)
Returns a comma-separated list of parameters.
in Compiler at line 497
protected string
simpleParam(mixed $param)
Returns a parameter placeholder.
in Compiler at line 510
protected string
simpleParams(array $params)
Returns a comma-separated list of parameter placeholders.
in Compiler at line 544
protected string
where(array $where)
Compiles WHERE conditions.
in Compiler at line 564
protected string
whereRaw(array $where)
Compiles a raw WHERE condition.
at line 51
protected string
whereDate(array $where)
Compiles date comparison clauses.
in Compiler at line 586
protected string
whereColumn(array $where)
Compiles column comparison clauses.
in Compiler at line 606
protected string
between(array $where)
Compiles BETWEEN clauses.
at line 43
protected string
betweenDate(array $where)
Compiles date range clauses.
in Compiler at line 628
protected string
in(array $where)
Compiles IN clauses.
in Compiler at line 641
protected string
null(array $where)
Compiles IS NULL clauses.
in Compiler at line 652
protected string
exists(array $where)
Compiles EXISTS clauses.
in Compiler at line 663
protected string
nestedWhere(array $where)
Compiles nested WHERE conditions.
in Compiler at line 674
protected string
whereConditions(array $wheres)
Compiles WHERE conditions.
in Compiler at line 696
protected string
wheres(array $wheres)
Compiles WHERE clauses.
in Compiler at line 712
protected string
joinCondition(array $condition)
Compiles a JOIN condition.
in Compiler at line 723
protected string
nestedJoinCondition(array $condition)
Compiles nested JOIN condition.
in Compiler at line 758
protected string
joins(array $joins)
Compiles JOIN clauses.
in Compiler at line 781
protected string
groupings(array $groupings)
Compiles GROUP BY clauses.
at line 72
protected string
orderings(array $orderings)
Compiles ORDER BY clauses.
in Compiler at line 815
protected string
havingCondictions(array $havings)
Compiles HAVING conditions.
in Compiler at line 837
protected string
havings(array $havings)
Compiles HAVING clauses.
at line 85
protected string
limit(int|null $limit)
Compiles LIMIT clauses.
at line 105
protected string
offset(int|null $offset)
Compiles OFFSET clauses.
at line 59
string
lock(bool|string|null $lock)
Compiles locking clause.
in Compiler at line 885
array
select()
Compiles a SELECT query.
in Compiler at line 911
protected string
insertWithValues(array $values)
Returns a INSERT query with values.
in Compiler at line 926
protected string
insertWithoutValues()
Returns a INSERT query without values.
in Compiler at line 937
array
insert(array $values = [])
Compiles a INSERT query.
in Compiler at line 959
protected string
updateColumns(array $columns)
Compiles update columns.
in Compiler at line 990
array
update(array $values)
Compiles a UPDATE query.
in Compiler at line 1007
array
delete()
Compiles a DELETE query.
in JsonPathBuilderTrait at line 24
protected string
buildJsonPath(array $segments)
Builds a JSON path.