Set pathauto state for all entities in a bundle

update_pathauto_generate_alias.php

<?php

// PARAMETER EXAMPLES
// ------------------
// desired status for entities in bundle
// // must be 1 or 0
// $pathauto_status = 1;

// // entity and type
// $entity = 'taxonomy_term';
// $bundle = 'offices_and_subunits';

// ------------------
// use the last three parameters
list($pathauto_status, $entity, $bundle) = array_slice($_SERVER['argv'], -3);
$pathauto_status = (int)$pathauto_status;

if (!($pathauto_status === 1 || $pathauto_status === 0)) {
  echo "Need parameters [STATUS (1 or 0)] [ENTITY] [BUNDLE]\n";
  echo "$pathauto_status must be 1 or 0\n";
  exit(1);
}

$base_table = $entity;
$bundle_key = 'type';
$id_key = 'id';

// terms are abnormal entities
if ($entity == 'taxonomy_term') {
  $base_table = 'taxonomy_term_data';
  $bundle_key = 'vid';
  $id_key = 'tid';
}

$db = \Drupal::database();
$result = $db->select($base_table)
  ->fields($base_table, [$id_key])
  ->condition($bundle_key, $bundle)
  ->execute();
$ids = $result->fetchCol();

echo "Found " . count($ids) . " " . $entity . "(s) of type " . $bundle . "\n";

$updated = $db->update('key_value')
  ->fields([
      'value' => 'i:' . $pathauto_status . ';',
    ])
  ->condition('collection', 'pathauto_state.' . $entity)
  ->condition('name', $ids, 'IN')
  ->execute();

echo "Updated pathauto state for " . $updated . " " . $entity . "(s).\n";
echo "You may want to regenerate aliases for this entity.\n";