MySqlBuilder
class MySqlBuilder extends Builder (View source)
Properties
| 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 | $defaultStringLength | The default string length for migrations. |
from Builder |
| static string | $defaultMorphKeyType | The default relationship morph key type. |
from Builder |
Methods
Set the default string length for migrations.
Set the default morph key type for migrations.
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.
Get the data type for the given column name.
Get the column listing for a given table.
Drop columns from a table schema.
Drop all tables from the database.
Drop all views from the database.
Get all of the table names for the database.
Register a custom Doctrine mapping type.
Get all of the view names for the database.
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.
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.
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.
protected void
build(Blueprint $blueprint)
Execute the blueprint to build / modify the table.
protected Blueprint
createBlueprint(string $table, Closure $callback = null)
Create a new command set with a Closure.
void
registerCustomDoctrineType(string $class, string $name, string $type)
Register a custom Doctrine mapping type.
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.
array
getAllViews()
Get all of the view names for the database.