PHP Class yajra\Oci8\Query\Grammars\OracleGrammar

Inheritance: extends Illuminate\Database\Query\Grammars\Grammar, use trait Yajra\Oci8\OracleReservedWords
ファイルを表示 Open project: yajra/laravel-oci8 Class Usage Examples

Protected Properties

Property Type Description
$schema_prefix string
$wrapper string The keyword identifier wrapper format.

Public Methods

Method Description
compileExists ( Builder $query ) : string Compile an exists statement into SQL.
compileInsert ( Builder $query, array $values ) : string Compile an insert statement into SQL.
compileInsertGetId ( Builder $query, array $values, string $sequence = 'id' ) : string Compile an insert and get ID statement into SQL.
compileInsertLob ( Builder $query, array $values, array $binaries, string $sequence = 'id' ) : string Compile an insert with blob field statement into SQL.
compileSelect ( Builder $query ) : string Compile a select query into SQL.
compileTruncate ( Builder $query ) : array Compile a truncate table statement into SQL.
compileUpdateLob ( Builder $query, array $values, array $binaries, string $sequence = 'id' ) : string Compile an update statement into SQL.
getSchemaPrefix ( ) : string Return the schema prefix.
setSchemaPrefix ( string $prefix ) Set the schema prefix.
wrapTable ( Illuminate\Database\Query\Expression | string $table ) : string Wrap a table in keyword identifiers.

Protected Methods

Method Description
compileAnsiOffset ( Builder $query, array $components ) : string Create a full ANSI offset clause for the query.
compileLimit ( Builder $query, integer $limit ) : string Compile the "limit" portions of the query.
compileLock ( Builder $query, boolean | string $value ) : string Compile the lock into SQL.
compileOffset ( Builder $query, integer $offset ) : string Compile the "offset" portions of the query.
compileRowConstraint ( Builder $query ) : string Compile the limit / offset row constraint for a query.
compileTableExpression ( string $sql, string $constraint, Builder $query ) : string Compile a common table expression for a query.
dateBasedWhere ( string $type, Builder $query, array $where ) : string Compile a date based where clause.
isPaginationable ( Builder $query, array $components ) : boolean
whereDate ( Builder $query, array $where ) : string Compile a "where date" clause.
wrapValue ( string $value ) : string Wrap a single string in keyword identifiers.

Method Details

compileAnsiOffset() protected method

Create a full ANSI offset clause for the query.
protected compileAnsiOffset ( Builder $query, array $components ) : string
$query Illuminate\Database\Query\Builder
$components array
return string

compileExists() public method

Compile an exists statement into SQL.
public compileExists ( Builder $query ) : string
$query Illuminate\Database\Query\Builder
return string

compileInsert() public method

Compile an insert statement into SQL.
public compileInsert ( Builder $query, array $values ) : string
$query Illuminate\Database\Query\Builder
$values array
return string

compileInsertGetId() public method

Compile an insert and get ID statement into SQL.
public compileInsertGetId ( Builder $query, array $values, string $sequence = 'id' ) : string
$query Illuminate\Database\Query\Builder
$values array
$sequence string
return string

compileInsertLob() public method

Compile an insert with blob field statement into SQL.
public compileInsertLob ( Builder $query, array $values, array $binaries, string $sequence = 'id' ) : string
$query Illuminate\Database\Query\Builder
$values array
$binaries array
$sequence string
return string

compileLimit() protected method

Compile the "limit" portions of the query.
protected compileLimit ( Builder $query, integer $limit ) : string
$query Illuminate\Database\Query\Builder
$limit integer
return string

compileLock() protected method

Compile the lock into SQL.
protected compileLock ( Builder $query, boolean | string $value ) : string
$query Illuminate\Database\Query\Builder
$value boolean | string
return string

compileOffset() protected method

Compile the "offset" portions of the query.
protected compileOffset ( Builder $query, integer $offset ) : string
$query Illuminate\Database\Query\Builder
$offset integer
return string

compileRowConstraint() protected method

Compile the limit / offset row constraint for a query.
protected compileRowConstraint ( Builder $query ) : string
$query Illuminate\Database\Query\Builder
return string

compileSelect() public method

Compile a select query into SQL.
public compileSelect ( Builder $query ) : string
$query Illuminate\Database\Query\Builder
return string

compileTableExpression() protected method

Compile a common table expression for a query.
protected compileTableExpression ( string $sql, string $constraint, Builder $query ) : string
$sql string
$constraint string
$query Illuminate\Database\Query\Builder
return string

compileTruncate() public method

Compile a truncate table statement into SQL.
public compileTruncate ( Builder $query ) : array
$query Illuminate\Database\Query\Builder
return array

compileUpdateLob() public method

Compile an update statement into SQL.
public compileUpdateLob ( Builder $query, array $values, array $binaries, string $sequence = 'id' ) : string
$query Illuminate\Database\Query\Builder
$values array
$binaries array
$sequence string
return string

dateBasedWhere() protected method

Compile a date based where clause.
protected dateBasedWhere ( string $type, Builder $query, array $where ) : string
$type string
$query Illuminate\Database\Query\Builder
$where array
return string

getSchemaPrefix() public method

Return the schema prefix.
public getSchemaPrefix ( ) : string
return string

isPaginationable() protected method

protected isPaginationable ( Builder $query, array $components ) : boolean
$query Illuminate\Database\Query\Builder
$components array
return boolean

setSchemaPrefix() public method

Set the schema prefix.
public setSchemaPrefix ( string $prefix )
$prefix string

whereDate() protected method

Compile a "where date" clause.
protected whereDate ( Builder $query, array $where ) : string
$query Illuminate\Database\Query\Builder
$where array
return string

wrapTable() public method

Wrap a table in keyword identifiers.
public wrapTable ( Illuminate\Database\Query\Expression | string $table ) : string
$table Illuminate\Database\Query\Expression | string
return string

wrapValue() protected method

Wrap a single string in keyword identifiers.
protected wrapValue ( string $value ) : string
$value string
return string

Property Details

$schema_prefix protected_oe property

protected string $schema_prefix
return string

$wrapper protected_oe property

The keyword identifier wrapper format.
protected string $wrapper
return string