MySQL 8.0.33
Source Code Documentation
routines.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__ROUTINES_INCLUDED
24#define DD_TABLES__ROUTINES_INCLUDED
25
26#include <string>
27
29#include "sql/dd/impl/types/entity_object_table_impl.h" // dd::Dictionary_obj...
30#include "sql/dd/object_id.h"
31#include "sql/dd/string_type.h"
32#include "sql/dd/types/routine.h" // dd::Routine
33
34namespace dd {
35class Object_key;
36class Routine_name_key;
37
38namespace tables {
39
40///////////////////////////////////////////////////////////////////////////
41
43 public:
44 static const Routines &instance();
45
46 static const CHARSET_INFO *name_collation();
47
78 NUMBER_OF_FIELDS // Always keep this entry at the end of the enum
79 };
80
89 };
90
97 };
98
99 Routines();
100
101 Routine *create_entity_object(const Raw_record &) const override;
102
103 static bool update_object_key(Routine_name_key *key, Object_id schema_id,
105 const String_type &routine_name);
106
108
109 /**
110 Create a key to find all routines for a given definer.
111
112 @param definer Name of the definer.
113
114 @returns Pointer to Object_key.
115 */
116 static Object_key *create_key_by_definer(const String_type &definer);
117};
118
119///////////////////////////////////////////////////////////////////////////
120
121} // namespace tables
122} // namespace dd
123
124#endif // DD_TABLES__ROUTINES_INCLUDED
Definition: entity_object_table_impl.h:45
Definition: object_key.h:37
Definition: raw_record.h:45
Definition: object_keys.h:434
Abstract base class for functions and procedures.
Definition: routine.h:60
enum_routine_type
Definition: routine.h:87
Definition: routines.h:42
Routines()
Definition: routines.cc:51
static const CHARSET_INFO * name_collation()
Definition: routines.cc:45
static Object_key * create_key_by_schema_id(Object_id schema_id)
Definition: routines.cc:200
static const Routines & instance()
Definition: routines.cc:38
enum_indexes
Definition: routines.h:81
@ INDEX_UK_SCHEMA_ID_TYPE_NAME
Definition: routines.h:83
@ INDEX_K_SCHEMA_COLLATION_ID
Definition: routines.h:87
@ INDEX_K_RESULT_COLLATION_ID
Definition: routines.h:84
@ INDEX_K_DEFINER
Definition: routines.h:88
@ INDEX_K_CLIENT_COLLATION_ID
Definition: routines.h:85
@ INDEX_PK_ID
Definition: routines.h:82
@ INDEX_K_CONNECTION_COLLATION_ID
Definition: routines.h:86
Routine * create_entity_object(const Raw_record &) const override
Definition: routines.cc:177
static Object_key * create_key_by_definer(const String_type &definer)
Create a key to find all routines for a given definer.
Definition: routines.cc:207
enum_fields
Definition: routines.h:48
@ FIELD_SCHEMA_COLLATION_ID
Definition: routines.h:72
@ FIELD_SQL_DATA_ACCESS
Definition: routines.h:66
@ FIELD_PARAMETER_STR
Definition: routines.h:64
@ FIELD_CREATED
Definition: routines.h:73
@ FIELD_RESULT_IS_ZEROFILL
Definition: routines.h:55
@ FIELD_RESULT_DATA_TYPE
Definition: routines.h:53
@ FIELD_DEFINITION_UTF8
Definition: routines.h:63
@ FIELD_LAST_ALTERED
Definition: routines.h:74
@ FIELD_ID
Definition: routines.h:49
@ FIELD_RESULT_NUMERIC_PRECISION
Definition: routines.h:58
@ FIELD_SECURITY_TYPE
Definition: routines.h:67
@ FIELD_RESULT_NUMERIC_SCALE
Definition: routines.h:59
@ FIELD_RESULT_CHAR_LENGTH
Definition: routines.h:57
@ FIELD_SCHEMA_ID
Definition: routines.h:50
@ FIELD_CLIENT_COLLATION_ID
Definition: routines.h:70
@ FIELD_RESULT_IS_UNSIGNED
Definition: routines.h:56
@ NUMBER_OF_FIELDS
Definition: routines.h:78
@ FIELD_EXTERNAL_LANGUAGE
Definition: routines.h:77
@ FIELD_DEFINER
Definition: routines.h:68
@ FIELD_CONNECTION_COLLATION_ID
Definition: routines.h:71
@ FIELD_COMMENT
Definition: routines.h:75
@ FIELD_RESULT_DATETIME_PRECISION
Definition: routines.h:60
@ FIELD_SQL_MODE
Definition: routines.h:69
@ FIELD_RESULT_COLLATION_ID
Definition: routines.h:61
@ FIELD_RESULT_DATA_TYPE_UTF8
Definition: routines.h:54
@ FIELD_OPTIONS
Definition: routines.h:76
@ FIELD_DEFINITION
Definition: routines.h:62
@ FIELD_IS_DETERMINISTIC
Definition: routines.h:65
@ FIELD_NAME
Definition: routines.h:51
@ FIELD_TYPE
Definition: routines.h:52
enum_foreign_keys
Definition: routines.h:91
@ FK_RESULT_COLLATION_ID
Definition: routines.h:93
@ FK_CONNECTION_COLLATION_ID
Definition: routines.h:95
@ FK_CLIENT_COLLATION_ID
Definition: routines.h:94
@ FK_SCHEMA_ID
Definition: routines.h:92
@ FK_SCHEMA_COLLATION_ID
Definition: routines.h:96
static bool update_object_key(Routine_name_key *key, Object_id schema_id, Routine::enum_routine_type type, const String_type &routine_name)
Definition: routines.cc:189
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
required string key
Definition: replication_asynchronous_connection_failover.proto:59
required string type
Definition: replication_group_member_actions.proto:33
Definition: m_ctype.h:382
unsigned int uint
Definition: uca9-dump.cc:74