Overview

Namespaces

  • None
  • Yajra
    • Oci8
      • Auth
      • Connectors
      • Eloquent
      • Query
        • Grammars
        • Processors
      • Schema
        • Grammars

Classes

  • OracleGrammar
  • Overview
  • Namespace
  • Class

Class OracleGrammar

Illuminate\Database\Schema\Grammars\Grammar
Extended by Yajra\Oci8\Schema\Grammars\OracleGrammar uses Yajra\Oci8\OracleReservedWords
Namespace: Yajra\Oci8\Schema\Grammars
Located at Oci8/Schema/Grammars/OracleGrammar.php
Methods summary
public string
# compileCreate( Illuminate\Database\Schema\Blueprint $blueprint, Illuminate\Support\Fluent $command )

Compile a create table command.

Compile a create table command.

Parameters

$blueprint
$command

Returns

string
public string
# wrapTable( mixed $table )

Wrap a table in keyword identifiers.

Wrap a table in keyword identifiers.

Parameters

$table

Returns

string
public string
# getSchemaPrefix( )

Get the schema prefix.

Get the schema prefix.

Returns

string
public
# setSchemaPrefix( string $prefix )

Set the schema prefix.

Set the schema prefix.

Parameters

$prefix
protected string
# addForeignKeys( Illuminate\Database\Schema\Blueprint $blueprint )

Get the foreign key syntax for a table creation statement.

Get the foreign key syntax for a table creation statement.

Parameters

$blueprint

Returns

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

Get the primary key syntax for a table creation statement.

Get the primary key syntax for a table creation statement.

Parameters

$blueprint

Returns

string|null
public string
# compileTableExists( )

Compile the query to determine if a table exists.

Compile the query to determine if a table exists.

Returns

string
public string
# compileColumnExists( string $database, string $table )

Compile the query to determine the list of columns.

Compile the query to determine the list of columns.

Parameters

$database
$table

Returns

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

Compile an add column command.

Compile an add column command.

Parameters

$blueprint
$command

Returns

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

Compile a primary key command.

Compile a primary key command.

Parameters

$blueprint
$command

Returns

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

Compile a foreign key command.

Compile a foreign key command.

Parameters

$blueprint
$command

Returns

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

Compile a unique key command.

Compile a unique key command.

Parameters

$blueprint
$command

Returns

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

Compile a plain index key command.

Compile a plain index key command.

Parameters

$blueprint
$command

Returns

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

Compile a drop table command.

Compile a drop table command.

Parameters

$blueprint
$command

Returns

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

Compile a drop table (if exists) command.

Compile a drop table (if exists) command.

Parameters

$blueprint
$command

Returns

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

Compile a drop column command.

Compile a drop column command.

Parameters

$blueprint
$command

Returns

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

Compile a drop primary key command.

Compile a drop primary key command.

Parameters

$blueprint
$command

Returns

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

Compile a drop unique key command.

Compile a drop unique key command.

Parameters

$blueprint
$command

Returns

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

Compile a drop index command.

Compile a drop index command.

Parameters

$blueprint
$command

Returns

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

Compile a drop foreign key command.

Compile a drop foreign key command.

Parameters

$blueprint
$command

Returns

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

Compile a rename table command.

Compile a rename table command.

Parameters

$blueprint
$command

Returns

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

Compile a rename column command.

Compile a rename column command.

Parameters

$blueprint
$command
$connection

Returns

array
protected string
# typeChar( Illuminate\Support\Fluent $column )

Create the column definition for a char type.

Create the column definition for a char type.

Parameters

$column

Returns

string
protected string
# typeString( Illuminate\Support\Fluent $column )

Create the column definition for a string type.

Create the column definition for a string type.

Parameters

$column

Returns

string
protected string
# typeNvarchar2( Illuminate\Support\Fluent $column )

Create column definition for a nvarchar type.

Create column definition for a nvarchar type.

Parameters

$column

Returns

string
protected string
# typeText( Illuminate\Support\Fluent $column )

Create the column definition for a text type.

Create the column definition for a text type.

Parameters

$column

Returns

string
protected string
# typeMediumText( Illuminate\Support\Fluent $column )

Create the column definition for a medium text type.

Create the column definition for a medium text type.

Parameters

$column

Returns

string
protected string
# typeLongText( Illuminate\Support\Fluent $column )

Create the column definition for a long text type.

Create the column definition for a long text type.

Parameters

$column

Returns

string
protected string
# typeInteger( Illuminate\Support\Fluent $column )

Create the column definition for a integer type.

Create the column definition for a integer type.

Parameters

$column

Returns

string
protected string
# typeBigInteger( Illuminate\Support\Fluent $column )

Create the column definition for a integer type.

Create the column definition for a integer type.

Parameters

$column

Returns

string
protected string
# typeMediumInteger( Illuminate\Support\Fluent $column )

Create the column definition for a medium integer type.

Create the column definition for a medium integer type.

Parameters

$column

Returns

string
protected string
# typeSmallInteger( Illuminate\Support\Fluent $column )

Create the column definition for a small integer type.

Create the column definition for a small integer type.

Parameters

$column

Returns

string
protected string
# typeTinyInteger( Illuminate\Support\Fluent $column )

Create the column definition for a tiny integer type.

Create the column definition for a tiny integer type.

Parameters

$column

Returns

string
protected string
# typeFloat( Illuminate\Support\Fluent $column )

Create the column definition for a float type.

Create the column definition for a float type.

Parameters

$column

Returns

string
protected string
# typeDouble( Illuminate\Support\Fluent $column )

Create the column definition for a double type.

Create the column definition for a double type.

Parameters

$column

Returns

string
protected string
# typeDecimal( Illuminate\Support\Fluent $column )

Create the column definition for a decimal type.

Create the column definition for a decimal type.

Parameters

$column

Returns

string
protected string
# typeBoolean( Illuminate\Support\Fluent $column )

Create the column definition for a boolean type.

Create the column definition for a boolean type.

Parameters

$column

Returns

string
protected string
# typeEnum( Illuminate\Support\Fluent $column )

Create the column definition for a enum type.

Create the column definition for a enum type.

Parameters

$column

Returns

string
protected string
# typeDate( Illuminate\Support\Fluent $column )

Create the column definition for a date type.

Create the column definition for a date type.

Parameters

$column

Returns

string
protected string
# typeDateTime( Illuminate\Support\Fluent $column )

Create the column definition for a date-time type.

Create the column definition for a date-time type.

Parameters

$column

Returns

string
protected string
# typeTime( Illuminate\Support\Fluent $column )

Create the column definition for a time type.

Create the column definition for a time type.

Parameters

$column

Returns

string
protected string
# typeTimestamp( Illuminate\Support\Fluent $column )

Create the column definition for a timestamp type.

Create the column definition for a timestamp type.

Parameters

$column

Returns

string
protected string
# typeTimestampTz( Illuminate\Support\Fluent $column )

Create the column definition for a timestamp type with timezone.

Create the column definition for a timestamp type with timezone.

Parameters

$column

Returns

string
protected string
# typeBinary( Illuminate\Support\Fluent $column )

Create the column definition for a binary type.

Create the column definition for a binary type.

Parameters

$column

Returns

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

Get the SQL for a nullable column modifier.

Get the SQL for a nullable column modifier.

Parameters

$blueprint
$column

Returns

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

Get the SQL for a default column modifier.

Get the SQL for a default column modifier.

Parameters

$blueprint
$column

Returns

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

Get the SQL for an auto-increment column modifier.

Get the SQL for an auto-increment column modifier.

Parameters

$blueprint
$column

Returns

string|null
protected string
# wrapValue( string $value )

Wrap a single string in keyword identifiers.

Wrap a single string in keyword identifiers.

Parameters

$value

Returns

string
Methods used from Yajra\Oci8\OracleReservedWords
isReserved()
Properties summary
protected string $wrapper

The keyword identifier wrapper format.

The keyword identifier wrapper format.
# '%s'
protected array $modifiers

The possible column modifiers.

The possible column modifiers.
# ['Increment', 'Nullable', 'Default']
protected array $serials

The possible column serials

The possible column serials
# ['bigInteger', 'integer', 'mediumInteger', 'smallInteger', 'tinyInteger']
protected string $schema_prefix
# ''
protected boolean $transactions

If this Grammar supports schema changes wrapped in a transaction.

If this Grammar supports schema changes wrapped in a transaction.
# true
Properties used from Yajra\Oci8\OracleReservedWords
$reserves
API documentation generated by ApiGen