Builder
class Builder (View source)
Properties
| protected Connection | $connection | The database connection instance. |
|
| protected Grammar | $grammar | The schema grammar instance. |
|
| protected Closure | $resolver | The Blueprint resolver callback. |
|
| static int|null | $defaultStringLength | The default string length for migrations. |
|
| static string | $defaultMorphKeyType | The default relationship morph key type. |
|
| static bool | $alwaysUsesNativeSchemaOperationsIfPossible | Indicates whether Doctrine DBAL usage will be prevented if possible when dropping and renaming columns. |
Methods
Set the default string length for migrations.
Set the default morph key type for migrations.
Set the default morph key type for migrations to UUIDs.
Set the default morph key type for migrations to ULIDs.
Attempt to use native schema operations for dropping and renaming columns, even if Doctrine DBAL is installed.
Create a database in the schema.
Drop a database from the schema if the database exists.
Determine if the given table exists.
Determine if the given table has a given column.
Determine if the given table has given columns.
Execute a table builder callback if the given table has a given column.
Execute a table builder callback if the given table doesn't have a given column.
Get the data type for the given column name.
Get the column listing for a given table.
Drop a table from the schema.
Drop a table from the schema if it exists.
Drop columns from a table schema.
Drop all tables from the database.
Drop all views from the database.
Drop all types from the database.
Get all of the table names for the database.
Rename a table on the schema.
Enable foreign key constraints.
Disable foreign key constraints.
Disable foreign key constraints during the execution of a callback.
Create a new command set with a Closure.
Get the database connection instance.
Details
void
__construct(Connection $connection)
Create a new database Schema manager.
static void
defaultStringLength(int $length)
Set the default string length for migrations.
static void
defaultMorphKeyType(string $type)
Set the default morph key type for migrations.
static void
morphUsingUuids()
Set the default morph key type for migrations to UUIDs.
static void
morphUsingUlids()
Set the default morph key type for migrations to ULIDs.
static void
useNativeSchemaOperationsIfPossible(bool $value = true)
Attempt to use native schema operations for dropping and renaming columns, even if Doctrine DBAL is installed.
bool
createDatabase(string $name)
Create a database in the schema.
bool
dropDatabaseIfExists(string $name)
Drop a database from the schema if the database exists.
bool
hasTable(string $table)
Determine if the given table exists.
bool
hasColumn(string $table, string $column)
Determine if the given table has a given column.
bool
hasColumns(string $table, array $columns)
Determine if the given table has given columns.
void
whenTableHasColumn(string $table, string $column, Closure $callback)
Execute a table builder callback if the given table has a given column.
void
whenTableDoesntHaveColumn(string $table, string $column, Closure $callback)
Execute a table builder callback if the given table doesn't have a given column.
string
getColumnType(string $table, string $column)
Get the data type for the given column name.
array
getColumnListing(string $table)
Get the column listing for a given table.
void
table(string $table, Closure $callback)
Modify a table on the schema.
void
create(string $table, Closure $callback)
Create a new table on the schema.
void
drop(string $table)
Drop a table from the schema.
void
dropIfExists(string $table)
Drop a table from the schema if it exists.
void
dropColumns(string $table, string|array $columns)
Drop columns from a table schema.
void
dropAllTables()
Drop all tables from the database.
void
dropAllViews()
Drop all views from the database.
void
dropAllTypes()
Drop all types from the database.
void
getAllTables()
Get all of the table names for the database.
void
rename(string $from, string $to)
Rename a table on the schema.
bool
enableForeignKeyConstraints()
Enable foreign key constraints.
bool
disableForeignKeyConstraints()
Disable foreign key constraints.
mixed
withoutForeignKeyConstraints(Closure $callback)
Disable foreign key constraints during the execution of a callback.
protected void
build(Blueprint $blueprint)
Execute the blueprint to build / modify the table.
protected Blueprint
createBlueprint(string $table, Closure|null $callback = null)
Create a new command set with a Closure.
Connection
getConnection()
Get the database connection instance.
$this
setConnection(Connection $connection)
Set the database connection instance.
void
blueprintResolver(Closure $resolver)
Set the Schema Blueprint resolver callback.