1
/* - mode: c; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
4
* Copyright (C) 2010 Sun Microsystems, Inc.
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.
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.
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
22
#include "plugin/schema_dictionary/dictionary.h"
25
using namespace drizzled;
28
ColumnsTool::ColumnsTool() :
29
DataDictionary("COLUMNS")
31
add_field("TABLE_SCHEMA");
32
add_field("TABLE_NAME");
34
add_field("COLUMN_NAME");
35
add_field("COLUMN_TYPE");
36
add_field("ORDINAL_POSITION", plugin::TableFunction::NUMBER, 0, false);
37
add_field("COLUMN_DEFAULT", plugin::TableFunction::VARBINARY, 65535, true);
38
add_field("COLUMN_DEFAULT_IS_NULL", plugin::TableFunction::BOOLEAN, 0, false);
39
add_field("COLUMN_DEFAULT_UPDATE");
40
add_field("IS_AUTO_INCREMENT", plugin::TableFunction::BOOLEAN, 0, false);
41
add_field("IS_NULLABLE", plugin::TableFunction::BOOLEAN, 0, false);
42
add_field("IS_INDEXED", plugin::TableFunction::BOOLEAN, 0, false);
43
add_field("IS_USED_IN_PRIMARY", plugin::TableFunction::BOOLEAN, 0, false);
44
add_field("IS_UNIQUE", plugin::TableFunction::BOOLEAN, 0, false);
45
add_field("IS_MULTI", plugin::TableFunction::BOOLEAN, 0, false);
46
add_field("IS_FIRST_IN_MULTI", plugin::TableFunction::BOOLEAN, 0, false);
47
add_field("INDEXES_FOUND_IN", plugin::TableFunction::NUMBER, 0, false);
48
add_field("DATA_TYPE");
50
add_field("CHARACTER_MAXIMUM_LENGTH", plugin::TableFunction::NUMBER);
51
add_field("CHARACTER_OCTET_LENGTH", plugin::TableFunction::NUMBER);
52
add_field("NUMERIC_PRECISION", plugin::TableFunction::NUMBER);
53
add_field("NUMERIC_SCALE", plugin::TableFunction::NUMBER);
55
add_field("ENUM_VALUES", plugin::TableFunction::STRING, 1024, true);
57
add_field("COLLATION_NAME");
59
add_field("COLUMN_COMMENT", plugin::TableFunction::STRING, 1024, true);
63
ColumnsTool::Generator::Generator(Field **arg) :
64
DataDictionary::Generator(arg),
65
field_generator(getSession())
69
bool ColumnsTool::Generator::populate()
71
drizzled::generator::FieldPair field_pair;
73
while (!!(field_pair= field_generator))
75
const drizzled::message::Table *table_message= field_pair.first;
76
int32_t field_iterator= field_pair.second;
77
const message::Table::Field &column(table_message->field(field_pair.second));
80
push(table_message->schema());
83
push(table_message->name());
89
push(drizzled::message::type(column.type()));
91
/* ORDINAL_POSITION */
92
push(static_cast<int64_t>(field_iterator));
95
if (column.options().has_default_value())
97
push(column.options().default_value());
99
else if (column.options().has_default_bin_value())
101
push(column.options().default_bin_value().c_str(), column.options().default_bin_value().length());
103
else if (column.options().has_default_expression())
105
push(column.options().default_expression());
112
/* COLUMN_DEFAULT_IS_NULL */
113
push(column.options().default_null());
115
/* COLUMN_DEFAULT_UPDATE */
116
push(column.options().update_expression());
118
/* IS_AUTO_INCREMENT */
119
push(column.numeric_options().is_autoincrement());
122
push(column.constraints().is_nullable());
124
/* IS_INDEXED, IS_USED_IN_PRIMARY, IS_UNIQUE, IS_MULTI, IS_FIRST_IN_MULTI, INDEXES_FOUND_IN */
125
bool is_indexed= false;
126
bool is_primary= false;
127
bool is_unique= false;
128
bool is_multi= false;
129
bool is_multi_first= false;
130
int64_t indexes_found_in= 0;
131
for (int32_t x= 0; x < table_message->indexes_size() ; x++)
133
const drizzled::message::Table::Index &index(table_message->indexes(x));
135
for (int32_t y= 0; y < index.index_part_size() ; y++)
137
const drizzled::message::Table::Index::IndexPart &index_part(index.index_part(y));
139
if (static_cast<int32_t>(index_part.fieldnr()) == field_iterator)
144
if (index.is_primary())
147
if (index.is_unique())
150
if (index.index_part_size() > 1)
155
is_multi_first= true;
160
/* ...IS_INDEXED, IS_USED_IN_PRIMARY, IS_UNIQUE, IS_MULTI, IS_FIRST_IN_MULTI, INDEXES_FOUND_IN */
165
push(is_multi_first);
166
push(indexes_found_in);
169
push(drizzled::message::type(column.type()));
171
/* "CHARACTER_MAXIMUM_LENGTH" */
172
push(static_cast<int64_t>(column.string_options().length()));
174
/* "CHARACTER_OCTET_LENGTH" */
175
push(static_cast<int64_t>(column.string_options().length()) * 4);
177
/* "NUMERIC_PRECISION" */
178
push(static_cast<int64_t>(column.numeric_options().precision()));
180
/* "NUMERIC_SCALE" */
181
push(static_cast<int64_t>(column.numeric_options().scale()));
184
if (column.type() == drizzled::message::Table::Field::ENUM)
187
size_t num_field_values= column.enumeration_values().field_value_size();
188
for (size_t x= 0; x < num_field_values; ++x)
190
const string &type= column.enumeration_values().field_value(x);
193
destination.push_back(',');
195
destination.push_back('\'');
196
destination.append(type);
197
destination.push_back('\'');
206
/* "COLLATION_NAME" */
207
push(column.string_options().collation());
209
/* "COLUMN_COMMENT" */
210
if (column.has_comment())
212
push(column.comment());