annotate modules/trigger/trigger.install @ 0:ff03f76ab3fe

initial version
author danieleb <danielebarchiesi@me.com>
date Wed, 21 Aug 2013 18:51:11 +0100
parents
children
rev   line source
danielebarchiesi@0 1 <?php
danielebarchiesi@0 2
danielebarchiesi@0 3 /**
danielebarchiesi@0 4 * @file
danielebarchiesi@0 5 * Install, update and uninstall functions for the trigger module.
danielebarchiesi@0 6 */
danielebarchiesi@0 7
danielebarchiesi@0 8 /**
danielebarchiesi@0 9 * Implements hook_schema().
danielebarchiesi@0 10 */
danielebarchiesi@0 11 function trigger_schema() {
danielebarchiesi@0 12 // The total index length (hook and aid) must be less than 333. Since the aid
danielebarchiesi@0 13 // field is 255 characters, the hook field can have a maximum length of 78.
danielebarchiesi@0 14 $schema['trigger_assignments'] = array(
danielebarchiesi@0 15 'description' => 'Maps trigger to hook and operation assignments from trigger.module.',
danielebarchiesi@0 16 'fields' => array(
danielebarchiesi@0 17 'hook' => array(
danielebarchiesi@0 18 'type' => 'varchar',
danielebarchiesi@0 19 'length' => 78,
danielebarchiesi@0 20 'not null' => TRUE,
danielebarchiesi@0 21 'default' => '',
danielebarchiesi@0 22 'description' => 'Primary Key: The name of the internal Drupal hook; for example, node_insert.',
danielebarchiesi@0 23 ),
danielebarchiesi@0 24 'aid' => array(
danielebarchiesi@0 25 'type' => 'varchar',
danielebarchiesi@0 26 'length' => 255,
danielebarchiesi@0 27 'not null' => TRUE,
danielebarchiesi@0 28 'default' => '',
danielebarchiesi@0 29 'description' => "Primary Key: Action's {actions}.aid.",
danielebarchiesi@0 30 ),
danielebarchiesi@0 31 'weight' => array(
danielebarchiesi@0 32 'type' => 'int',
danielebarchiesi@0 33 'not null' => TRUE,
danielebarchiesi@0 34 'default' => 0,
danielebarchiesi@0 35 'description' => 'The weight of the trigger assignment in relation to other triggers.',
danielebarchiesi@0 36 ),
danielebarchiesi@0 37 ),
danielebarchiesi@0 38 'primary key' => array('hook', 'aid'),
danielebarchiesi@0 39 'foreign keys' => array(
danielebarchiesi@0 40 'action' => array(
danielebarchiesi@0 41 'table' => 'actions',
danielebarchiesi@0 42 'columns' => array('aid' => 'aid'),
danielebarchiesi@0 43 ),
danielebarchiesi@0 44 ),
danielebarchiesi@0 45 );
danielebarchiesi@0 46 return $schema;
danielebarchiesi@0 47 }
danielebarchiesi@0 48
danielebarchiesi@0 49 /**
danielebarchiesi@0 50 * Implements hook_install().
danielebarchiesi@0 51 */
danielebarchiesi@0 52 function trigger_install() {
danielebarchiesi@0 53 // Do initial synchronization of actions in code and the database.
danielebarchiesi@0 54 actions_synchronize();
danielebarchiesi@0 55 }
danielebarchiesi@0 56
danielebarchiesi@0 57 /**
danielebarchiesi@0 58 * Alter the "hook" field and drop the "op field" of {trigger_assignments}.
danielebarchiesi@0 59 *
danielebarchiesi@0 60 * Increase the length of the "hook" field to 78 characters and adds operation
danielebarchiesi@0 61 * names to the hook names, and drops the "op" field.
danielebarchiesi@0 62 */
danielebarchiesi@0 63 function trigger_update_7000() {
danielebarchiesi@0 64 db_drop_primary_key('trigger_assignments');
danielebarchiesi@0 65 db_change_field('trigger_assignments', 'hook', 'hook', array('type' => 'varchar', 'length' => 78, 'not null' => TRUE, 'default' => '', 'description' => 'Primary Key: The name of the internal Drupal hook; for example, node_insert.'));
danielebarchiesi@0 66
danielebarchiesi@0 67 $result = db_query("SELECT hook, op, aid FROM {trigger_assignments} WHERE op <> ''");
danielebarchiesi@0 68
danielebarchiesi@0 69 foreach ($result as $record) {
danielebarchiesi@0 70 db_update('trigger_assignments')
danielebarchiesi@0 71 ->fields(array('hook' => $record->hook . '_' . $record->op))
danielebarchiesi@0 72 ->condition('hook', $record->hook)
danielebarchiesi@0 73 ->condition('op', $record->op)
danielebarchiesi@0 74 ->condition('aid', $record->aid)
danielebarchiesi@0 75 ->execute();
danielebarchiesi@0 76 }
danielebarchiesi@0 77 db_drop_field('trigger_assignments', 'op');
danielebarchiesi@0 78
danielebarchiesi@0 79 db_add_primary_key('trigger_assignments', array('hook', 'aid'));
danielebarchiesi@0 80 }
danielebarchiesi@0 81
danielebarchiesi@0 82 /**
danielebarchiesi@0 83 * @addtogroup updates-7.x-extra
danielebarchiesi@0 84 * @{
danielebarchiesi@0 85 */
danielebarchiesi@0 86
danielebarchiesi@0 87 /**
danielebarchiesi@0 88 * Increase the length of the "hook" field to 78 characters.
danielebarchiesi@0 89 *
danielebarchiesi@0 90 * This is a separate function for those who ran an older version of
danielebarchiesi@0 91 * trigger_update_7000() that did not do this.
danielebarchiesi@0 92 */
danielebarchiesi@0 93 function trigger_update_7001() {
danielebarchiesi@0 94 db_drop_primary_key('trigger_assignments');
danielebarchiesi@0 95 db_change_field('trigger_assignments', 'hook', 'hook', array('type' => 'varchar', 'length' => 78, 'not null' => TRUE, 'default' => '', 'description' => 'Primary Key: The name of the internal Drupal hook; for example, node_insert.', ), array('primary key' => array('hook', 'aid')));
danielebarchiesi@0 96 }
danielebarchiesi@0 97
danielebarchiesi@0 98 /**
danielebarchiesi@0 99 * Renames nodeapi to node.
danielebarchiesi@0 100 */
danielebarchiesi@0 101 function trigger_update_7002() {
danielebarchiesi@0 102 $result = db_query("SELECT hook, aid FROM {trigger_assignments}");
danielebarchiesi@0 103
danielebarchiesi@0 104 foreach($result as $record) {
danielebarchiesi@0 105 $new_hook = str_replace('nodeapi', 'node', $record->hook);
danielebarchiesi@0 106 db_update('trigger_assignments')
danielebarchiesi@0 107 ->fields(array('hook' => $new_hook))
danielebarchiesi@0 108 ->condition('hook', $record->hook)
danielebarchiesi@0 109 ->condition('aid', $record->aid)
danielebarchiesi@0 110 ->execute();
danielebarchiesi@0 111 }
danielebarchiesi@0 112 }
danielebarchiesi@0 113
danielebarchiesi@0 114 /**
danielebarchiesi@0 115 * @} End of "addtogroup updates-7.x-extra".
danielebarchiesi@0 116 */