function farm_log_update_7007 in farmOS 7

Migrate observation types to log categories.

File

modules/farm/farm_log/farm_log.install, line 354

Farm Log install file.

Code

function farm_log_update_7007(&$sandbox) {

  // Revert various Features components to ensure that the new log categories
  // vocabulary is created, and the new field base and instances are added.
  $components = array(
    'farm_fields' => array(
      'field_base',
    ),
    'farm_log_activity' => array(
      'field_instance',
    ),
    'farm_log_harvest' => array(
      'field_instance',
    ),
    'farm_log_input' => array(
      'field_instance',
    ),
    'farm_log_observation' => array(
      'field_instance',
    ),
  );
  features_revert($components);

  // Load the old "Farm Observation Types" vocabulary.
  $observation_types_vocab = taxonomy_vocabulary_machine_name_load('farm_observation_types');

  // Load the new "Farm Log Categories" vocabulary.
  $log_categories_vocab = taxonomy_vocabulary_machine_name_load('farm_log_categories');

  // If either of them didn't load, we need to bail.
  if (empty($observation_types_vocab->vid) || empty($log_categories_vocab->vid)) {
    $message = 'Terms could not be migrated from the Farm Observation Types
    vocabulary to the Farm Log Categories vocabulary because one or both of
    them could not be loaded. Check to make sure both vocabularies exist, and
    try running the update again.';
    throw new DrupalUpdateException($message);
  }

  // Move all terms from the old vocabulary to the new vocabulary.
  db_update('taxonomy_term_data')
    ->fields(array(
    'vid' => $log_categories_vocab->vid,
  ))
    ->condition('vid', $observation_types_vocab->vid)
    ->execute();

  // Move all field data from the old field to the new field.
  db_query('INSERT INTO {field_data_field_farm_log_category} (SELECT entity_type, bundle, deleted, entity_id, revision_id, language, delta, field_farm_observation_type_tid as field_farm_log_category_tid FROM {field_data_field_farm_observation_type})');
  db_query('INSERT INTO {field_revision_field_farm_log_category} (SELECT entity_type, bundle, deleted, entity_id, revision_id, language, delta, field_farm_observation_type_tid as field_farm_log_category_tid FROM {field_revision_field_farm_observation_type})');

  // Delete the old vocabulary.
  taxonomy_vocabulary_delete($observation_types_vocab->vid);

  // Delete the old field instance.
  $field = field_info_instance('log', 'field_farm_observation_type', 'farm_observation');
  field_delete_instance($field);

  // Create log categories on behalf of all enabled modules.
  farm_log_categories_create_all();
}