sql_trigger.h 5.25 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
/* Copyright (C) 2004-2005 MySQL AB

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307 USA */


18 19 20 21 22
/*
  This class holds all information about triggers of table.

  QQ: Will it be merged into TABLE in future ?
*/
23

24 25 26
class Table_triggers_list: public Sql_alloc
{
  /* Triggers as SPs grouped by event, action_time */
27
  sp_head *bodies[TRG_EVENT_MAX][TRG_ACTION_MAX];
28 29 30 31 32
  /*
    Heads of the lists linking items for all fields used in triggers
    grouped by event and action_time.
  */
  Item_trigger_field *trigger_fields[TRG_EVENT_MAX][TRG_ACTION_MAX];
33
  /*
34 35 36
    Copy of TABLE::Field array with field pointers set to TABLE::record[1]
    buffer instead of TABLE::record[0] (used for OLD values in on UPDATE
    trigger and DELETE trigger when it is called for REPLACE).
37
  */
38 39 40 41 42 43 44
  Field             **record1_field;
  /*
    During execution of trigger new_field and old_field should point to the
    array of fields representing new or old version of row correspondingly
    (so it can point to TABLE::field or to Tale_triggers_list::record1_field)
  */
  Field             **new_field;
45
  Field             **old_field;
46 47
  /* TABLE instance for which this triggers list object was created */
  TABLE *table;
48 49 50 51 52 53
  /*
    Names of triggers.
    Should correspond to order of triggers on definitions_list,
    used in CREATE/DROP TRIGGER for looking up trigger by name.
  */
  List<LEX_STRING>  names_list;
54 55 56 57 58
  /*
    List of "ON table_name" parts in trigger definitions, used for
    updating trigger definitions during RENAME TABLE.
  */
  List<LEX_STRING>  on_table_names_list;
59 60 61 62 63 64 65 66
  /*
    Key representing triggers for this table in set of all stored
    routines used by statement.
    TODO: We won't need this member once triggers namespace will be
    database-wide instead of table-wide because then we will be able
    to use key based on sp_name as for other stored routines.
  */
  LEX_STRING        sroutines_key;
67

68
  /*
69
    Grant information for each trigger (pair: subject table, trigger definer).
70
  */
71
  GRANT_INFO        subject_table_grants[TRG_EVENT_MAX][TRG_ACTION_MAX];
72

73 74 75 76 77 78
public:
  /*
    Field responsible for storing triggers definitions in file.
    It have to be public because we are using it directly from parser.
  */
  List<LEX_STRING>  definitions_list;
79 80 81 82
  /*
    List of sql modes for triggers
  */
  List<ulonglong> definition_modes_list;
83

84 85
  List<LEX_STRING>  definers_list;

86 87
  Table_triggers_list(TABLE *table_arg):
    record1_field(0), table(table_arg)
88 89
  {
    bzero((char *)bodies, sizeof(bodies));
90
    bzero((char *)trigger_fields, sizeof(trigger_fields));
91
    bzero((char *)&subject_table_grants, sizeof(subject_table_grants));
92 93 94
  }
  ~Table_triggers_list();

95 96
  bool create_trigger(THD *thd, TABLE_LIST *table, String *stmt_query);
  bool drop_trigger(THD *thd, TABLE_LIST *table, String *stmt_query);
97
  bool process_triggers(THD *thd, trg_event_type event,
98
                        trg_action_time_type time_type,
99
                        bool old_row_is_record1);
100 101
  bool get_trigger_info(THD *thd, trg_event_type event,
                        trg_action_time_type time_type,
102
                        LEX_STRING *trigger_name, LEX_STRING *trigger_stmt,
103 104
                        ulong *sql_mode,
                        LEX_STRING *definer);
105 106

  static bool check_n_load(THD *thd, const char *db, const char *table_name,
107 108
                           TABLE *table, bool names_only);
  static bool drop_all_triggers(THD *thd, char *db, char *table_name);
109 110 111 112
  static bool change_table_name(THD *thd, const char *db,
                                const char *old_table,
                                const char *new_db,
                                const char *new_table);
113 114 115 116 117 118
  bool has_delete_triggers()
  {
    return (bodies[TRG_EVENT_DELETE][TRG_ACTION_BEFORE] ||
            bodies[TRG_EVENT_DELETE][TRG_ACTION_AFTER]);
  }

119 120
  void set_table(TABLE *new_table);

121
  void mark_fields_used(trg_event_type event);
122

123
  friend class Item_trigger_field;
124
  friend int sp_cache_routines_and_add_tables_for_triggers(THD *thd, LEX *lex,
125
                                                            TABLE_LIST *table);
126 127

private:
128
  bool prepare_record1_accessors(TABLE *table);
129 130 131 132 133 134 135
  LEX_STRING* change_table_name_in_trignames(const char *db_name,
                                             LEX_STRING *new_table_name,
                                             LEX_STRING *stopper);
  bool change_table_name_in_triggers(THD *thd,
                                     const char *db_name,
                                     LEX_STRING *old_table_name,
                                     LEX_STRING *new_table_name);
136
};
137 138 139

extern const LEX_STRING trg_action_time_type_names[];
extern const LEX_STRING trg_event_type_names[];