Deleting related rows with laravel

Question

I am trying to delete all related rows in Laravel with:

$customers = Customer::find($clientId);
$customers->delete();
$customers->locations()->delete();
$customers->locations->objects()->delete();
$customers->locations->objects->subscriptions()->delete();
$customers->locations->objects->history()->delete();

And also tried:

$customers = Customer::find($clientId);
$customers->delete();
$customers->locations()->delete();
$customers->locations()->objects()->delete();
$customers->locations()->objects()->subscriptions()->delete();
$customers->locations()->objects()->history()->delete();

Laravel deletes the customer and locations but does not delete the objects, subscriptions and history and trows an error.

What can I do to delete them too?

EDIT: I changed the order like this:

$customers = Customer::find($clientId);
$customers->locations()->objects()->subscriptions()->delete();
$customers->locations()->objects()->history()->delete();
$customers->locations()->objects()->delete();
$customers->locations()->delete();
$customers->delete();

and get the error Call to undefined method Illuminate\Database\Query\Builder::objects()

have you tried deleting related model first and then parent model? — Anik
– Anik, Commented Sep 24, 2016 at 8:34
I think that would be problem, because when you do $customers->locations()->delete() it tries to find out location of customers which are not deleted (in your case, it use deleted_at is NULL) and deleted_at is not NULL when you already deleted customer. — Anik
– Anik, Commented Sep 24, 2016 at 8:42
@AgeDeO Can you confirm if you have added objects function as relation in location model? — Anik
– Anik, Commented Sep 24, 2016 at 8:46

Sagar Rabadiya · Accepted Answer · 2016-09-24 08:47:33Z

2

you need to override delete method in model to delete all related objects for each location and also delete should be in order, so first delete objects, then locations and then customer. for ex.

$customers = Customer::find($clientId);
$customers->locations()->delete();

now for delete location override delete method in you model something like

class Location extends Model {
     public function delete() {
       $this->objects()->delete();
       parent::delete();
     }
}

//also delete hierarchy in your object model with overriding delete method

class Object extends Model {
     public function delete(){
        $this->history()->delete();
        $this->subscriptions()->delete();
        parent::delete();
     }
}

answered Sep 24, 2016 at 8:47

Sagar Rabadiya

4,3211 gold badge24 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Anik Over a year ago

Just to add information, this would be only good if you want to delete all related models every time parent model is deleted.

Sagar Rabadiya Over a year ago

if its not the case then change the method name with some custom name for example deleteReferences() so it won't behave as default always delete method.

Алексей Морозов · Accepted Answer · 2016-09-24 08:41:44Z

0

Most likely to do in the reverse order.
If you removed the "parent", the "children", he can not find.
Try this.

$customers = Customer::find($clientId);
$customers->locations()->objects()->subscriptions()->delete();
$customers->locations()->objects()->history()->delete();
$customers->locations()->objects()->delete();
$customers->locations()->delete();
$customers->delete();

answered Sep 24, 2016 at 8:41

Алексей Морозов

1871 gold badge1 silver badge11 bronze badges

Comments

linuxartisan · Accepted Answer · 2016-09-24 09:21:09Z

0

When you say

$customers->locations()->delete()

you are trying to delete a Collection. You should delete a Model.

So get all the locations using

$locations = $customer->locations

and then use a foreach loop to delete each location.

foreach($locations as $location) {
  $location->delete();
}

Similarly delete all other related models.

answered Sep 24, 2016 at 9:21

linuxartisan

2,4364 gold badges24 silver badges42 bronze badges

Collectives™ on Stack Overflow

Deleting related rows with laravel

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related