MySqlGrammar
class MySqlGrammar extends Grammar (View source)
Properties
| protected string | $tablePrefix | The grammar table prefix. |
from Grammar |
| protected array | $modifiers | The possible column modifiers. |
|
| protected array | $serials | The possible column serials |
Methods
Wrap a single string in keyword identifiers.
Convert an array of column names into a delimited string.
Get the appropriate query parameter place-holder for a value.
Compile a rename column command.
Get a new column instance with the new column name.
Set the renamed columns on the table diff.
Add the column modifiers to the definition.
Get the primary key command if it exists on the blueprint.
Format a value so that it can be used in "default" clauses.
Create an empty Doctrine DBAL TableDiff from the Blueprint.
Compile the query to determine the list of tables.
Compile the query to determine the list of columns.
Compile a create table command.
Append the character set specifications to a command.
Compile a drop table (if exists) command.
Get the SQL for an auto-increment column modifier.
Details
array
wrapArray(array $values)
Wrap an array of values.
string
wrapTable(string $table)
Wrap a table in keyword identifiers.
string
wrap(string $value)
Wrap a value in keyword identifiers.
protected string
wrapValue(string $value)
Wrap a single string 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.
protected TableDiff
getRenamedDiff(Blueprint $blueprint, Fluent $command, Column $column, AbstractSchemaManager $schema)
Get a new column instance with the new column name.
protected TableDiff
setRenamedColumns(TableDiff $tableDiff, Fluent $command, Column $column)
Set the renamed columns on the table diff.
protected array
getColumns(Blueprint $blueprint)
Compile the blueprint's column definitions.
protected string
addModifiers(string $sql, Blueprint $blueprint, Fluent $column)
Add the column modifiers to the definition.
protected Fluent|null
getCommandByName(Blueprint $blueprint, string $name)
Get the primary key command if it exists on the blueprint.
protected array
getCommandsByName(Blueprint $blueprint, string $name)
Get all of the commands with a given name.
protected string
getType(Fluent $column)
Get the SQL for the column data type.
array
prefixArray(string $prefix, array $values)
Add a prefix to an array of values.
protected string
getDefaultValue(mixed $value)
Format a value so that it can be used in "default" clauses.
protected TableDiff
getDoctrineTableDiff(Blueprint $blueprint, AbstractSchemaManager $schema)
Create an empty Doctrine DBAL TableDiff from the Blueprint.
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.
protected string
compileCreateEncoding(string $sql, Connection $connection)
Append the character set specifications to a command.
protected string
compileKey(Blueprint $blueprint, Fluent $command, string $type)
Compile an index creation 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.
protected string
typeChar(Fluent $column)
Create the column definition for a char type.
protected string
typeString(Fluent $column)
Create the column definition for a string type.
protected string
typeText(Fluent $column)
Create the column definition for a text type.
protected string
typeMediumText(Fluent $column)
Create the column definition for a medium text type.
protected string
typeLongText(Fluent $column)
Create the column definition for a long text type.
protected string
typeBigInteger(Fluent $column)
Create the column definition for a big integer type.
protected string
typeInteger(Fluent $column)
Create the column definition for a integer type.
protected string
typeMediumInteger(Fluent $column)
Create the column definition for a medium integer type.
protected string
typeTinyInteger(Fluent $column)
Create the column definition for a tiny integer type.
protected string
typeSmallInteger(Fluent $column)
Create the column definition for a small integer type.
protected string
typeFloat(Fluent $column)
Create the column definition for a float type.
protected string
typeDouble(Fluent $column)
Create the column definition for a double type.
protected string
typeDecimal(Fluent $column)
Create the column definition for a decimal type.
protected string
typeBoolean(Fluent $column)
Create the column definition for a boolean type.
protected string
typeEnum(Fluent $column)
Create the column definition for an enum type.
protected string
typeDate(Fluent $column)
Create the column definition for a date type.
protected string
typeDateTime(Fluent $column)
Create the column definition for a date-time type.
protected string
typeTime(Fluent $column)
Create the column definition for a time type.
protected string
typeTimestamp(Fluent $column)
Create the column definition for a timestamp type.
protected string
typeBinary(Fluent $column)
Create the column definition for a binary type.
protected string|null
modifyUnsigned(Blueprint $blueprint, Fluent $column)
Get the SQL for an unsigned column modifier.
protected string|null
modifyNullable(Blueprint $blueprint, Fluent $column)
Get the SQL for a nullable column modifier.
protected string|null
modifyDefault(Blueprint $blueprint, Fluent $column)
Get the SQL for a default column modifier.
protected string|null
modifyIncrement(Blueprint $blueprint, Fluent $column)
Get the SQL for an auto-increment column modifier.
protected string|null
modifyAfter(Blueprint $blueprint, Fluent $column)
Get the SQL for an "after" column modifier.