Laravelで外部キー制約のあるテーブルを操作する。 ref: http://qiita.com/Asuforce/items/2c7cf0c95225083a2af5

file2.txt

$ php artisan db:seed

file3.txt

SQLSTATE[42000]: Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint

seeder_fail_sample.php

public function run()
{
    Model::unguard();

    DB::table('parents')->truncate();
    $this->call('ParentsSeeder');


    Model::reguard();
}

seeder_success_sample.php

public function run()
{
    Model::unguard();

    DB::statement('SET FOREIGN_KEY_CHECKS=0;');

    DB::table('parents')->truncate();
    $this->call('ParentsSeeder');

    DB::statement('SET FOREIGN_KEY_CHECKS=1;');

    Model::reguard();
}

table_sample.php

function run()
{
    Schema::create('parents', function (Blueprint $table) {
        $table->increments('id');
        $table->string('email', 60)->unique();
        $table->string('name', 30);
        $table->timestamps();
        $table->softDeletes();
    });
    Schema::create('children', function (Blueprint $table) {
        $table->increments('id');
        $table->string('email', 60);//FK
        $table->foreign('email')->references('email')->on('parents')->onDelete('cascade');
        $table->string('name', 30);
        $table->timestamps();
        $table->softDeletes();
    });
{