PHP Class Yajra\Oci8\Schema\Grammars\OracleGrammar

Inheritance: extends Illuminate\Database\Schema\Grammars\Grammar, use trait Yajra\Oci8\OracleReservedWords

Show file Open project: yajra/laravel-oci8

Protected Properties

Property	Type	Description
$modifiers	array	The possible column modifiers.
$schema_prefix	string
$serials	array	The possible column serials
$transactions	boolean	If this Grammar supports schema changes wrapped in a transaction.
$wrapper	string	The keyword identifier wrapper format.

Public Methods

Method	Description
compileAdd ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile an add column command.
compileColumnExists ( string $database, string $table ) : string	Compile the query to determine the list of columns.
compileCreate ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a create table command.
compileDrop ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a drop table command.
compileDropColumn ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a drop column command.
compileDropForeign ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a drop foreign key command.
compileDropIfExists ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a drop table (if exists) command.
compileDropIndex ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a drop index command.
compileDropPrimary ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a drop primary key command.
compileDropUnique ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a drop unique key command.
compileForeign ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string \| void	Compile a foreign key command.
compileIndex ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a plain index key command.
compilePrimary ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a primary key command.
compileRename ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a rename table command.
compileRenameColumn ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command, Connection $connection ) : array	Compile a rename column command.
compileTableExists ( ) : string	Compile the query to determine if a table exists.
compileUnique ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string	Compile a unique key command.
getSchemaPrefix ( ) : string	Get the schema prefix.
setSchemaPrefix ( string $prefix )	Set the schema prefix.
wrapTable ( mixed $table ) : string	Wrap a table in keyword identifiers.

Protected Methods

Method	Description
addForeignKeys ( Illuminate\Database\Schema\Blueprint $blueprint ) : string	Get the foreign key syntax for a table creation statement.
addPrimaryKeys ( Illuminate\Database\Schema\Blueprint $blueprint ) : string \| null	Get the primary key syntax for a table creation statement.
modifyDefault ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $column ) : string	Get the SQL for a default column modifier.
modifyIncrement ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $column ) : string \| null	Get the SQL for an auto-increment column modifier.
modifyNullable ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $column ) : string	Get the SQL for a nullable column modifier.
typeBigInteger ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a integer type.
typeBinary ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a binary type.
typeBoolean ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a boolean type.
typeChar ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a char type.
typeDate ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a date type.
typeDateTime ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a date-time type.
typeDecimal ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a decimal type.
typeDouble ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a double type.
typeEnum ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a enum type.
typeFloat ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a float type.
typeInteger ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a integer type.
typeLongText ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a long text type.
typeMediumInteger ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a medium integer type.
typeMediumText ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a medium text type.
typeNvarchar2 ( Illuminate\Support\Fluent $column ) : string	Create column definition for a nvarchar type.
typeSmallInteger ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a small integer type.
typeString ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a string type.
typeText ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a text type.
typeTime ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a time type.
typeTimestamp ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a timestamp type.
typeTimestampTz ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a timestamp type with timezone.
typeTinyInteger ( Illuminate\Support\Fluent $column ) : string	Create the column definition for a tiny integer type.
wrapValue ( string $value ) : string	Wrap a single string in keyword identifiers.

Private Methods

Method	Description
dropConstraint ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command, string $type ) : string

Method Details

addForeignKeys() protected method

Get the foreign key syntax for a table creation statement.

protected addForeignKeys ( Illuminate\Database\Schema\Blueprint $blueprint ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
return	string

addPrimaryKeys() protected method

Get the primary key syntax for a table creation statement.

protected addPrimaryKeys ( Illuminate\Database\Schema\Blueprint $blueprint ) : string \| null
$blueprint	Illuminate\Database\Schema\Blueprint
return	string \| null

compileAdd() public method

Compile an add column command.

public compileAdd ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileColumnExists() public method

Compile the query to determine the list of columns.

public compileColumnExists ( string $database, string $table ) : string
$database	string
$table	string
return	string

compileCreate() public method

Compile a create table command.

public compileCreate ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileDrop() public method

Compile a drop table command.

public compileDrop ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileDropColumn() public method

Compile a drop column command.

public compileDropColumn ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileDropForeign() public method

Compile a drop foreign key command.

public compileDropForeign ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileDropIfExists() public method

Compile a drop table (if exists) command.

public compileDropIfExists ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileDropIndex() public method

Compile a drop index command.

public compileDropIndex ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileDropPrimary() public method

Compile a drop primary key command.

public compileDropPrimary ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileDropUnique() public method

Compile a drop unique key command.

public compileDropUnique ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileForeign() public method

Compile a foreign key command.

public compileForeign ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string \| void
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string \| void

compileIndex() public method

Compile a plain index key command.

public compileIndex ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compilePrimary() public method

Compile a primary key command.

public compilePrimary ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileRename() public method

Compile a rename table command.

public compileRename ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

compileRenameColumn() public method

Compile a rename column command.

public compileRenameColumn ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command, Connection $connection ) : array
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
$connection	Illuminate\Database\Connection
return	array

compileTableExists() public method

Compile the query to determine if a table exists.

public compileTableExists ( ) : string
return	string

compileUnique() public method

Compile a unique key command.

public compileUnique ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$command	Illuminate\Support\Fluent
return	string

getSchemaPrefix() public method

Get the schema prefix.

public getSchemaPrefix ( ) : string
return	string

modifyDefault() protected method

Get the SQL for a default column modifier.

protected modifyDefault ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $column ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$column	Illuminate\Support\Fluent
return	string

modifyIncrement() protected method

Get the SQL for an auto-increment column modifier.

protected modifyIncrement ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $column ) : string \| null
$blueprint	Illuminate\Database\Schema\Blueprint
$column	Illuminate\Support\Fluent
return	string \| null

modifyNullable() protected method

Get the SQL for a nullable column modifier.

protected modifyNullable ( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $column ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
$column	Illuminate\Support\Fluent
return	string

setSchemaPrefix() public method

Set the schema prefix.

public setSchemaPrefix ( string $prefix )
$prefix	string

typeBigInteger() protected method

Create the column definition for a integer type.

protected typeBigInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeBinary() protected method

Create the column definition for a binary type.

protected typeBinary ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeBoolean() protected method

Create the column definition for a boolean type.

protected typeBoolean ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeChar() protected method

Create the column definition for a char type.

protected typeChar ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeDate() protected method

Create the column definition for a date type.

protected typeDate ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeDateTime() protected method

Create the column definition for a date-time type.

protected typeDateTime ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeDecimal() protected method

Create the column definition for a decimal type.

protected typeDecimal ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeDouble() protected method

Create the column definition for a double type.

protected typeDouble ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeEnum() protected method

Create the column definition for a enum type.

protected typeEnum ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeFloat() protected method

Create the column definition for a float type.

protected typeFloat ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeInteger() protected method

Create the column definition for a integer type.

protected typeInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeLongText() protected method

Create the column definition for a long text type.

protected typeLongText ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeMediumInteger() protected method

Create the column definition for a medium integer type.

protected typeMediumInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeMediumText() protected method

Create the column definition for a medium text type.

protected typeMediumText ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeNvarchar2() protected method

Create column definition for a nvarchar type.

protected typeNvarchar2 ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeSmallInteger() protected method

Create the column definition for a small integer type.

protected typeSmallInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeString() protected method

Create the column definition for a string type.

protected typeString ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeText() protected method

Create the column definition for a text type.

protected typeText ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeTime() protected method

Create the column definition for a time type.

protected typeTime ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeTimestamp() protected method

Create the column definition for a timestamp type.

protected typeTimestamp ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeTimestampTz() protected method

Create the column definition for a timestamp type with timezone.

protected typeTimestampTz ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

typeTinyInteger() protected method

Create the column definition for a tiny integer type.

protected typeTinyInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
return	string

wrapTable() public method

Wrap a table in keyword identifiers.

public wrapTable ( mixed $table ) : string
$table	mixed
return	string

wrapValue() protected method

Wrap a single string in keyword identifiers.

protected wrapValue ( string $value ) : string
$value	string
return	string

Property Details

$modifiers protected property

The possible column modifiers.

protected array $modifiers
return	array

$schema_prefix protected property

protected string $schema_prefix
return	string

$serials protected property

The possible column serials

protected array $serials
return	array

$transactions protected property

If this Grammar supports schema changes wrapped in a transaction.

protected bool $transactions
return	boolean

$wrapper protected property

The keyword identifier wrapper format.

protected string $wrapper
return	string