PHP Class Yajra\Oci8\Schema\Grammars\OracleGrammar

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

Afficher le fichier Open project: yajra/laravel-oci8

Protected Properties

Свойство	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.

Méthodes publiques

Méthode	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.

Méthodes protégées

Méthode	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

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

Method Details

addForeignKeys() protected méthode

Get the foreign key syntax for a table creation statement.

protected addForeignKeys ( Illuminate\Database\Schema\Blueprint $blueprint ) : string
$blueprint	Illuminate\Database\Schema\Blueprint
Résultat	string

addPrimaryKeys() protected méthode

Get the primary key syntax for a table creation statement.

protected addPrimaryKeys ( Illuminate\Database\Schema\Blueprint $blueprint ) : string \| null
$blueprint	Illuminate\Database\Schema\Blueprint
Résultat	string \| null

compileAdd() public méthode

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
Résultat	string

compileColumnExists() public méthode

Compile the query to determine the list of columns.

public compileColumnExists ( string $database, string $table ) : string
$database	string
$table	string
Résultat	string

compileCreate() public méthode

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
Résultat	string

compileDrop() public méthode

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
Résultat	string

compileDropColumn() public méthode

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
Résultat	string

compileDropForeign() public méthode

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
Résultat	string

compileDropIfExists() public méthode

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
Résultat	string

compileDropIndex() public méthode

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
Résultat	string

compileDropPrimary() public méthode

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
Résultat	string

compileDropUnique() public méthode

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
Résultat	string

compileForeign() public méthode

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
Résultat	string \| void

compileIndex() public méthode

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
Résultat	string

compilePrimary() public méthode

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
Résultat	string

compileRename() public méthode

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
Résultat	string

compileRenameColumn() public méthode

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
Résultat	array

compileTableExists() public méthode

Compile the query to determine if a table exists.

public compileTableExists ( ) : string
Résultat	string

compileUnique() public méthode

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
Résultat	string

getSchemaPrefix() public méthode

Get the schema prefix.

public getSchemaPrefix ( ) : string
Résultat	string

modifyDefault() protected méthode

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
Résultat	string

modifyIncrement() protected méthode

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
Résultat	string \| null

modifyNullable() protected méthode

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
Résultat	string

setSchemaPrefix() public méthode

Set the schema prefix.

public setSchemaPrefix ( string $prefix )
$prefix	string

typeBigInteger() protected méthode

Create the column definition for a integer type.

protected typeBigInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeBinary() protected méthode

Create the column definition for a binary type.

protected typeBinary ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeBoolean() protected méthode

Create the column definition for a boolean type.

protected typeBoolean ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeChar() protected méthode

Create the column definition for a char type.

protected typeChar ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeDate() protected méthode

Create the column definition for a date type.

protected typeDate ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeDateTime() protected méthode

Create the column definition for a date-time type.

protected typeDateTime ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeDecimal() protected méthode

Create the column definition for a decimal type.

protected typeDecimal ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeDouble() protected méthode

Create the column definition for a double type.

protected typeDouble ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeEnum() protected méthode

Create the column definition for a enum type.

protected typeEnum ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeFloat() protected méthode

Create the column definition for a float type.

protected typeFloat ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeInteger() protected méthode

Create the column definition for a integer type.

protected typeInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeLongText() protected méthode

Create the column definition for a long text type.

protected typeLongText ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeMediumInteger() protected méthode

Create the column definition for a medium integer type.

protected typeMediumInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeMediumText() protected méthode

Create the column definition for a medium text type.

protected typeMediumText ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeNvarchar2() protected méthode

Create column definition for a nvarchar type.

protected typeNvarchar2 ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeSmallInteger() protected méthode

Create the column definition for a small integer type.

protected typeSmallInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeString() protected méthode

Create the column definition for a string type.

protected typeString ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeText() protected méthode

Create the column definition for a text type.

protected typeText ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeTime() protected méthode

Create the column definition for a time type.

protected typeTime ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeTimestamp() protected méthode

Create the column definition for a timestamp type.

protected typeTimestamp ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeTimestampTz() protected méthode

Create the column definition for a timestamp type with timezone.

protected typeTimestampTz ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

typeTinyInteger() protected méthode

Create the column definition for a tiny integer type.

protected typeTinyInteger ( Illuminate\Support\Fluent $column ) : string
$column	Illuminate\Support\Fluent
Résultat	string

wrapTable() public méthode

Wrap a table in keyword identifiers.

public wrapTable ( mixed $table ) : string
$table	mixed
Résultat	string

wrapValue() protected méthode

Wrap a single string in keyword identifiers.

protected wrapValue ( string $value ) : string
$value	string
Résultat	string

Property Details

$modifiers protected_oe property

The possible column modifiers.

protected array $modifiers
Résultat	array

$schema_prefix protected_oe property

protected string $schema_prefix
Résultat	string

$serials protected_oe property

The possible column serials

protected array $serials
Résultat	array

$transactions protected_oe property

If this Grammar supports schema changes wrapped in a transaction.

protected bool $transactions
Résultat	boolean

$wrapper protected_oe property

The keyword identifier wrapper format.

protected string $wrapper
Résultat	string