islandora_oai.install

<?PHP

/**
 * @file
 * $Id: oai2ForCCK.install
 */

/**
 * Implementation of hook_install()
 */
function islandora_oai_install() {
  $result = array();
  
  $upload_path = file_create_path('islandora_oai_xsls');
  file_check_directory($upload_path, FILE_CREATE_DIRECTORY); 
  
  // Create tables.
  drupal_install_schema('islandora_oai');

  db_query("INSERT INTO {oai2_metadata_formats}
              (`name`,`metadata_prefix`,`schema`,`metadata_namespace`,`record_prefix`,`record_namespace`)
            VALUES 
              ('%s','%s','%s','%s','%s','%s');", 'oai_dc', 'oai_dc', 'http://www.openarchives.org/OAI/2.0/oai_dc.xsd', 'http://www.openarchives.org/OAI/2.0/oai_dc/', 'dc', 'http://purl.org/dc/elements/1.1/'
  );
  db_query("INSERT INTO {oai2_metadata_formats}
              (`name`,`metadata_prefix`,`schema`,`metadata_namespace`,`record_prefix`,`record_namespace`)
            VALUES 
              ('%s','%s','%s','%s','%s','%s');", 'oai_etdms', 'oai_etdms', 'http://www.ndltd.org/standards/metadata/etdms/1.0/etdms.xsd', 'http://www.ndltd.org/standards/metadata/etdms/1.0/', 'thesis', 'http://www.ndltd.org/standards/metadata/etdms/1.0/'
  );

  if (count($result) == count(array_filter($result))) {
    drupal_set_message(t('The oai2 module has successfully added its tables to the database.'));
  }
  else {
    drupal_set_message(t('Drupal was unable to install the database tables for the oai2 module.'), 'error');
  }
}

/**
 * Updates the database to add ETD-MS output capability.
 */
function islandora_oai_update_6100() {
  $result = db_result(db_query("SELECT * FROM {oai2_metadata_formats} WHERE name = '%s';", 'oai_dc'));
  if (!$result) {
    db_query("INSERT INTO {oai2_metadata_formats}
              (`name`,`metadata_prefix`,`schema`,`metadata_namespace`,`record_prefix`,`record_namespace`)
            VALUES 
              ('%s','%s','%s','%s','%s','%s');", 'oai_dc', 'oai_dc', 'http://www.openarchives.org/OAI/2.0/oai_dc.xsd', 'http://www.openarchives.org/OAI/2.0/oai_dc/', 'dc', 'http://purl.org/dc/elements/1.1/'
    );
  }

  $result = db_result(db_query("SELECT * FROM {oai2_metadata_formats} WHERE name = '%s';", 'oai_etdms'));
  if (!$result) {
    db_query("INSERT INTO {oai2_metadata_formats}
              (`name`,`metadata_prefix`,`schema`,`metadata_namespace`,`record_prefix`,`record_namespace`)
            VALUES 
              ('%s','%s','%s','%s','%s','%s');", 'oai_etdms', 'oai_etdms', 'http://www.ndltd.org/standards/metadata/etdms/1.0/etdms.xsd', 'http://www.ndltd.org/standards/metadata/etdms/1.0/', 'thesis', 'http://www.ndltd.org/standards/metadata/etdms/1.0/'
    );
  }
}

/**
 * Implementation of hook_schema().
 */
function islandora_oai_schema() {
  $schema = array();

  $schema['oai2_tokens'] = array(
    'fields' => array(
      'id' => array(
        'type' => 'int',
        'size' => 'big',
        'not null' => TRUE,
        'default' => 0,
        'disp-width' => '20'
      ),
      'deliveredrecords' => array(
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
        'disp-width' => '11'
      ),
      'extquery' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
        'default' => ''
      ),
      'queryargs' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
        'default' => ''
      ),
      'setargs' => array(
        'type' => 'varchar',
        'length' => '64', //length of fedora pid
        'not null' => FALSE,
        'default' => ''
      ),
      'metadata_prefix' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
        'default' => ''
      ),
      'timestamp' => array(
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
        'disp-width' => '11'
      )
    ),
    'primary key' => array('id'),
  );

  $schema['oai2_metadata_formats'] = array(
    'fields' => array(
      'name' => array(
        'type' => 'varchar',
        'length' => '100',
        'not null' => TRUE,
        'default' => ''
      ),
      'metadata_prefix' => array(
        'type' => 'varchar',
        'length' => '100',
        'not null' => TRUE,
        'default' => ''
      ),
      'schema' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => TRUE,
        'default' => ''
      ),
      'metadata_namespace' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => TRUE,
        'default' => ''
      ),
      'record_prefix' => array(
        'type' => 'varchar',
        'length' => '100',
        'not null' => TRUE,
        'default' => ''
      ),
      'record_namespace' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => TRUE,
        'default' => '')
    ),
    'primary key' => array('name'),
  );

  return $schema;
}

/**
 * Implementation of hook_uninstall()
 */
function islandora_oai_uninstall() {

  drupal_uninstall_schema('islandora_oai');
  $upload_path = file_create_path('islandora_oai_xsls');
  $removal_files = file_scan_directory($upload_path, '.*');
  
  foreach ($removal_files as $file) {
    file_delete($file->filename);
  }
  
  rmdir($upload_path);
}