faq_ask.install in FAQ_Ask 7

This module is an add-on to the FAQ module that allows users with the 'ask question' permission to create a question which will be queued for an 'expert' to answer.

File

faq_ask.install

<?php

/**
 * @file
 * This module is an add-on to the FAQ module that allows users with the 'ask question'
 * permission to create a question which will be queued for an 'expert' to answer.
 */

/**
 * Implements hook_schema().
 */
function faq_ask_schema() {
  $schema['faq_expert'] = array(
    'description' => 'FAQ expert to term mapping.',
    'fields' => array(
      'uid' => array(
        'description' => 'User identifier for the expert.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'tid' => array(
        'description' => 'Taxonomy identifier of the terms for the expert.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
    ),
    'primary key' => array(
      'uid',
      'tid',
    ),
    'indexes' => array(
      'tid' => array(
        'tid',
        'uid',
      ),
    ),
  );
  $schema['faq_ask_notify'] = array(
    'description' => 'FAQ node to asker mapping.',
    'fields' => array(
      'nid' => array(
        'description' => 'Node identifier for notification',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'email' => array(
        'description' => 'Node identifier for notification',
        'type' => 'varchar',
        'length' => '128',
        'not null' => TRUE,
      ),
    ),
    'primary key' => array(
      'nid',
      'email',
    ),
    'indexes' => array(
      'nid' => array(
        'nid',
        'email',
      ),
    ),
  );
  $schema['faq_ask_term_index'] = array(
    'description' => 'FAQ-Ask maintained index of unpublished node/term relationships.',
    'fields' => array(
      'nid' => array(
        'description' => 'The {node}.nid this record tracks.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'tid' => array(
        'description' => 'The term ID.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'sticky' => array(
        'description' => 'Boolean indicating whether the node is sticky.',
        'type' => 'int',
        'not null' => FALSE,
        'default' => 0,
        'size' => 'tiny',
      ),
      'created' => array(
        'description' => 'The Unix timestamp when the node was created.',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),
    ),
    'indexes' => array(
      'term_node' => array(
        'tid',
        'sticky',
        'created',
      ),
      'nid' => array(
        'nid',
      ),
    ),
    'foreign keys' => array(
      'tracked_node' => array(
        'table' => 'node',
        'columns' => array(
          'nid' => 'nid',
        ),
      ),
      'term' => array(
        'table' => 'taxonomy_term_data',
        'columns' => array(
          'tid' => 'tid',
        ),
      ),
    ),
  );
  return $schema;
}

/**
 * Implements hook_install().
 */
function faq_ask_install() {

  /**
   * Seems like D7 installs anything in hook_schema before this is called.
   * Need no install_shema call
   */

  /*  $result = drupal_install_schema('faq_ask');

    if (count($result) > 0) {
      drupal_set_message(st('faq_ask module installed.'));
    }
    else {
      drupal_set_message(st('faq_ask table creation failed. Please "uninstall" the module and retry.'));
    }
    */
}

/**
 * Add default expert to term id 0
 */
function faq_ask_update_6100() {
  db_query('INSERT INTO {faq_expert} (uid, tid) VALUES (' . variable_get('faq_ask_default_expert', 1) . ', 0)');
  return t('Added default expert into faq_expert table');
}

/**
 * Create notification table
 */
function faq_ask_update_6101() {
  db_create_table('faq_ask', drupal_get_schema_unprocessed('faq_ask', 'faq_ask_notify'));
  return t('Added notification table');
}

/**
 * Adding the term index table for unpublished nodes
 */
function faq_ask_update_7001() {
  $ret = array();
  db_create_table('faq_ask_term_index', drupal_get_schema_unprocessed('faq_ask', 'faq_ask_term_index'));
  return t('Added term index for unpublished nodes');
}

/**
 * Add node/term data to faq_ask maintained term index for unpublished nodes
 */
function faq_ask_update_7002() {
  $node_count = '';
  $term_pairs = '';

  // Get unpublished node nids
  $unpub = db_select('node', 'n')
    ->fields('n', array(
    'nid',
  ))
    ->condition('n.status', '0')
    ->condition('n.type', 'faq')
    ->execute()
    ->fetchCol('nid');
  if (empty($unpub)) {
    return t('No unpublished nodes found.');
  }
  foreach ($unpub as $nid) {
    $node = node_load($nid);
    $node_count++;
    foreach (_faq_ask_get_term_field_name($node) as $field) {
      foreach ($node->{$field}[$node->language] as $term) {

        // Check if the node/term pair is loaded from before
        $result = db_select('faq_ask_term_index', 'ti')
          ->fields('ti')
          ->condition('tid', $term['tid'])
          ->condition('nid', $node->nid)
          ->execute()
          ->fetchAll();

        // If not found and the term is actually a term (not 0) - add it to the table
        if (empty($result) && $term['tid']) {
          db_insert('faq_ask_term_index')
            ->fields(array(
            'nid' => $node->nid,
            'tid' => $term['tid'],
            'sticky' => $node->sticky,
            'created' => $node->created,
          ))
            ->execute();
          $term_pairs++;
        }
      }
    }
  }
  return t('Parsed @count nodes adding @num node id/term pairs to the faq_ask index table.', array(
    '@count' => $node_count,
    '@num' => $term_pairs,
  ));
}

/**
 * Implements hook_uninstall().
 */
function faq_ask_uninstall() {
  drupal_uninstall_schema('faq_ask');
  variable_del('faq_expert_role');
  variable_del('faq_ask_vocabularies');
  variable_del('faq_ask_title_len');
  variable_del('faq_ask_suggest');
  variable_del('faq_ask_notify');
  variable_del('faq_ask_default_expert');
  variable_del('faq_unanswered_count');
  variable_del('faq_ask_expert_advice');
  variable_del('faq_ask_help_text');
  variable_del('faq_ask_categorize');
  variable_del('faq_ask_expert_own');
  variable_del('faq_ask_notify_asker');
  variable_del('faq_ask_notify_asker_simplenews_tid');
  variable_del('faq_ask_notify_asker_simplenews_confirm');
  variable_del('faq_ask_notify_by_cron');
  drupal_set_message(st('faq_ask module uninstalled.'));
}

Functions

Name	Description
faq_ask_install	Implements hook_install().
faq_ask_schema	Implements hook_schema().
faq_ask_uninstall	Implements hook_uninstall().
faq_ask_update_6100	Add default expert to term id 0
faq_ask_update_6101	Create notification table
faq_ask_update_7001	Adding the term index table for unpublished nodes
faq_ask_update_7002	Add node/term data to faq_ask maintained term index for unpublished nodes