fserver.install

<?php

/**
 * @file
 * Install tasks for fserver
 */

/**
 * Implements hook_requirements().
 */
function fserver_requirements($phase) {
  $requirements = array();
  // @todo add check on filehash module and ensure that MD5 is enabled

  return $requirements;
}

/**
 * Implements hook_schema().
 */
function fserver_schema() {
  module_load_include('install', 'uuid');

  $schema['fserver_project_type'] = array(
    'description' => 'Storage for fserver project types.',
    'fields' => array(
      'id' => array(
        'type' => 'serial',
        'not null' => TRUE,
        'description' => 'Primary Key: Numeric project type ID.',
      ),
      'type' => array(
        'description' => 'The unified identifier for a project type.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'description' => array(
        'description' => 'Description for this project type.',
        'type' => 'text',
      ),
      'uuid' => uuid_schema_field_definition(),
    ) + entity_exportable_schema_fields(),
    'primary key' => array('id'),
    'unique keys' => array(
      'uuid' => array('uuid'),
      'type' => array('type'),
    ),
  );

  $schema['fserver_release_type'] = array(
    'description' => 'Storage for fserver project types.',
    'fields' => array(
      'id' => array(
        'type' => 'serial',
        'not null' => TRUE,
        'description' => 'Primary Key: Numeric project type ID.',
      ),
      'type' => array(
        'description' => 'The unified identifier for a project type.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'description' => array(
        'description' => 'Description for this project type.',
        'type' => 'text',
      ),
      'uuid' => uuid_schema_field_definition(),
    ) + entity_exportable_schema_fields(),
    'primary key' => array('id'),
    'unique keys' => array(
      'uuid' => array('uuid'),
      'type' => array('type'),
    ),
  );

  $schema['fserver_project'] = array(
    'description' => 'Storage for fserver project entities.',
    'fields' => array(
      'id' => array(
        'type' => 'serial',
        'not null' => TRUE,
        'description' => 'Primary Key: Numeric project entity ID.',
      ),
      'short_name' => array(
        'description' => 'The unique machine name for a project type.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'type' => array(
        'description' => 'The bundle type identifier for a project.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'uuid' => uuid_schema_field_definition(),
      'title' => array(
        'description' => 'Human readable project title.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'recommended_major' => array(
        'description' => 'Recommended major version',
        'not null' => FALSE,
        'type' => 'text',
        'serialized' => TRUE,
      ),
      'supported_majors' => array(
        'description' => 'Supported major projects.',
        'type' => 'text',
        'serialized' => TRUE,
      ),
      'default_major' => array(
        'description' => 'Default major version',
        'type' => 'text',
        'not null' => FALSE,
        'serialized' => TRUE,
      ),
      'project_status' => array(
        'type' => 'varchar',
        'length' => 255,
        'description' => 'Project status code'
      ),
      'link' => array(
        'description' => 'Link to the project.',
        'type' => 'varchar',
        'length' => 255,
      ),
      'created' => array(
        'type' => 'int',
        'not null' => TRUE,
        'unsigned' => TRUE,
        'default' => 0,
      ),
      'changed' => array(
        'type' => 'int',
        'not null' => TRUE,
        'unsigned' => TRUE,
        'default' => 0,
      ),
    ),
    'primary key' => array('id'),
    'unique keys' => array(
      'uuid' => array('uuid'),
      'short_name' => array('short_name'),
    ),
    'indexes' => array(
      'type' => array('type'),
    ),
  );

  $schema['fserver_release'] = array(
    'description' => 'Storage for fserver release entities.',
    'fields' => array(
      'id' => array(
        'type' => 'serial',
        'not null' => TRUE,
        'description' => 'Primary Key: Numeric release entity ID.',
      ),
      'name' => array(
        'type' => 'varchar',
        'length' => 255,
        'description' => 'Release name'
      ),
      'version' => array(
        'type' => 'varchar',
        'length' => 255,
        'description' => 'Release version'
      ),
      'project_short_name' => array(
        'type' => 'varchar',
        'length' => 255,
        'description' => 'Project short name',
      ),
      'tag' => array(
        'type' => 'varchar',
        'length' => 255,
        'description' => 'Release tag'
      ),
      'version_major' => array(
        'type' => 'int',
        'unsigned' => TRUE,
      ),
      'version_patch' => array(
        'type' => 'int',
        'unsigned' => TRUE,
      ),
      'version_extra' => array(
        'type' => 'varchar',
        'length' => 255,
        'description' => 'Release tag'
      ),
      'date' => array(
        'type' => 'int',
        'unsigned' => TRUE,
      ),
      'api' => array(
        'type' => 'varchar',
        'length' => 255,
        'description' => 'API version'
      ),
      'type' => array(
        'description' => 'The bundle type identifier for a release.',
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
      ),
      'uuid' => uuid_schema_field_definition(),
    ),
    'primary key' => array('id'),
    'unique keys' => array(
      'uuid' => array('uuid'),
      'name' => array('name'),
    ),
    'indexes' => array(
      'type' => array('type'),
      'date' => array('date'),
      'api' => array('api'),
      'project_short_name' => array('project_short_name'),
      'version_extra' => array('version_extra'),
      'version_major' => array('version_major'),
    ),
  );

  return $schema;
}

/**
 * Implements hook_enable().
 */
function fserver_enable() {
  // Enable MD5 hashes on files
  // We don't use strongarm here since people may want to have
  // the other filehash algorithms on as well. We just need
  // to make sure that md5 is there.
  $algos = variable_get('filehash_algos', array());
  $algos['md5'] = 'md5';
  variable_set('filehash_algos', $algos);
}

/**
 * Implements hook_update_N().
 *
 * Add fserver_release indexes: project_short_name, version_extra, version_major.
 */
function fserver_update_7000() {
  db_add_index('fserver_release', 'version_extra', array('version_extra'));
  db_add_index('fserver_release', 'version_major', array('version_major'));
  db_add_index('fserver_release', 'project_short_name', array('project_short_name'));
}

/**
 * Impelements hook_update_N().
 *
 * Add major version specific values for supported release, default major and recommended release
 */
function fserver_update_7001() {
  $temp_table_name = 'temp_fserver_project';
  // create a temporary table to store old values
  $schema = drupal_get_schema('fserver_project', TRUE);
  $fields = array_keys($schema['fields']);
  db_drop_table($temp_table_name);
  $table = db_create_table($temp_table_name, $schema);

  // load old data into this table
  $select = db_select('fserver_project', 'proj')
    ->fields('proj')
    ->execute();
  $id = db_insert($temp_table_name)
    ->fields($fields);
  while ($record = $select->fetchAssoc()) {
    // Update modified field values.
    $def_maj = (!empty($record['default_major'])) ? $record['default_major'] : 1;
    $rec_maj = (!empty($record['recommended_major'])) ? $record['recommended_major'] : 1;
    $sup_maj = (!empty($record['supported_majors'])) ? $record['supported_majors'] : 1;
    $new_def_maj = array();
    $new_rec_maj = array();
    $new_sup_maj = array();
    $project = entity_load_single('project', $record['id']);
    $wrapper = entity_metadata_wrapper('project', $project);
    $apis = $wrapper->field_compatibility->value();
    foreach($apis as $api) {
      $new_def_maj[] = array('api' => $api, 'default_major' => $def_maj);
      $new_rec_maj[] = array('api' => $api, 'recommended_major' => $rec_maj);
      $new_sup_maj[] = array('api' => $api, 'supported_majors' => array($sup_maj));
    }
    $record['default_major'] = serialize($new_def_maj);
    $record['recommended_major'] = serialize($new_rec_maj);
    $record['supported_majors'] = serialize($new_sup_maj);
    $id->values($record);
  }
  $id->execute();

  db_drop_table('fserver_project');
  $table = db_create_table('fserver_project', $schema);
  $select = db_select($temp_table_name, 'proj')
    ->fields('proj')
    ->execute();
  $id = db_insert('fserver_project')
    ->fields($fields);
  while ($record = $select->fetchAssoc()) {
    $id->values($record);
  }
  $id->execute();

  // drop the temporary table
  db_drop_table($temp_table_name);
}