Firebird
class Firebird extends Compiler
Compiles Firebird 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
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 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 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.
in Compiler at line 169
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 553
protected string
where(array $where)
Compiles WHERE conditions.
in Compiler at line 573
protected string
whereRaw(array $where)
Compiles a raw WHERE condition.
at line 41
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.
at line 33
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.
at line 49
protected string
limit(int|null $limit)
Compiles LIMIT clauses.
at line 59
protected string
offset(int|null $offset)
Compiles OFFSET clauses.
at line 69
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.