1. class
  2. Illuminate
  3. \
  4. Database
  5. \
  6. Schema
  7. \
  8. MySqlBuilder

MySqlBuilder

class MySqlBuilder extends Builder (View source)

Traits

Macroable

Properties

static protected array $macros

The registered string macros.

 from  Macroable
protected Connection $connection

The database connection instance.

 from  Builder
protected Grammar $grammar

The schema grammar instance.

 from  Builder
protected Closure $resolver

The Blueprint resolver callback.

 from  Builder
static int|null $defaultStringLength

The default string length for migrations.

 from  Builder
static $defaultTimePrecision

The default time precision for migrations.

 from  Builder
static string $defaultMorphKeyType

The default relationship morph key type.

 from  Builder

Methods

static void
macro(string $name, object|callable $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)

Checks 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 database Schema manager.

from  Builder
static void
defaultStringLength(int $length)

Set the default string length for migrations.

from  Builder
static void
defaultTimePrecision(int|null $precision)

Set the default time precision for migrations.

from  Builder
static void
defaultMorphKeyType(string $type)

Set the default morph key type for migrations.

from  Builder
static void
morphUsingUuids()

Set the default morph key type for migrations to UUIDs.

from  Builder
static void
morphUsingUlids()

Set the default morph key type for migrations to ULIDs.

from  Builder
bool
createDatabase(string $name)

Create a database in the schema.

from  Builder
bool
dropDatabaseIfExists(string $name)

Drop a database from the schema if the database exists.

from  Builder
array
getSchemas()

Get the schemas that belong to the connection.

from  Builder
bool
hasTable(string $table)

Determine if the given table exists.

from  Builder
bool
hasView(string $view)

Determine if the given view exists.

from  Builder
array
getTables(string|string[]|null $schema = null)

Get the tables that belong to the connection.

from  Builder
array
getTableListing(string|string[]|null $schema = null, bool $schemaQualified = true)

Get the names of the tables that belong to the connection.

from  Builder
array
getViews(string|string[]|null $schema = null)

Get the views that belong to the connection.

from  Builder
array
getTypes(string|string[]|null $schema = null)

Get the user-defined types that belong to the connection.

from  Builder
bool
hasColumn(string $table, string $column)

Determine if the given table has a given column.

from  Builder
bool
hasColumns(string $table, array $columns)

Determine if the given table has given columns.

from  Builder
void
whenTableHasColumn(string $table, string $column, Closure $callback)

Execute a table builder callback if the given table has a given column.

from  Builder
void
whenTableDoesntHaveColumn(string $table, string $column, Closure $callback)

Execute a table builder callback if the given table doesn't have a given column.

from  Builder
string
getColumnType(string $table, string $column, bool $fullDefinition = false)

Get the data type for the given column name.

from  Builder
array
getColumnListing(string $table)

Get the column listing for a given table.

from  Builder
array
getColumns(string $table)

Get the columns for a given table.

from  Builder
array
getIndexes(string $table)

Get the indexes for a given table.

from  Builder
array
getIndexListing(string $table)

Get the names of the indexes for a given table.

from  Builder
bool
hasIndex(string $table, string|array $index, string|null $type = null)

Determine if the given table has a given index.

from  Builder
array
getForeignKeys(string $table)

Get the foreign keys for a given table.

from  Builder
void
table(string $table, Closure $callback)

Modify a table on the schema.

from  Builder
void
create(string $table, Closure $callback)

Create a new table on the schema.

from  Builder
void
drop(string $table)

Drop a table from the schema.

from  Builder
void
dropIfExists(string $table)

Drop a table from the schema if it exists.

from  Builder
void
dropColumns(string $table, string|array $columns)

Drop columns from a table schema.

from  Builder
void
dropAllTables()

Drop all tables from the database.

void
dropAllViews()

Drop all views from the database.

void
dropAllTypes()

Drop all types from the database.

from  Builder
void
rename(string $from, string $to)

Rename a table on the schema.

from  Builder
bool
enableForeignKeyConstraints()

Enable foreign key constraints.

from  Builder
bool
disableForeignKeyConstraints()

Disable foreign key constraints.

from  Builder
mixed
withoutForeignKeyConstraints(Closure $callback)

Disable foreign key constraints during the execution of a callback.

from  Builder
void
build(Blueprint $blueprint)

Execute the blueprint to build / modify the table.

from  Builder
Blueprint
createBlueprint(string $table, Closure|null $callback = null)

Create a new command set with a Closure.

from  Builder
string[]|null
getCurrentSchemaListing()

Get the names of current schemas for the connection.

string|null
getCurrentSchemaName()

Get the default schema name for the connection.

from  Builder
array
parseSchemaAndTable(string $reference, string|bool|null $withDefaultSchema = null)

Parse the given database object reference and extract the schema and table.

from  Builder
Connection
getConnection()

Get the database connection instance.

from  Builder
void
blueprintResolver(Closure $resolver)

Set the Schema Blueprint resolver callback.

from  Builder

Details

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

Register a custom macro.

Parameters

string $name
object|callable $macro

Return Value

void

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

Mix another object into the class.

Parameters

object $mixin
bool $replace

Return Value

void

Exceptions

ReflectionException

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

Checks if macro is registered.

Parameters

string $name

Return Value

bool

in Macroable at line 72
static void flushMacros()

Flush the existing macros.

Return Value

void

in Macroable at line 86
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 112
mixed __call(string $method, array $parameters)

Dynamically handle calls to the class.

Parameters

string $method
array $parameters

Return Value

mixed

Exceptions

BadMethodCallException

in Builder at line 61
__construct(Connection $connection)

Create a new database Schema manager.

Parameters

Connection $connection

in Builder at line 73
static void defaultStringLength(int $length)

Set the default string length for migrations.

Parameters

int $length

Return Value

void

in Builder at line 81
static void defaultTimePrecision(int|null $precision)

Set the default time precision for migrations.

Parameters

int|null $precision

Return Value

void

in Builder at line 94
static void defaultMorphKeyType(string $type)

Set the default morph key type for migrations.

Parameters

string $type

Return Value

void

Exceptions

InvalidArgumentException

in Builder at line 108
static void morphUsingUuids()

Set the default morph key type for migrations to UUIDs.

Return Value

void

in Builder at line 118
static void morphUsingUlids()

Set the default morph key type for migrations to ULIDs.

Return Value

void

in Builder at line 129
bool createDatabase(string $name)

Create a database in the schema.

Parameters

string $name

Return Value

bool

in Builder at line 142
bool dropDatabaseIfExists(string $name)

Drop a database from the schema if the database exists.

Parameters

string $name

Return Value

bool

in Builder at line 154
array getSchemas()

Get the schemas that belong to the connection.

Return Value

array

in Builder at line 167
bool hasTable(string $table)

Determine if the given table exists.

Parameters

string $table

Return Value

bool

in Builder at line 192
bool hasView(string $view)

Determine if the given view exists.

Parameters

string $view

Return Value

bool

in Builder at line 213
array getTables(string|string[]|null $schema = null)

Get the tables that belong to the connection.

Parameters

string|string[]|null $schema

Return Value

array

in Builder at line 227
array getTableListing(string|string[]|null $schema = null, bool $schemaQualified = true)

Get the names of the tables that belong to the connection.

Parameters

string|string[]|null $schema
bool $schemaQualified

Return Value

array

in Builder at line 241
array getViews(string|string[]|null $schema = null)

Get the views that belong to the connection.

Parameters

string|string[]|null $schema

Return Value

array

in Builder at line 254
array getTypes(string|string[]|null $schema = null)

Get the user-defined types that belong to the connection.

Parameters

string|string[]|null $schema

Return Value

array

in Builder at line 268
bool hasColumn(string $table, string $column)

Determine if the given table has a given column.

Parameters

string $table
string $column

Return Value

bool

in Builder at line 282
bool hasColumns(string $table, array $columns)

Determine if the given table has given columns.

Parameters

string $table
array $columns

Return Value

bool

in Builder at line 303
void whenTableHasColumn(string $table, string $column, Closure $callback)

Execute a table builder callback if the given table has a given column.

Parameters

string $table
string $column
Closure $callback

Return Value

void

in Builder at line 318
void whenTableDoesntHaveColumn(string $table, string $column, Closure $callback)

Execute a table builder callback if the given table doesn't have a given column.

Parameters

string $table
string $column
Closure $callback

Return Value

void

in Builder at line 333
string getColumnType(string $table, string $column, bool $fullDefinition = false)

Get the data type for the given column name.

Parameters

string $table
string $column
bool $fullDefinition

Return Value

string

in Builder at line 352
array getColumnListing(string $table)

Get the column listing for a given table.

Parameters

string $table

Return Value

array

in Builder at line 363
array getColumns(string $table)

Get the columns for a given table.

Parameters

string $table

Return Value

array

in Builder at line 382
array getIndexes(string $table)

Get the indexes for a given table.

Parameters

string $table

Return Value

array

in Builder at line 401
array getIndexListing(string $table)

Get the names of the indexes for a given table.

Parameters

string $table

Return Value

array

in Builder at line 414
bool hasIndex(string $table, string|array $index, string|null $type = null)

Determine if the given table has a given index.

Parameters

string $table
string|array $index
string|null $type

Return Value

bool

in Builder at line 438
array getForeignKeys(string $table)

Get the foreign keys for a given table.

Parameters

string $table

Return Value

array

in Builder at line 458
void table(string $table, Closure $callback)

Modify a table on the schema.

Parameters

string $table
Closure $callback

Return Value

void

in Builder at line 470
void create(string $table, Closure $callback)

Create a new table on the schema.

Parameters

string $table
Closure $callback

Return Value

void

in Builder at line 485
void drop(string $table)

Drop a table from the schema.

Parameters

string $table

Return Value

void

in Builder at line 498
void dropIfExists(string $table)

Drop a table from the schema if it exists.

Parameters

string $table

Return Value

void

in Builder at line 512
void dropColumns(string $table, string|array $columns)

Drop columns from a table schema.

Parameters

string $table
string|array $columns

Return Value

void

at line 12
void dropAllTables()

Drop all tables from the database.

Return Value

void

at line 36
void dropAllViews()

Drop all views from the database.

Return Value

void

in Builder at line 550
void dropAllTypes()

Drop all types from the database.

Return Value

void

Exceptions

LogicException

in Builder at line 562
void rename(string $from, string $to)

Rename a table on the schema.

Parameters

string $from
string $to

Return Value

void

in Builder at line 574
bool enableForeignKeyConstraints()

Enable foreign key constraints.

Return Value

bool

in Builder at line 586
bool disableForeignKeyConstraints()

Disable foreign key constraints.

Return Value

bool

in Builder at line 599
mixed withoutForeignKeyConstraints(Closure $callback)

Disable foreign key constraints during the execution of a callback.

Parameters

Closure $callback

Return Value

mixed

in Builder at line 616
protected void build(Blueprint $blueprint)

Execute the blueprint to build / modify the table.

Parameters

Blueprint $blueprint

Return Value

void

in Builder at line 628
protected Blueprint createBlueprint(string $table, Closure|null $callback = null)

Create a new command set with a Closure.

Parameters

string $table
Closure|null $callback

Return Value

Blueprint

at line 54
string[]|null getCurrentSchemaListing()

Get the names of current schemas for the connection.

Return Value

string[]|null

in Builder at line 654
string|null getCurrentSchemaName()

Get the default schema name for the connection.

Return Value

string|null

in Builder at line 666
array parseSchemaAndTable(string $reference, string|bool|null $withDefaultSchema = null)

Parse the given database object reference and extract the schema and table.

Parameters

string $reference
string|bool|null $withDefaultSchema

Return Value

array

in Builder at line 693
Connection getConnection()

Get the database connection instance.

Return Value

Connection

in Builder at line 704
void blueprintResolver(Closure $resolver)

Set the Schema Blueprint resolver callback.

Parameters

Closure $resolver

Return Value

void