MySqlGrammar (Database\Schema\Grammars)
MySqlGrammar
class MySqlGrammar 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 the list of tables. | |
string | compileColumnExists() Compile the query to determine the list of columns. | |
string | compileCreate(Blueprint $blueprint, Fluent $command, Connection $connection) Compile a create table command. | |
string | compileAdd(Blueprint $blueprint, Fluent $command) Compile an add column 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 | compileRename(Blueprint $blueprint, Fluent $command) Compile a rename table command. | |
string | compileEnableForeignKeyConstraints() Compile the command to enable foreign key constraints. | |
string | compileDisableForeignKeyConstraints() Compile the command to disable foreign key constraints. |
Details
array wrapArray(array $values)
Wrap an array of values.
string wrapTable(Expression|string $table)
Wrap a table in keyword identifiers.
string wrap(Expression|string $value, bool $prefixAlias = false)
Wrap a value in keyword identifiers.
string columnize(array $columns)
Convert an array of column names into a delimited string.
string parameterize(array $values)
Create query parameter place-holders for an array.
string parameter(mixed $value)
Get the appropriate query parameter place-holder for a value.
string getValue(Expression $expression)
Get the value of a raw expression.
bool isExpression(mixed $value)
Determine if the given value is a raw expression.
string getDateFormat()
Get the format for database stored dates.
string getTablePrefix()
Get the grammar's table prefix.
$this setTablePrefix(string $prefix)
Set the grammar's table prefix.
array compileRenameColumn(Blueprint $blueprint, Fluent $command, Connection $connection)
Compile a rename column command.
array prefixArray(string $prefix, array $values)
Add a prefix to an array of values.
array compileChange(Blueprint $blueprint, Fluent $command, Connection $connection)
Compile a change column command into a series of SQL statements.
bool supportsSchemaTransactions()
Check if this Grammar supports schema changes wrapped in a transaction.
string compileTableExists()
Compile the query to determine the list of tables.
string compileColumnExists()
Compile the query to determine the list of columns.
string compileCreate(Blueprint $blueprint, Fluent $command, Connection $connection)
Compile a create table command.
string compileDropIfExists(Blueprint $blueprint, Fluent $command)
Compile a drop table (if exists) command.
string compileDropPrimary(Blueprint $blueprint, Fluent $command)
Compile a drop primary key 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.
© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.3/Illuminate/Database/Schema/Grammars/MySqlGrammar.html