PHP Class yajra\Oci8\Query\OracleBuilder

Inheritance: extends Illuminate\Database\Query\Builder
Mostra file Open project: yajra/laravel-oci8 Class Usage Examples

Public Methods

Method Description
insertLob ( array $values, array $binaries, string $sequence = 'id' ) : integer Insert a new record and get the value of the primary key.
updateLob ( array $values, array $binaries, string $sequence = 'id' ) : boolean Update a new record with blob field.
whereIn ( string $column, mixed $values, string $boolean = 'and', boolean $not = false ) : Builder | OracleBuilder Add a "where in" clause to the query.

Protected Methods

Method Description
runSelect ( ) : array Run the query as a "select" statement against the connection.

Method Details

insertLob() public method

Insert a new record and get the value of the primary key.
public insertLob ( array $values, array $binaries, string $sequence = 'id' ) : integer
$values array
$binaries array
$sequence string
return integer

runSelect() protected method

Run the query as a "select" statement against the connection.
protected runSelect ( ) : array
return array

updateLob() public method

Update a new record with blob field.
public updateLob ( array $values, array $binaries, string $sequence = 'id' ) : boolean
$values array
$binaries array
$sequence string
return boolean

whereIn() public method

Split one WHERE IN clause into multiple clauses each with up to 1000 expressions to avoid ORA-01795
public whereIn ( string $column, mixed $values, string $boolean = 'and', boolean $not = false ) : Builder | OracleBuilder
$column string
$values mixed
$boolean string
$not boolean
return Illuminate\Database\Query\Builder | OracleBuilder