migrate_example.install in Migrate 7.2

File

migrate_example/migrate_example.install

<?php

/**
 * @file
 * Set up the migration example module.
 */
require_once DRUPAL_ROOT . '/' . drupal_get_path('module', 'migrate_example') . '/beer.install.inc';
require_once DRUPAL_ROOT . '/' . drupal_get_path('module', 'migrate_example') . '/wine.install.inc';
function migrate_example_schema() {
  $schema = migrate_example_beer_schema();
  $schema += migrate_example_wine_schema();
  return $schema;
}
function migrate_example_install() {
  migrate_example_beer_install();
  migrate_example_wine_install();

  // A simple format for testing migration of format
  $example_format = array(
    'format' => 'migrate_example',
    'name' => 'Migrate example format',
    'weight' => 20,
    'filters' => array(
      // Escape all HTML.
      'filter_html_escape' => array(
        'weight' => 0,
        'status' => 1,
      ),
    ),
  );
  $example_format = (object) $example_format;
  filter_format_save($example_format);
  migrate_static_registration();
}
function migrate_example_uninstall() {
  migrate_example_beer_uninstall();
  migrate_example_wine_uninstall();
  if ($format = filter_format_load('migrate_example')) {
    filter_format_disable($format);
  }
}
function migrate_example_disable() {
  migrate_example_beer_disable();
  migrate_example_wine_disable();
}

/**
 * Convert modificationdate datetime field to modificationdatetime int field.
 */
function migrate_example_update_7001() {
  $ret = array();
  db_add_field('migrate_example_beer_legacy_urls', 'modificationdatetime', array(
    'type' => 'int',
    'unsigned' => TRUE,
    'not null' => FALSE,
  ));
  $result = db_select('migrate_example_beer_legacy_urls', 'ms')
    ->fields('ms', array(
    'machine_name',
    'modificationdate',
  ))
    ->execute();
  foreach ($result as $row) {
    $modificationdatetime = strtotime($row->modificationdate);
    db_update('migrate_example_beer_legacy_urls')
      ->fields(array(
      'modificationdatetime' => $modificationdatetime,
    ))
      ->condition('machine_name', $row->machineName)
      ->execute();
  }
  db_drop_field('migrate_example_beer_legacy_urls', 'modificationdate');
  $ret[] = t('Converted modificationdate datetime field to modificationdatetime int field');
  return $ret;
}

/**
 * Add image alt/title/description columns.
 */
function migrate_example_update_7002() {
  $ret = array();
  db_add_field('migrate_example_beer_node', 'image_alt', array(
    'type' => 'varchar',
    'length' => 255,
    'not null' => FALSE,
    'description' => 'Image ALT',
  ));
  db_add_field('migrate_example_beer_node', 'image_title', array(
    'type' => 'varchar',
    'length' => 255,
    'not null' => FALSE,
    'description' => 'Image title',
  ));
  db_add_field('migrate_example_beer_node', 'image_description', array(
    'type' => 'varchar',
    'length' => 255,
    'not null' => FALSE,
    'description' => 'Image description',
  ));
  db_update('migrate_example_beer_node')
    ->fields(array(
    'image_alt' => 'Heinekin alt',
    'image_title' => 'Heinekin title',
    'image_description' => 'Heinekin description',
  ))
    ->condition('bid', 99999999)
    ->execute();
  $ret[] = t('Added image_alt, image_title, and image_description fields.');
  return $ret;
}

/**
 * Add data for remote file examples.
 */
function migrate_example_update_7003() {
  $ret = array();
  db_create_table('migrate_example_wine_files', migrate_example_wine_schema_files());
  migrate_example_wine_data_files();
  db_add_field('migrate_example_wine_account', 'imageid', array(
    'type' => 'int',
    'unsigned' => TRUE,
    'not null' => FALSE,
    'description' => 'Image ID.',
  ));
  db_update('migrate_example_wine_account')
    ->fields(array(
    'imageid' => 1,
  ))
    ->condition('accountid', 9)
    ->execute();
  $ret[] = t('Added migrate_example_wine_files table.');
  $ret[] = t('Added imageid field to migrate_example_wine_account table.');
  return $ret;
}

/**
 * Add sample data for file fields. And, make the image field multi-value.
 */
function migrate_example_update_7004() {
  $ret = array();
  db_update('migrate_example_wine')
    ->fields(array(
    'image' => 'http://cyrve.com/files/penguin.jpeg',
  ))
    ->condition('wineid', 1)
    ->execute();
  db_update('migrate_example_wine')
    ->fields(array(
    'image' => 'http://cyrve.com/files/rioja.jpeg|http://cyrve.com/files/boutisse_0.jpeg',
  ))
    ->condition('wineid', 2)
    ->execute();
  $field = field_info_field('field_migrate_example_image');
  if ($field) {
    $field['cardinality'] = -1;

    // Unlimited
    field_update_field($field);
  }
  else {
    migrate_example_beer_image();
    migrate_example_wine_fields();
  }
  $ret[] = t('Added sample data for file fields.');
  $ret[] = t('Made field_migrate_example_image multi-value');
  return $ret;
}

/**
 * Expand file field example data.
 */
function migrate_example_update_7005() {
  $ret = array();

  // Easiest to just start over from scratch
  if (db_table_exists('migrate_example_wine_files')) {
    db_drop_table('migrate_example_wine_files');
  }
  db_create_table('migrate_example_wine_files', migrate_example_wine_schema_files());
  migrate_example_wine_data_files();

  // Moved this data to migrate_example_wine_files
  if (db_field_exists('migrate_example_wine', 'image')) {
    db_drop_field('migrate_example_wine', 'image');
  }
  $ret[] = t('Reconfigured sample data for file fields.');
  return $ret;
}

/**
 * Sample data for table destinations..
 */
function migrate_example_update_7006() {
  $ret = array();
  db_create_table('migrate_example_wine_table_source', migrate_example_wine_schema_table_source());
  db_create_table('migrate_example_wine_table_dest', migrate_example_wine_schema_table_dest());
  migrate_example_wine_data_table_source();
  $ret[] = t('Added sample data for table destinations.');
  return $ret;
}

/**
 * Add data for testing/demonstrating roles.
 */
function migrate_example_update_7007() {
  $ret = array();
  db_add_field('migrate_example_wine_account', 'positions', array(
    'type' => 'varchar',
    'length' => 255,
    'not null' => FALSE,
    'description' => 'Positions held',
  ));
  $query = db_update('migrate_example_wine_account')
    ->fields(array(
    'positions' => '5',
  ))
    ->condition('accountid', 1)
    ->execute();
  db_update('migrate_example_wine_account')
    ->fields(array(
    'positions' => '18',
  ))
    ->condition('accountid', 3)
    ->execute();
  db_update('migrate_example_wine_account')
    ->fields(array(
    'positions' => '5,18',
  ))
    ->condition('accountid', 9)
    ->execute();
  $ret[] = t('Added positions field to migrate_example_wine_account table.');
  return $ret;
}

Functions

Name	Description
migrate_example_disable
migrate_example_install
migrate_example_schema
migrate_example_uninstall
migrate_example_update_7001	Convert modificationdate datetime field to modificationdatetime int field.
migrate_example_update_7002	Add image alt/title/description columns.
migrate_example_update_7003	Add data for remote file examples.
migrate_example_update_7004	Add sample data for file fields. And, make the image field multi-value.
migrate_example_update_7005	Expand file field example data.
migrate_example_update_7006	Sample data for table destinations..
migrate_example_update_7007	Add data for testing/demonstrating roles.