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 |
Methods
Set the default string length for migrations.
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 all tables from the database.
Get all of the table 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.
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
dropAllTables()
Drop all tables from 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.
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.
protected array
getAllTables()
Get all of the table names for the database.