1. class
  2. Hypervel
  3. \
  4. Database
  5. \
  6. Schema
  7. \
  8. Grammars
  9. \
  10. MariaDbGrammar

MariaDbGrammar

class MariaDbGrammar extends MySqlGrammar

Traits

CompilesJsonPaths
Macroable

Properties

static protected array $macros

The registered string macros.

 from  Macroable
MySqlConnection $connection from  MySqlGrammar
protected string[] $modifiers

The possible column modifiers.

 from  MySqlGrammar
protected bool $transactions

If this Grammar supports schema changes wrapped in a transaction.

 from  Grammar
protected string[] $fluentCommands

The commands to be executed outside of create or alter commands.

 from  MySqlGrammar
protected string[] $serials

The possible column serials.

 from  MySqlGrammar

Methods

static void
macro(string $name, callable|object $macro)

Register a custom macro.

from  Macroable
static void
mixin(object $mixin, bool $replace = true)

Mix another object into the class.

from  Macroable
static bool
hasMacro(string $name)

Check if macro is registered.

from  Macroable
static void
flushMacros()

Flush the existing macros.

from  Macroable
static mixed
__callStatic(string $method, array $parameters)

Dynamically handle calls to the class.

from  Macroable
mixed
__call(string $method, array $parameters)

Dynamically handle calls to the class.

from  Macroable
__construct(Connection $connection)

Create a new grammar instance.

from  Grammar
array
wrapArray(array $values)

Wrap an array of values.

from  Grammar
string
wrapTable(Expression|string $table, string|null $prefix = null)

Wrap a table in keyword identifiers.

from  Grammar
string
wrapIdentifier(string $value)

Wrap a single identifier in keyword identifiers.

from  Grammar
string|int|float
wrap(Expression|string $value)

Wrap a value in keyword identifiers.

from  Grammar
string
wrapAliasedValue(string $value)

Wrap a value that has an alias.

from  Grammar
string
wrapAliasedTable(string $value, string|null $prefix = null)

Wrap a table that has an alias.

from  Grammar
string
wrapSegments(array $segments)

Wrap the given value segments.

from  Grammar
string
wrapValue(string $value)

Wrap a single string in keyword identifiers.

from  MySqlGrammar
string
wrapJsonSelector(string $value)

Wrap the given JSON selector.

bool
isJsonSelector(string $value)

Determine if the given string is a JSON selector.

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|int|float
parameter(mixed $value)

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

from  Grammar
string
quoteString(string|array $value)

Quote the given string literal.

from  MySqlGrammar
string
escape(string|float|int|bool|null $value, bool $binary = false)

Escape a value for safe SQL embedding.

from  Grammar
bool
isExpression(mixed $value)

Determine if the given value is a raw expression.

from  Grammar
string|int|float
getValue(Expression|string|int|float $expression)

Transforms expressions to their scalar types.

from  Grammar
string
getDateFormat()

Get the format for database stored dates.

from  Grammar
static void
flushState()

Flush all static state.

from  Grammar
array
wrapJsonFieldAndPath(string $column)

Split the given JSON selector into the field and the optional path and wrap them separately.

from  CompilesJsonPaths
string
wrapJsonPath(string $value, string $delimiter = '->')

Wrap the given JSON path.

from  CompilesJsonPaths
string
wrapJsonPathSegment(string $segment)

Wrap the given JSON path segment.

from  CompilesJsonPaths
string
compileCreateDatabase(string $name)

Compile a create database command.

from  MySqlGrammar
string
compileDropDatabaseIfExists(string $name)

Compile a drop database if exists command.

from  Grammar
string
compileSchemas()

Compile the query to determine the schemas.

from  MySqlGrammar
string|null
compileTableExists(string|null $schema, string $table)

Compile the query to determine if the given table exists.

from  MySqlGrammar
string
compileTables(string|array|null $schema)

Compile the query to determine the tables.

from  MySqlGrammar
string
compileViews(string|array|null $schema)

Compile the query to determine the views.

from  MySqlGrammar
string
compileTypes(string|array|null $schema)

Compile the query to determine the user-defined types.

from  Grammar
string
compileColumns(string|null $schema, string $table)

Compile the query to determine the columns.

from  MySqlGrammar
string
compileIndexes(string|null $schema, string $table)

Compile the query to determine the indexes.

from  MySqlGrammar
string
compileVectorIndex(Blueprint $blueprint, Fluent $command)

Compile a vector index key command.

string
compileDropVectorIndex(Blueprint $blueprint, Fluent $command)

Compile a drop vector index command.

string
compileForeignKeys(string|null $schema, string $table)

Compile the query to determine the foreign keys.

from  MySqlGrammar
string
compileEnableForeignKeyConstraints()

Compile the command to enable foreign key constraints.

from  MySqlGrammar
string
compileDisableForeignKeyConstraints()

Compile the command to disable foreign key constraints.

from  MySqlGrammar
array|string
compileRenameColumn(Blueprint $blueprint, Fluent $command)

Compile a rename column command.

array|string
compileChange(Blueprint $blueprint, Fluent $command)

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

from  MySqlGrammar
string
compileFulltext(Blueprint $blueprint, Fluent $command)

Compile a fulltext index key command.

from  Grammar
string
compileDropFullText(Blueprint $blueprint, Fluent $command)

Compile a drop fulltext index command.

from  MySqlGrammar
string|null
compileForeign(Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

from  MySqlGrammar
array|string|null
compileDropForeign(Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

from  MySqlGrammar
array
getColumns(Blueprint $blueprint)

Compile the blueprint's added column definitions.

from  Grammar
string
getColumn(Blueprint $blueprint, Fluent $column)

Compile the column definition.

from  Grammar
string
getType(Fluent $column)

Get the SQL for the column data type.

from  Grammar
string
typeVector(Fluent $column)

Create the column definition for a vector type.

from  MySqlGrammar
string
typeTsvector(Fluent $column)

Create the column definition for a tsvector type.

from  Grammar
string
typeRaw(Fluent $column)

Create the column definition for a raw column type.

from  Grammar
string
addModifiers(string $sql, Blueprint $blueprint, Fluent $column)

Add the column modifiers to the definition.

from  Grammar
string
compileWhereNotNull(Fluent $command)

Compile the not-null predicate for a sparse index.

from  Grammar
Fluent|null
getCommandByName(Blueprint $blueprint, string $name)

Get the command with a given name if it exists on the blueprint.

from  Grammar
array
getCommandsByName(Blueprint $blueprint, string $name)

Get all of the commands with a given name.

from  Grammar
bool
hasCommand(Blueprint $blueprint, string $name)

Determine if a command with a given name exists on the blueprint.

from  Grammar
array
prefixArray(string $prefix, array $values)

Add a prefix to an array of values.

from  Grammar
string|int|float
getDefaultValue(mixed $value)

Format a value so that it can be used in "default" clauses.

from  Grammar
array
getFluentCommands()

Get the fluent commands for the grammar.

from  Grammar
bool
supportsSchemaTransactions()

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

from  Grammar
string
compileSchemaWhereClause(string|array|null $schema, string $column)

Compile the query to compare the schema.

from  MySqlGrammar
string
compileCreate(Blueprint $blueprint, Fluent $command)

Compile a create table command.

from  MySqlGrammar
string
compileCreateTable(Blueprint $blueprint, Fluent $command)

Create the main create table clause.

from  MySqlGrammar
string
compileCreateEncoding(string $sql, Blueprint $blueprint)

Append the character set specifications to a command.

from  MySqlGrammar
string
compileCreateEngine(string $sql, Blueprint $blueprint)

Append the engine specifications to a command.

from  MySqlGrammar
string
compileAdd(Blueprint $blueprint, Fluent $command)

Compile an add column command.

from  MySqlGrammar
string|null
compileAutoIncrementStartingValues(Blueprint $blueprint, Fluent $command)

Compile the auto-incrementing column starting values.

from  MySqlGrammar
string
compileLegacyRenameColumn(Blueprint $blueprint, Fluent $command)

Compile a rename column command for legacy versions of MySQL.

from  MySqlGrammar
string
compilePrimary(Blueprint $blueprint, Fluent $command)

Compile a primary key command.

from  MySqlGrammar
string
compileUnique(Blueprint $blueprint, Fluent $command)

Compile a unique key command.

from  MySqlGrammar
string
compileIndex(Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

from  MySqlGrammar
string
compileFullText(Blueprint $blueprint, Fluent $command)

Compile a fulltext index key command.

from  MySqlGrammar
string
compileSpatialIndex(Blueprint $blueprint, Fluent $command)

Compile a spatial index key command.

from  MySqlGrammar
string
compileKey(Blueprint $blueprint, Fluent $command, string $type)

Compile an index creation command.

from  MySqlGrammar
string
compileDrop(Blueprint $blueprint, Fluent $command)

Compile a drop table command.

from  MySqlGrammar
string
compileDropIfExists(Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

from  MySqlGrammar
string
compileDropColumn(Blueprint $blueprint, Fluent $command)

Compile a drop column command.

from  MySqlGrammar
string
compileDropPrimary(Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

from  MySqlGrammar
string
compileDropUnique(Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

from  MySqlGrammar
string
compileDropIndex(Blueprint $blueprint, Fluent $command)

Compile a drop index command.

from  MySqlGrammar
string
compileDropSpatialIndex(Blueprint $blueprint, Fluent $command)

Compile a drop spatial index command.

from  MySqlGrammar
string
compileRename(Blueprint $blueprint, Fluent $command)

Compile a rename table command.

from  MySqlGrammar
string
compileRenameIndex(Blueprint $blueprint, Fluent $command)

Compile a rename index command.

from  MySqlGrammar
string
compileDropAllTables(array $tables)

Compile the SQL needed to drop all tables.

from  MySqlGrammar
string
compileDropAllViews(array $views)

Compile the SQL needed to drop all views.

from  MySqlGrammar
string
compileTableComment(Blueprint $blueprint, Fluent $command)

Compile a table comment command.

from  MySqlGrammar
array
escapeNames(array $names)

Quote-escape the given tables, views, or types.

from  MySqlGrammar
string
typeChar(Fluent $column)

Create the column definition for a char type.

from  MySqlGrammar
string
typeString(Fluent $column)

Create the column definition for a string type.

from  MySqlGrammar
string
typeTinyText(Fluent $column)

Create the column definition for a tiny text type.

from  MySqlGrammar
string
typeText(Fluent $column)

Create the column definition for a text type.

from  MySqlGrammar
string
typeMediumText(Fluent $column)

Create the column definition for a medium text type.

from  MySqlGrammar
string
typeLongText(Fluent $column)

Create the column definition for a long text type.

from  MySqlGrammar
string
typeBigInteger(Fluent $column)

Create the column definition for a big integer type.

from  MySqlGrammar
string
typeInteger(Fluent $column)

Create the column definition for an integer type.

from  MySqlGrammar
string
typeMediumInteger(Fluent $column)

Create the column definition for a medium integer type.

from  MySqlGrammar
string
typeTinyInteger(Fluent $column)

Create the column definition for a tiny integer type.

from  MySqlGrammar
string
typeSmallInteger(Fluent $column)

Create the column definition for a small integer type.

from  MySqlGrammar
string
typeFloat(Fluent $column)

Create the column definition for a float type.

from  MySqlGrammar
string
typeDouble(Fluent $column)

Create the column definition for a double type.

from  MySqlGrammar
string
typeDecimal(Fluent $column)

Create the column definition for a decimal type.

from  MySqlGrammar
string
typeBoolean(Fluent $column)

Create the column definition for a boolean type.

from  MySqlGrammar
string
typeEnum(Fluent $column)

Create the column definition for an enumeration type.

from  MySqlGrammar
string
typeSet(Fluent $column)

Create the column definition for a set enumeration type.

from  MySqlGrammar
string
typeJson(Fluent $column)

Create the column definition for a json type.

from  MySqlGrammar
string
typeJsonb(Fluent $column)

Create the column definition for a jsonb type.

from  MySqlGrammar
string
typeDate(Fluent $column)

Create the column definition for a date type.

from  MySqlGrammar
string
typeDateTime(Fluent $column)

Create the column definition for a date-time type.

from  MySqlGrammar
string
typeDateTimeTz(Fluent $column)

Create the column definition for a date-time (with time zone) type.

from  MySqlGrammar
string
typeTime(Fluent $column)

Create the column definition for a time type.

from  MySqlGrammar
string
typeTimeTz(Fluent $column)

Create the column definition for a time (with time zone) type.

from  MySqlGrammar
string
typeTimestamp(Fluent $column)

Create the column definition for a timestamp type.

from  MySqlGrammar
string
typeTimestampTz(Fluent $column)

Create the column definition for a timestamp (with time zone) type.

from  MySqlGrammar
string
typeYear(Fluent $column)

Create the column definition for a year type.

from  MySqlGrammar
string
typeBinary(Fluent $column)

Create the column definition for a binary type.

from  MySqlGrammar
string
typeUuid(Fluent $column)

Create the column definition for a uuid type.

string
typeIpAddress(Fluent $column)

Create the column definition for an IP address type.

from  MySqlGrammar
string
typeMacAddress(Fluent $column)

Create the column definition for a MAC address type.

from  MySqlGrammar
string
typeGeometry(Fluent $column)

Create the column definition for a spatial Geometry type.

string
typeGeography(Fluent $column)

Create the column definition for a spatial Geography type.

from  MySqlGrammar
string|null
modifyVirtualAs(Blueprint $blueprint, Fluent $column)

Get the SQL for a generated virtual column modifier.

from  MySqlGrammar
string|null
modifyStoredAs(Blueprint $blueprint, Fluent $column)

Get the SQL for a generated stored column modifier.

from  MySqlGrammar
string|null
modifyUnsigned(Blueprint $blueprint, Fluent $column)

Get the SQL for an unsigned column modifier.

from  MySqlGrammar
string|null
modifyCharset(Blueprint $blueprint, Fluent $column)

Get the SQL for a character set column modifier.

from  MySqlGrammar
string|null
modifyCollate(Blueprint $blueprint, Fluent $column)

Get the SQL for a collation column modifier.

from  MySqlGrammar
string|null
modifyNullable(Blueprint $blueprint, Fluent $column)

Get the SQL for a nullable column modifier.

from  MySqlGrammar
string|null
modifyInvisible(Blueprint $blueprint, Fluent $column)

Get the SQL for an invisible column modifier.

from  MySqlGrammar
string|null
modifyDefault(Blueprint $blueprint, Fluent $column)

Get the SQL for a default column modifier.

from  MySqlGrammar
string|null
modifyOnUpdate(Blueprint $blueprint, Fluent $column)

Get the SQL for an "on update" column modifier.

from  MySqlGrammar
string|null
modifyIncrement(Blueprint $blueprint, Fluent $column)

Get the SQL for an auto-increment column modifier.

from  MySqlGrammar
string|null
modifyFirst(Blueprint $blueprint, Fluent $column)

Get the SQL for a "first" column modifier.

from  MySqlGrammar
string|null
modifyAfter(Blueprint $blueprint, Fluent $column)

Get the SQL for an "after" column modifier.

from  MySqlGrammar
string|null
modifyComment(Blueprint $blueprint, Fluent $column)

Get the SQL for a "comment" column modifier.

from  MySqlGrammar

Details

in Macroable at line 28
static void macro(string $name, callable|object $macro)

Register a custom macro.

Boot-only. Macros persist in a static property for the worker lifetime and apply to every subsequent call on the macroable class.

Parameters

string $name
callable|object $macro

Return Value

void

in Macroable at line 41
static void mixin(object $mixin, bool $replace = true)

Mix another object into the class.

Boot-only. Delegates to macro() for each method; registered macros persist in a static property for the worker lifetime.

Parameters

object $mixin
bool $replace

Return Value

void

Exceptions

ReflectionException

in Macroable at line 57
static bool hasMacro(string $name)

Check if macro is registered.

Parameters

string $name

Return Value

bool

in Macroable at line 68
static void flushMacros()

Flush the existing macros.

Boot or tests only. Clears worker-wide macros; concurrent coroutines may resolve different methods depending on timing.

Return Value

void

in Macroable at line 78
static mixed __callStatic(string $method, array $parameters)

Dynamically handle calls to the class.

Parameters

string $method
array $parameters

Return Value

mixed

Exceptions

BadMethodCallException

in Macroable at line 103
mixed __call(string $method, array $parameters)

Dynamically handle calls to the class.

Parameters

string $method
array $parameters

Return Value

mixed

Exceptions

BadMethodCallException

in Grammar at line 24
__construct(Connection $connection)

Create a new grammar instance.

Parameters

Connection $connection

in Grammar at line 35
array wrapArray(array $values)

Wrap an array of values.

Parameters

array $values

Return Value

array

in Grammar at line 404
string wrapTable(Expression|string $table, string|null $prefix = null)

Wrap a table in keyword identifiers.

Parameters

Expression|string $table
string|null $prefix

Return Value

string

in Grammar at line 76
string wrapIdentifier(string $value)

Wrap a single identifier in keyword identifiers.

Parameters

string $value

Return Value

string

in Grammar at line 415
string|int|float wrap(Expression|string $value)

Wrap a value in keyword identifiers.

Parameters

Expression|string $value

Return Value

string|int|float

in Grammar at line 110
protected string wrapAliasedValue(string $value)

Wrap a value that has an alias.

Parameters

string $value

Return Value

string

in Grammar at line 120
protected string wrapAliasedTable(string $value, string|null $prefix = null)

Wrap a table that has an alias.

Parameters

string $value
string|null $prefix

Return Value

string

in Grammar at line 134
protected string wrapSegments(array $segments)

Wrap the given value segments.

Parameters

array $segments

Return Value

string

in MySqlGrammar at line 1157
protected string wrapValue(string $value)

Wrap a single string in keyword identifiers.

Parameters

string $value

Return Value

string

at line 80
protected string wrapJsonSelector(string $value)

Wrap the given JSON selector.

Parameters

string $value

Return Value

string

in Grammar at line 168
protected bool isJsonSelector(string $value)

Determine if the given string is a JSON selector.

Parameters

string $value

Return Value

bool

in Grammar at line 178
string columnize(array $columns)

Convert an array of column names into a delimited string.

Parameters

array $columns

Return Value

string

in Grammar at line 186
string parameterize(array $values)

Create query parameter place-holders for an array.

Parameters

array $values

Return Value

string

in Grammar at line 194
string|int|float parameter(mixed $value)

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

Parameters

mixed $value

Return Value

string|int|float

in MySqlGrammar at line 1143
string quoteString(string|array $value)

Quote the given string literal.

Parameters

string|array $value

Return Value

string

in Grammar at line 216
string escape(string|float|int|bool|null $value, bool $binary = false)

Escape a value for safe SQL embedding.

Parameters

string|float|int|bool|null $value
bool $binary

Return Value

string

in Grammar at line 224
bool isExpression(mixed $value)

Determine if the given value is a raw expression.

Parameters

mixed $value

Return Value

bool

in Grammar at line 232
string|int|float getValue(Expression|string|int|float $expression)

Transforms expressions to their scalar types.

Parameters

Expression|string|int|float $expression

Return Value

string|int|float

in Grammar at line 244
string getDateFormat()

Get the format for database stored dates.

Return Value

string

in Grammar at line 255
static void flushState()

Flush all static state.

Return Value

void

in CompilesJsonPaths at line 15
protected array wrapJsonFieldAndPath(string $column)

Split the given JSON selector into the field and the optional path and wrap them separately.

Parameters

string $column

Return Value

array

in CompilesJsonPaths at line 29
protected string wrapJsonPath(string $value, string $delimiter = '->')

Wrap the given JSON path.

Parameters

string $value
string $delimiter

Return Value

string

in CompilesJsonPaths at line 44
protected string wrapJsonPathSegment(string $segment)

Wrap the given JSON path segment.

Parameters

string $segment

Return Value

string

in MySqlGrammar at line 48
string compileCreateDatabase(string $name)

Compile a create database command.

Parameters

string $name

Return Value

string

in Grammar at line 55
string compileDropDatabaseIfExists(string $name)

Compile a drop database if exists command.

Parameters

string $name

Return Value

string

in MySqlGrammar at line 66
string compileSchemas()

Compile the query to determine the schemas.

Return Value

string

in MySqlGrammar at line 76
string|null compileTableExists(string|null $schema, string $table)

Compile the query to determine if the given table exists.

Parameters

string|null $schema
string $table

Return Value

string|null

in MySqlGrammar at line 89
string compileTables(string|array|null $schema)

Compile the query to determine the tables.

Parameters

string|array|null $schema

Return Value

string

in MySqlGrammar at line 101
string compileViews(string|array|null $schema)

Compile the query to determine the views.

Parameters

string|array|null $schema

Return Value

string

in Grammar at line 106
string compileTypes(string|array|null $schema)

Compile the query to determine the user-defined types.

Parameters

string|array|null $schema

Return Value

string

in MySqlGrammar at line 124
string compileColumns(string|null $schema, string $table)

Compile the query to determine the columns.

Parameters

string|null $schema
string $table

Return Value

string

in MySqlGrammar at line 141
string compileIndexes(string|null $schema, string $table)

Compile the query to determine the indexes.

Parameters

string|null $schema
string $table

Return Value

string

at line 56
string compileVectorIndex(Blueprint $blueprint, Fluent $command)

Compile a vector index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

at line 72
string compileDropVectorIndex(Blueprint $blueprint, Fluent $command)

Compile a drop vector index command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 156
string compileForeignKeys(string|null $schema, string $table)

Compile the query to determine the foreign keys.

Parameters

string|null $schema
string $table

Return Value

string

in MySqlGrammar at line 583
string compileEnableForeignKeyConstraints()

Compile the command to enable foreign key constraints.

Return Value

string

in MySqlGrammar at line 592
string compileDisableForeignKeyConstraints()

Compile the command to disable foreign key constraints.

Return Value

string

at line 13
array|string compileRenameColumn(Blueprint $blueprint, Fluent $command)

Compile a rename column command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

array|string

in MySqlGrammar at line 348
array|string compileChange(Blueprint $blueprint, Fluent $command)

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

Parameters

Blueprint $blueprint
Fluent $command

Return Value

array|string

in Grammar at line 197
string compileFulltext(Blueprint $blueprint, Fluent $command)

Compile a fulltext index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 504
string compileDropFullText(Blueprint $blueprint, Fluent $command)

Compile a drop fulltext index command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 520
string|null compileForeign(Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string|null

in MySqlGrammar at line 534
array|string|null compileDropForeign(Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

array|string|null

in Grammar at line 263
protected array getColumns(Blueprint $blueprint)

Compile the blueprint's added column definitions.

Parameters

Blueprint $blueprint

Return Value

array

in Grammar at line 279
protected string getColumn(Blueprint $blueprint, Fluent $column)

Compile the column definition.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string

in Grammar at line 292
protected string getType(Fluent $column)

Get the SQL for the column data type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 950
protected string typeVector(Fluent $column)

Create the column definition for a vector type.

Parameters

Fluent $column

Return Value

string

in Grammar at line 310
protected string typeTsvector(Fluent $column)

Create the column definition for a tsvector type.

Parameters

Fluent $column

Return Value

string

in Grammar at line 318
protected string typeRaw(Fluent $column)

Create the column definition for a raw column type.

Parameters

Fluent $column

Return Value

string

in Grammar at line 326
protected string addModifiers(string $sql, Blueprint $blueprint, Fluent $column)

Add the column modifiers to the definition.

Parameters

string $sql
Blueprint $blueprint
Fluent $column

Return Value

string

in Grammar at line 340
protected string compileWhereNotNull(Fluent $command)

Compile the not-null predicate for a sparse index.

Parameters

Fluent $command

Return Value

string

in Grammar at line 351
protected Fluent|null getCommandByName(Blueprint $blueprint, string $name)

Get the command with a given name if it exists on the blueprint.

Parameters

Blueprint $blueprint
string $name

Return Value

Fluent|null

in Grammar at line 367
protected array getCommandsByName(Blueprint $blueprint, string $name)

Get all of the commands with a given name.

Parameters

Blueprint $blueprint
string $name

Return Value

array

in Grammar at line 377
protected bool hasCommand(Blueprint $blueprint, string $name)

Determine if a command with a given name exists on the blueprint.

Parameters

Blueprint $blueprint
string $name

Return Value

bool

in Grammar at line 394
array prefixArray(string $prefix, array $values)

Add a prefix to an array of values.

Parameters

string $prefix
array $values

Return Value

array

in Grammar at line 425
protected string|int|float getDefaultValue(mixed $value)

Format a value so that it can be used in "default" clauses.

Parameters

mixed $value

Return Value

string|int|float

in Grammar at line 445
array getFluentCommands()

Get the fluent commands for the grammar.

Return Value

array

in Grammar at line 453
bool supportsSchemaTransactions()

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

Return Value

bool

in MySqlGrammar at line 112
protected string compileSchemaWhereClause(string|array|null $schema, string $column)

Compile the query to compare the schema.

Parameters

string|array|null $schema
string $column

Return Value

string

in MySqlGrammar at line 178
string compileCreate(Blueprint $blueprint, Fluent $command)

Compile a create table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 202
protected string compileCreateTable(Blueprint $blueprint, Fluent $command)

Create the main create table clause.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 227
protected string compileCreateEncoding(string $sql, Blueprint $blueprint)

Append the character set specifications to a command.

Parameters

string $sql
Blueprint $blueprint

Return Value

string

in MySqlGrammar at line 253
protected string compileCreateEngine(string $sql, Blueprint $blueprint)

Append the engine specifications to a command.

Parameters

string $sql
Blueprint $blueprint

Return Value

string

in MySqlGrammar at line 268
string compileAdd(Blueprint $blueprint, Fluent $command)

Compile an add column command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 282
string|null compileAutoIncrementStartingValues(Blueprint $blueprint, Fluent $command)

Compile the auto-incrementing column starting values.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string|null

in MySqlGrammar at line 309
protected string compileLegacyRenameColumn(Blueprint $blueprint, Fluent $command)

Compile a rename column command for legacy versions of MySQL.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 378
string compilePrimary(Blueprint $blueprint, Fluent $command)

Compile a primary key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 392
string compileUnique(Blueprint $blueprint, Fluent $command)

Compile a unique key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 400
string compileIndex(Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 408
string compileFullText(Blueprint $blueprint, Fluent $command)

Compile a fulltext index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 416
string compileSpatialIndex(Blueprint $blueprint, Fluent $command)

Compile a spatial index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 424
protected string compileKey(Blueprint $blueprint, Fluent $command, string $type)

Compile an index creation command.

Parameters

Blueprint $blueprint
Fluent $command
string $type

Return Value

string

in MySqlGrammar at line 440
string compileDrop(Blueprint $blueprint, Fluent $command)

Compile a drop table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 448
string compileDropIfExists(Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 456
string compileDropColumn(Blueprint $blueprint, Fluent $command)

Compile a drop column command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 476
string compileDropPrimary(Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 484
string compileDropUnique(Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 494
string compileDropIndex(Blueprint $blueprint, Fluent $command)

Compile a drop index command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 512
string compileDropSpatialIndex(Blueprint $blueprint, Fluent $command)

Compile a drop spatial index command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 544
string compileRename(Blueprint $blueprint, Fluent $command)

Compile a rename table command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 554
string compileRenameIndex(Blueprint $blueprint, Fluent $command)

Compile a rename index command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 567
string compileDropAllTables(array $tables)

Compile the SQL needed to drop all tables.

Parameters

array $tables

Return Value

string

in MySqlGrammar at line 575
string compileDropAllViews(array $views)

Compile the SQL needed to drop all views.

Parameters

array $views

Return Value

string

in MySqlGrammar at line 601
string compileTableComment(Blueprint $blueprint, Fluent $command)

Compile a table comment command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

in MySqlGrammar at line 613
array escapeNames(array $names)

Quote-escape the given tables, views, or types.

Parameters

array $names

Return Value

array

in MySqlGrammar at line 624
protected string typeChar(Fluent $column)

Create the column definition for a char type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 632
protected string typeString(Fluent $column)

Create the column definition for a string type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 640
protected string typeTinyText(Fluent $column)

Create the column definition for a tiny text type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 648
protected string typeText(Fluent $column)

Create the column definition for a text type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 656
protected string typeMediumText(Fluent $column)

Create the column definition for a medium text type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 664
protected string typeLongText(Fluent $column)

Create the column definition for a long text type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 672
protected string typeBigInteger(Fluent $column)

Create the column definition for a big integer type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 680
protected string typeInteger(Fluent $column)

Create the column definition for an integer type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 688
protected string typeMediumInteger(Fluent $column)

Create the column definition for a medium integer type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 696
protected string typeTinyInteger(Fluent $column)

Create the column definition for a tiny integer type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 704
protected string typeSmallInteger(Fluent $column)

Create the column definition for a small integer type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 712
protected string typeFloat(Fluent $column)

Create the column definition for a float type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 724
protected string typeDouble(Fluent $column)

Create the column definition for a double type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 732
protected string typeDecimal(Fluent $column)

Create the column definition for a decimal type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 740
protected string typeBoolean(Fluent $column)

Create the column definition for a boolean type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 748
protected string typeEnum(Fluent $column)

Create the column definition for an enumeration type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 756
protected string typeSet(Fluent $column)

Create the column definition for a set enumeration type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 764
protected string typeJson(Fluent $column)

Create the column definition for a json type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 772
protected string typeJsonb(Fluent $column)

Create the column definition for a jsonb type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 780
protected string typeDate(Fluent $column)

Create the column definition for a date type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 797
protected string typeDateTime(Fluent $column)

Create the column definition for a date-time type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 815
protected string typeDateTimeTz(Fluent $column)

Create the column definition for a date-time (with time zone) type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 823
protected string typeTime(Fluent $column)

Create the column definition for a time type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 831
protected string typeTimeTz(Fluent $column)

Create the column definition for a time (with time zone) type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 839
protected string typeTimestamp(Fluent $column)

Create the column definition for a timestamp type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 857
protected string typeTimestampTz(Fluent $column)

Create the column definition for a timestamp (with time zone) type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 865
protected string typeYear(Fluent $column)

Create the column definition for a year type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 882
protected string typeBinary(Fluent $column)

Create the column definition for a binary type.

Parameters

Fluent $column

Return Value

string

at line 26
protected string typeUuid(Fluent $column)

Create the column definition for a uuid type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 902
protected string typeIpAddress(Fluent $column)

Create the column definition for an IP address type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 910
protected string typeMacAddress(Fluent $column)

Create the column definition for a MAC address type.

Parameters

Fluent $column

Return Value

string

at line 38
protected string typeGeometry(Fluent $column)

Create the column definition for a spatial Geometry type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 940
protected string typeGeography(Fluent $column)

Create the column definition for a spatial Geography type.

Parameters

Fluent $column

Return Value

string

in MySqlGrammar at line 960
protected string|null modifyVirtualAs(Blueprint $blueprint, Fluent $column)

Get the SQL for a generated virtual column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 980
protected string|null modifyStoredAs(Blueprint $blueprint, Fluent $column)

Get the SQL for a generated stored column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1000
protected string|null modifyUnsigned(Blueprint $blueprint, Fluent $column)

Get the SQL for an unsigned column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1012
protected string|null modifyCharset(Blueprint $blueprint, Fluent $column)

Get the SQL for a character set column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1024
protected string|null modifyCollate(Blueprint $blueprint, Fluent $column)

Get the SQL for a collation column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1036
protected string|null modifyNullable(Blueprint $blueprint, Fluent $column)

Get the SQL for a nullable column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1055
protected string|null modifyInvisible(Blueprint $blueprint, Fluent $column)

Get the SQL for an invisible column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1067
protected string|null modifyDefault(Blueprint $blueprint, Fluent $column)

Get the SQL for a default column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1079
protected string|null modifyOnUpdate(Blueprint $blueprint, Fluent $column)

Get the SQL for an "on update" column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1091
protected string|null modifyIncrement(Blueprint $blueprint, Fluent $column)

Get the SQL for an auto-increment column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1105
protected string|null modifyFirst(Blueprint $blueprint, Fluent $column)

Get the SQL for a "first" column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1117
protected string|null modifyAfter(Blueprint $blueprint, Fluent $column)

Get the SQL for an "after" column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

in MySqlGrammar at line 1129
protected string|null modifyComment(Blueprint $blueprint, Fluent $column)

Get the SQL for a "comment" column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null