function migrate_update_7004 in Migrate 7.2

Convert lastimported datetime field to lastimportedtime int field.

File

./migrate.install, line 283

Migrate module installation

Code

function migrate_update_7004() {
  $ret = '';
  if (!db_field_exists('migrate_status', 'lastimportedtime')) {
    db_add_field('migrate_status', 'lastimportedtime', array(
      'type' => 'int',
      'unsigned' => TRUE,
      'not null' => FALSE,
      'description' => 'Date and time of last completed import',
    ));
    if (db_field_exists('migrate_status', 'lastimported')) {
      $result = db_select('migrate_status', 'ms')
        ->fields('ms', array(
        'machine_name',
        'lastimported',
      ))
        ->execute();
      foreach ($result as $row) {
        $lastimportedtime = strtotime($row->lastimported);
        db_update('migrate_status')
          ->fields(array(
          'lastimportedtime' => $lastimportedtime,
        ))
          ->condition('machine_name', $row->machine_name)
          ->execute();
      }
      db_drop_field('migrate_status', 'lastimported');
      $ret .= "\n" . t('Converted lastimported datetime field to lastimportedtime int field');
    }
  }
  return $ret;
}