~drizzle-trunk/drizzle/development

1340.1.5 by Brian Aker
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.
1
/* - mode: c; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
 *  vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
3
 *
4
 *  Copyright (C) 2010 Brian Aker
5
 *
6
 *  This program is free software; you can redistribute it and/or modify
7
 *  it under the terms of the GNU General Public License as published by
8
 *  the Free Software Foundation; either version 2 of the License, or
9
 *  (at your option) any later version.
10
 *
11
 *  This program is distributed in the hope that it will be useful,
12
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
13
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14
 *  GNU General Public License for more details.
15
 *
16
 *  You should have received a copy of the GNU General Public License
17
 *  along with this program; if not, write to the Free Software
18
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
19
 */
20
2173.2.1 by Monty Taylor
Fixes incorrect usage of include
21
#include <config.h>
22
#include <plugin/information_schema_dictionary/dictionary.h>
1340.1.5 by Brian Aker
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.
23
24
using namespace std;
25
using namespace drizzled;
26
27
Routines::Routines() :
28
  InformationSchema("ROUTINES")
29
{
2338.2.18 by Stewart Smith
use MAXIMUM_IDENTIFIER_LENGTH for INFORMATION_SCHEMA.ROUTINES columns
30
  add_field("SPECIFIC_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
31
  add_field("SPECIFIC_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
32
  add_field("SPECIFIC_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
33
34
  add_field("ROUTINE_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
35
  add_field("ROUTINE_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
36
  add_field("ROUTINE_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
37
38
  add_field("MODULE_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
39
  add_field("MODULE_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
40
  add_field("MODULE_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
41
42
  add_field("UDT_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
43
  add_field("UDT_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
44
  add_field("UDT_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
1340.1.5 by Brian Aker
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.
45
46
  add_field("DATA_TYPE");
47
  add_field("CHARACTER_MAXIMUM_LENGTH");
48
  add_field("CHARACTER_OCTET_LENGTH");
49
2338.2.18 by Stewart Smith
use MAXIMUM_IDENTIFIER_LENGTH for INFORMATION_SCHEMA.ROUTINES columns
50
  add_field("COLLATION_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
51
  add_field("COLLATION_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
52
  add_field("COLLATION_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
53
54
  add_field("CHARACTER_SET_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
55
  add_field("CHARACTER_SET_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
56
  add_field("CHARACTER_SET_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
57
58
  add_field("TABLE_CATALOG", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
59
  add_field("TABLE_SCHEMA", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
60
  add_field("TABLE_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
1340.1.5 by Brian Aker
Update, we now have all of the ANSI INFORMATION_SCHEMA listed.
61
62
  add_field("NUMERIC_PRECISION");
63
  add_field("NUMERIC_PRECISION_RADIX");
64
  add_field("NUMERIC_SCALE");
65
66
  add_field("DATETIME_PRECISION");
67
68
  add_field("INTERVAL_TYPE");
69
  add_field("INTERVAL_PRECISION");
70
71
  add_field("TYPE_UDT_CATALOG");
72
  add_field("TYPE_UDT_SCHEMA");
73
  add_field("TYPE_UDT_NAME");
74
75
  add_field("SCOPE_CATALOG");
76
  add_field("SCOPE_SCHEMA");
77
  add_field("SCOPE_NAME");
78
79
  add_field("MAXIMUM_CARDINALITY");
80
  add_field("DTD_IDENTIFIER");
81
82
  add_field("ROUTINE_BODY");
83
  add_field("ROUTINE_DEFINITION");
84
85
  add_field("EXTERNAL_NAME");
86
  add_field("EXTERNAL_LANGUAGE");
87
88
  add_field("PARAMETER_STYLE");
89
  add_field("IS_DETERMINISTIC");
90
91
  add_field("SQL_DATA_ACCESS");
92
  add_field("IS_NULL_CALL");
93
  add_field("SQL_PATH");
94
  add_field("SCHEMA_LEVEL_ROUTINE");
95
  add_field("MAX_DYNAMIC_RESULT_SETS");
96
  add_field("IS_USER_DEFINED_CAST");
97
  add_field("IS_IMPLICITLY_INVOCABLE");
98
  add_field("CREATED");
99
  add_field("LAST_ALTERED");
100
}
101
102
void Routines::Generator::fill()
103
{
104
}
105
106
bool Routines::Generator::nextCore()
107
{
108
  return false;
109
}
110
111
bool Routines::Generator::next()
112
{
113
  while (not nextCore())
114
  {
115
    return false;
116
  }
117
118
  return true;
119
}
120
121
Routines::Generator::Generator(drizzled::Field **arg) :
122
  InformationSchema::Generator(arg),
123
  is_primed(false)
124
{
125
}
126
127
bool Routines::Generator::populate()
128
{
129
  if (not next())
130
    return false;
131
132
  fill();
133
134
  return true;
135
}