字典我要纠错

PostgresGrammar (Database\Schema\Grammars)

PostgresGrammar

class PostgresGrammar extends Grammar (View source)

Methods

array

wrapArray(array $values)

Wrap an array of values.

from Grammar

string

wrapTable(Expression|string $table)

Wrap a table in keyword identifiers.

from Grammar

string

wrap(Expression|string $value, bool $prefixAlias = false)

Wrap a value in keyword identifiers.

from Grammar

string

columnize(array $columns)

Convert an array of column names into a delimited string.

from Grammar

string

parameterize(array $values)

Create query parameter place-holders for an array.

from Grammar

string

parameter(mixed $value)

Get the appropriate query parameter place-holder for a value.

from Grammar

string

getValue(Expression $expression)

Get the value of a raw expression.

from Grammar

bool

isExpression(mixed $value)

Determine if the given value is a raw expression.

from Grammar

string

getDateFormat()

Get the format for database stored dates.

from Grammar

string

getTablePrefix()

Get the grammar's table prefix.

from Grammar

$this

setTablePrefix(string $prefix)

Set the grammar's table prefix.

from Grammar

array

compileRenameColumn(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a rename column command.

from Grammar

string

compileForeign(Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

from Grammar

array

prefixArray(string $prefix, array $values)

Add a prefix to an array of values.

from Grammar

array

compileChange(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a change column command into a series of SQL statements.

from Grammar

bool

supportsSchemaTransactions()

Check if this Grammar supports schema changes wrapped in a transaction.

from Grammar

string

compileTableExists()

Compile the query to determine if a table exists.

string

compileColumnExists(string $table)

Compile the query to determine the list of columns.

string

compileCreate(Blueprint $blueprint, Fluent $command)

Compile a create table command.

string

compileAdd(Blueprint $blueprint, Fluent $command)

Compile a column addition command.

string

compilePrimary(Blueprint $blueprint, Fluent $command)

Compile a primary key command.

string

compileUnique(Blueprint $blueprint, Fluent $command)

Compile a unique key command.

string

compileIndex(Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

string

compileDrop(Blueprint $blueprint, Fluent $command)

Compile a drop table command.

string

compileDropIfExists(Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

string

compileDropColumn(Blueprint $blueprint, Fluent $command)

Compile a drop column command.

string

compileDropPrimary(Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

string

compileDropUnique(Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

string

compileDropIndex(Blueprint $blueprint, Fluent $command)

Compile a drop index command.

string

compileDropForeign(Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

string

compileEnableForeignKeyConstraints()

Compile the command to enable foreign key constraints.

string

compileDisableForeignKeyConstraints()

Compile the command to disable foreign key constraints.

string

compileRename(Blueprint $blueprint, Fluent $command)

Compile a rename table command.

Details

array wrapArray(array $values)

Wrap an array of values.

Parameters

array

$values

Return Value

array

string wrapTable(Expression|string $table)

Wrap a table in keyword identifiers.

Parameters

Expression|string

$table

Return Value

string

string wrap(Expression|string $value, bool $prefixAlias = false)

Wrap a value in keyword identifiers.

Parameters

Expression\|string	$value
bool	$prefixAlias

Return Value

string

string columnize(array $columns)

Convert an array of column names into a delimited string.

Parameters

array

$columns

Return Value

string

string parameterize(array $values)

Create query parameter place-holders for an array.

Parameters

array

$values

Return Value

string

string parameter(mixed $value)

Get the appropriate query parameter place-holder for a value.

Parameters

mixed

$value

Return Value

string

string getValue(Expression $expression)

Get the value of a raw expression.

Parameters

Expression

$expression

Return Value

string

bool isExpression(mixed $value)

Determine if the given value is a raw expression.

Parameters

mixed

$value

Return Value

bool

string getDateFormat()

Get the format for database stored dates.

Return Value

string

string getTablePrefix()

Get the grammar's table prefix.

Return Value

string

$this setTablePrefix(string $prefix)

Set the grammar's table prefix.

Parameters

string

$prefix

Return Value

$this

array compileRenameColumn(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a rename column command.

Parameters

Blueprint	$blueprint
Fluent	$command
Connection	$connection

Return Value

array

string compileForeign(Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

array prefixArray(string $prefix, array $values)

Add a prefix to an array of values.

Parameters

string	$prefix
array	$values

Return Value

array

array compileChange(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a change column command into a series of SQL statements.

Parameters

Blueprint	$blueprint
Fluent	$command
Connection	$connection

Return Value

array

Exceptions

RuntimeException

bool supportsSchemaTransactions()

Check if this Grammar supports schema changes wrapped in a transaction.

Return Value

bool

string compileTableExists()

Compile the query to determine if a table exists.

Return Value

string

string compileColumnExists(string $table)

Compile the query to determine the list of columns.

Parameters

string

$table

Return Value

string

string compileCreate(Blueprint $blueprint, Fluent $command)

Compile a create table command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileAdd(Blueprint $blueprint, Fluent $command)

Compile a column addition command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compilePrimary(Blueprint $blueprint, Fluent $command)

Compile a primary key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileUnique(Blueprint $blueprint, Fluent $command)

Compile a unique key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileIndex(Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDrop(Blueprint $blueprint, Fluent $command)

Compile a drop table command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropIfExists(Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropColumn(Blueprint $blueprint, Fluent $command)

Compile a drop column command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropPrimary(Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropUnique(Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropIndex(Blueprint $blueprint, Fluent $command)

Compile a drop index command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropForeign(Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileEnableForeignKeyConstraints()

Compile the command to enable foreign key constraints.

Return Value

string

string compileDisableForeignKeyConstraints()

Compile the command to disable foreign key constraints.

Return Value

string

string compileRename(Blueprint $blueprint, Fluent $command)

Compile a rename table command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.3/Illuminate/Database/Schema/Grammars/PostgresGrammar.html