1 /*
2 * Copyright (c) 2019, Oracle and/or its affiliates. All rights reserved.
3 *
4 * This program is free software; you can redistribute it and/or modify
5 * it under the terms of the GNU General Public License, version 2.0,
6 * as published by the Free Software Foundation.
7 *
8 * This program is also distributed with certain software (including
9 * but not limited to OpenSSL) that is licensed under separate terms,
10 * as designated in a particular file or component or in included license
11 * documentation. The authors of MySQL hereby grant you an additional
12 * permission to link the program and your derivative works with the
13 * separately licensed software that they have included with MySQL.
14 *
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License, version 2.0, for more details.
19 *
20 * You should have received a copy of the GNU General Public License
21 * along with this program; if not, write to the Free Software
22 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
23 */
24
25 #ifndef PLUGIN_X_SRC_HELPER_GET_SYSTEM_VARIABLE_H_
26 #define PLUGIN_X_SRC_HELPER_GET_SYSTEM_VARIABLE_H_
27
28 #include <string>
29
30 #include "plugin/x/ngs/include/ngs/error_code.h"
31 #include "plugin/x/src/interface/sql_session.h"
32 #include "plugin/x/src/sql_data_result.h"
33 #include "plugin/x/src/xpl_log.h"
34
35 namespace xpl {
36
37 template <typename T>
get_system_variable(iface::Sql_session * da,const std::string & variable,T * value)38 void get_system_variable(iface::Sql_session *da, const std::string &variable,
39 T *value) {
40 Sql_data_result result(da);
41 try {
42 result.query(("SELECT @@" + variable).c_str());
43 if (result.size() != 1) {
44 log_error(ER_XPLUGIN_FAILED_TO_GET_SYS_VAR, variable.c_str());
45 *value = T();
46 return;
47 }
48 result.get(value);
49 } catch (const ngs::Error_code &) {
50 log_error(ER_XPLUGIN_FAILED_TO_GET_SYS_VAR, variable.c_str());
51 *value = T();
52 }
53 }
54
55 template <typename T>
get_system_variable(iface::Sql_session * da,const std::string & variable)56 T get_system_variable(iface::Sql_session *da, const std::string &variable) {
57 T value = T();
58 get_system_variable(da, variable, &value);
59 return value;
60 }
61
62 } // namespace xpl
63
64 #endif // PLUGIN_X_SRC_HELPER_GET_SYSTEM_VARIABLE_H_
65