Level 51
You can set default values for your table fields, such as:
$table->string('level')->default('novice');
But, I think what you're really looking for is database seeding:
Dec 21, 2017
2
Level 1
Create table migration with inserted data
Hello,
I would like to know if it's possible to create a database and also directly add content to that database? I have this to create my database:
class CreateIssueTypesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('issue_types', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('level');
$table->string('description');
$table->string('category');
$table->string('extendedComment');
$table->timestamps();
});
}
What I want is to run "php artisan migrate" and that the table IssueTypes is created with default values like id=1 name=test1...,id=2 name=test2...,... .
If it's possible where and how should I write the code for that?
Thank you.
Level 1
I just had to add like this:
class CreateIssueTypesTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('issue_types', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('level');
$table->string('description');
$table->string('category');
$table->string('extendedComment');
$table->timestamps();
});
// Insert
DB::table('issue_types')->insert(
array(
'id' => 1,
'name' => 'aaa',
'level' => 'bbb',
'description' => 'ccc',
'category' => 'ddd',
'extendedComment' => 'eee'
)
);
Please or to participate in this conversation.