Delete entity under some conditions Drupal 8

Question

The task is to delete the entities, which satisfies some specified conditions. How can I do it ?

$current_user = \Drupal::currentUser()->id();
$storage = \Drupal::entityManager()->getStorage('context');

$query = $storage->getQuery()->condition('user_id', $current_user);

$query = $storage->getQuery()->delete();
$query->condition('user_id', $current_user);
$query->condition('key_text', $key);

$query->execute();

But the code returns: Fatal error: Call to undefined method Drupal\Core\Config\Entity\Query\Query::delete()

Jorge Alves · Accepted Answer · 2017-04-07T15:24:43.127

4

To query entities you can use entityQuery, example below uses this.

// Get all users with email containing "xyz"
$query = \Drupal::entityQuery('user')
  ->condition('mail', "XYZ", 'CONTAINS');
$uids = $query->execute();

// Load these entities ($uids) in our case using storage controller.
// We call loadMultiple method and give $uids array as argument.     
$itemsToDelete = \Drupal::entityTypeManager()->getStorage('user')
  ->loadMultiple($uids);

// Loop through our entities and deleting them by calling by delete method.
foreach ($itemsToDelete as $item) {
  $item->delete();
}

edited Apr 07 '17 at 15:24

answered Apr 03 '17 at 08:44

Jorge Alves

56
4

2

Whilst this code snippet is welcome, and may provide some help, it would be [greatly improved if it included an explanation](//meta.stackexchange.com/q/114762) of *how* and *why* this solves the problem. Remember that you are answering the question for readers in the future, not just the person asking now! Please [edit] your answer to add explanation, and give an indication of what limitations and assumptions apply. – Toby Speight Apr 03 '17 at 12:55

score 2 · Answer 2 · answered Jul 28 '17 at 02:50

2

Use the entity storage's delete() method to delete multiple entities. There's no need to iterate over all of them.

$query = \Drupal::entityQuery('taxonomy_term');
$query->condition('vid', 'tags');
$tids = $query->execute();

$storage_handler = \Drupal::entityTypeManager()->getStorage($entity_type);
$entities = $storage_handler->loadMultiple($tids);
$storage_handler->delete($entities);

Taken from https://stackoverflow.com/a/43786945/442022.

answered Jul 28 '17 at 02:50

colan

2,818
2
20
17

2

you would run out of memory if there are a lot of entities (same thing with the accepted answer). Sometimes you just need to load and delete one by one. – Dmitry Boychev Oct 24 '20 at 21:41

score 0 · Answer 3 · answered Apr 29 '16 at 12:19

You need to get your entities first before you can actually delete them. This method is also required for updating them or getting information from them. Hope the code below helps out :)

$current_user = \Drupal::currentUser()->id();    

$ids = \Drupal::entityQuery('context')
          ->condition('user_id', $current_user)
          ->execute();

$itemsToDelete = $this->entityTypeManager->getStorage('context')
          ->loadMultiple($ids);


foreach ($itemsToDelete as $item) {
   $item->delete();
}

apaderno · Answer 4 · 2017-05-31T11:02:36.660

The error message is caused from the fact the class you are using for querying your configuration entity doesn't have a delete() method. This is also true for content entities. The delete() method is implemented by the entity, so the correct code is similar to the following one.

$storage = \Drupal::entityTypeManager()->getStorage('context');
$query = $storage->getQuery();

$ids = $query->condition('user_id', $current_user)
  ->condition('key_text', $key)
  ->execute();

foreach ($storage->loadMultiple($ids) as $entity) {
  $entity->delete();
}

See entity.query service deprecated in favor of EntityStorageInterface::getQuery().

Delete entity under some conditions Drupal 8

4 Answers4