首页 文章

Laravel Eloquent ORM - 删除事件和所有子关系，删除事件

提问于
浏览 次
2

我有三个模型，彼此之间有一对多：

国家

class Country extends Model
{
    protected $fillable=['name','sort'];
    public $timestamps=false;

    public function region(){
        return $this->hasMany('App\Models\Region');
    }
}

地区

class Region extends Model
{

    protected $fillable=['country_id','name','sort'];
    public  $timestamps=false;

    public function country()
    {
        return $this->belongsTo('App\Models\Country');
    }

    public function city()
    {
        return $this->hasMany('App\Models\City');
    }
}

城市

class City extends Model
{
    protected $table='cities';
    protected $fillable=['region_id','name','sort'];
    public  $timestamps=false;

    public function region()
    {
        return $this->belongsTo('App\Models\Region');
    }
}

当我们自动删除国家/地区时，删除所有子项目关系，即删除该区域和城市

我这样做：

型号国家

public  static function boot() {
        parent::boot();

        static::deleting(function($country) {
            //remove related rows region and city

            // need an alternative variation of this code
            $country->region()->city()->delete();//not working
            $country->region()->delete();

            return true;
        });
    }
}

或

模型区域

public  static function boot() {
        parent::boot();
        // this event do not working, when delete a parent(country)
        static::deleting(function($region) {
            dd($region);
            //remove related rows city
            $region->city()->delete();
            return true;
        });
    }
}

options with cascading deletes database, please do not offer

更新

I found the answer

使用闭包查询构建器，删除相关模型

型号国家

public  static function boot() {
        parent::boot();

        static::deleting(function($country) {
            //remove related rows region and city
            $country->region->each(function($region) {
                $region->city()->delete();
            });
            $country->region()->delete();//
            return true;
        });
    }

Laravel Eloquent ORM - Removing rows and all the inner relationships

laravel eloquent laravel-events

1 回答

  • 1

    快速回顾一下：

    $model->related_model 将返回相关模型 .
    $model->related_model() 将返回关系对象 .

    您可以执行 $model->related_model->delete() 或 $model->related_model()->get()->delete() 来访问模型上的 delete() 方法 .

    处理删除相关（或子）模型的另一种方法是在编写迁移时使用外键约束，请检查https://laravel.com/docs/master/migrations#foreign-key-constraints

    回复于

相关问题