MySQL 8.3.0
Source Code Documentation
triggers.h
Go to the documentation of this file.
1/* Copyright (c) 2016, 2023, Oracle and/or its affiliates.
2
3 This program is free software; you can redistribute it and/or modify
4 it under the terms of the GNU General Public License, version 2.0,
5 as published by the Free Software Foundation.
6
7 This program is also distributed with certain software (including
8 but not limited to OpenSSL) that is licensed under separate terms,
9 as designated in a particular file or component or in included license
10 documentation. The authors of MySQL hereby grant you an additional
11 permission to link the program and your derivative works with the
12 separately licensed software that they have included with MySQL.
13
14 This program is distributed in the hope that it will be useful,
15 but WITHOUT ANY WARRANTY; without even the implied warranty of
16 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 GNU General Public License, version 2.0, for more details.
18
19 You should have received a copy of the GNU General Public License
20 along with this program; if not, write to the Free Software
21 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
22
23#ifndef DD_TABLES__TRIGGERS_INCLUDED
24#define DD_TABLES__TRIGGERS_INCLUDED
25
26#include <string>
27
30#include "sql/dd/impl/types/object_table_impl.h" // dd::Object_table_i...
31#include "sql/dd/impl/types/trigger_impl.h" // dd::Trigger_impl
32#include "sql/dd/object_id.h"
33#include "sql/dd/string_type.h"
34
35class THD;
36
37struct CHARSET_INFO;
38
39namespace dd {
40class Object_key;
41} // namespace dd
42
43namespace dd {
44namespace tables {
45
46///////////////////////////////////////////////////////////////////////////
47
48class Triggers : virtual public Object_table_impl {
49 public:
50 static const Triggers &instance() {
51 static Triggers *s_instance = new Triggers();
52 return *s_instance;
53 }
54
55 static const CHARSET_INFO *name_collation();
56
75 NUMBER_OF_FIELDS // Always keep this entry at the end of the enum
76 };
77
79 INDEX_PK_ID = static_cast<uint>(Common_index::PK_ID),
86 };
87
94 };
95
96 Triggers();
97
98 /**
99 Create a key to find all triggers for a given schema.
100
101 @param schema_id Object_id of the schema.
102
103 @returns Pointer to Object_key.
104 */
105
107
108 /**
109 Create a key to find all triggers for a given table.
110
111 @param table_id Object_id of the table.
112
113 @returns Pointer to Object_key.
114 */
115
117
118 /**
119 Find table's Object_id for a given trigger name.
120
121 @param thd Thread
122 @param schema_id Object_id of schema in which the trigger exists.
123 @param trigger_name Name of trigger we are search for.
124 @param oid [out] The Object_id of trigger.
125
126 @returns
127 false on success.
128 true upon failure.
129 */
130
131 static bool get_trigger_table_id(THD *thd, Object_id schema_id,
132 const String_type &trigger_name,
133 Object_id *oid);
134
135 /**
136 Create a key to find all triggers for a given definer.
137
138 @param definer Name of the definer.
139
140 @returns Pointer to Object_key.
141 */
142 static Object_key *create_key_by_definer(const String_type &definer);
143
144 private:
145 /**
146 Create a key to find a trigger by schema_id and trigger name.
147
148 @param schema_id Object_id of the table.
149 @param trigger_name Name of trigger.
150
151 @returns Pointer to Object_key.
152 */
154 const char *trigger_name);
155
156 /**
157 Get the table id from the record.
158
159 @param r const Reference to the Raw_record.
160
161 @returns Object_id of the table.
162 */
163
164 static Object_id read_table_id(const Raw_record &r);
165};
166
167///////////////////////////////////////////////////////////////////////////
168
169} // namespace tables
170} // namespace dd
171
172#endif // DD_TABLES__TRIGGERS_INCLUDED
For each client connection we create a separate thread with THD serving as a thread/connection descri...
Definition: sql_lexer_thd.h:35
Definition: object_key.h:37
Definition: object_table_impl.h:35
Definition: raw_record.h:45
Definition: triggers.h:48
enum_foreign_keys
Definition: triggers.h:88
@ FK_SCHEMA_ID
Definition: triggers.h:89
@ FK_CLIENT_COLLATION_ID
Definition: triggers.h:91
@ FK_CONNECTION_COLLATION_ID
Definition: triggers.h:92
@ FK_TABLE_ID
Definition: triggers.h:90
@ FK_SCHEMA_COLLATION_ID
Definition: triggers.h:93
static Object_key * create_key_by_schema_id(Object_id schema_id)
Create a key to find all triggers for a given schema.
Definition: triggers.cc:132
static Object_key * create_key_by_trigger_name(Object_id schema_id, const char *trigger_name)
Create a key to find a trigger by schema_id and trigger name.
Definition: triggers.cc:148
static Object_key * create_key_by_table_id(Object_id table_id)
Create a key to find all triggers for a given table.
Definition: triggers.cc:140
enum_fields
Definition: triggers.h:57
@ FIELD_ACTION_STATEMENT
Definition: triggers.h:65
@ FIELD_TABLE_ID
Definition: triggers.h:62
@ FIELD_CLIENT_COLLATION_ID
Definition: triggers.h:71
@ FIELD_DEFINER
Definition: triggers.h:70
@ FIELD_EVENT_TYPE
Definition: triggers.h:61
@ NUMBER_OF_FIELDS
Definition: triggers.h:75
@ FIELD_CONNECTION_COLLATION_ID
Definition: triggers.h:72
@ FIELD_ACTION_STATEMENT_UTF8
Definition: triggers.h:66
@ FIELD_SCHEMA_COLLATION_ID
Definition: triggers.h:73
@ FIELD_LAST_ALTERED
Definition: triggers.h:68
@ FIELD_OPTIONS
Definition: triggers.h:74
@ FIELD_NAME
Definition: triggers.h:60
@ FIELD_SCHEMA_ID
Definition: triggers.h:59
@ FIELD_CREATED
Definition: triggers.h:67
@ FIELD_SQL_MODE
Definition: triggers.h:69
@ FIELD_ID
Definition: triggers.h:58
@ FIELD_ACTION_TIMING
Definition: triggers.h:63
@ FIELD_ACTION_ORDER
Definition: triggers.h:64
enum_indexes
Definition: triggers.h:78
@ INDEX_UK_SCHEMA_ID_NAME
Definition: triggers.h:80
@ INDEX_K_DEFINER
Definition: triggers.h:85
@ INDEX_K_CLIENT_COLLATION_ID
Definition: triggers.h:82
@ INDEX_UK_TABLE_ID_EVENT_TYPE_ACTION_TIMING_ACTION_ORDER
Definition: triggers.h:81
@ INDEX_K_CONNECTION_COLLATION_ID
Definition: triggers.h:83
@ INDEX_K_SCHEMA_COLLATION_ID
Definition: triggers.h:84
@ INDEX_PK_ID
Definition: triggers.h:79
Triggers()
Definition: triggers.cc:52
static const Triggers & instance()
Definition: triggers.h:50
static Object_id read_table_id(const Raw_record &r)
Get the table id from the record.
Definition: triggers.cc:156
static const CHARSET_INFO * name_collation()
Definition: triggers.cc:46
static bool get_trigger_table_id(THD *thd, Object_id schema_id, const String_type &trigger_name, Object_id *oid)
Find table's Object_id for a given trigger name.
Definition: triggers.cc:162
static Object_key * create_key_by_definer(const String_type &definer)
Create a key to find all triggers for a given definer.
Definition: triggers.cc:191
const dd::system_views::Columns_extensions * s_instance
Definition: columns_extensions.cc:41
The version of the current data dictionary table definitions.
Definition: dictionary_client.h:42
unsigned long long Object_id
Definition: object_id.h:30
Char_string_template< String_type_allocator > String_type
Definition: string_type.h:50
const mysql_service_registry_t * r
Definition: pfs_example_plugin_employee.cc:85
Definition: m_ctype.h:422