~drizzle-trunk/drizzle/development

1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
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/show_dictionary/dictionary.h>
23
#include <drizzled/identifier.h>
24
#include <drizzled/message.h>
25
#include <drizzled/message/statement_transform.h>
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
26
#include <google/protobuf/text_format.h>
2179.6.3 by Stewart Smith
add access check to SHOW CREATE TABLE
27
#include <drizzled/plugin/authorization.h>
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
28
#include <string>
29
30
using namespace std;
31
using namespace drizzled;
32
33
ShowCreateTable::ShowCreateTable() :
1874.2.4 by Brian Aker
Have show functions be invisible.
34
  show_dictionary::Show("TABLE_SQL_DEFINITION")
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
35
{
36
  add_field("TABLE_NAME", plugin::TableFunction::STRING, MAXIMUM_IDENTIFIER_LENGTH, false);
1812.5.5 by Brian Aker
Added in possibility of having a blob type returned by a TableFunction.
37
  add_field("TABLE_SQL_DEFINITION", plugin::TableFunction::STRING, TABLE_FUNCTION_BLOB_SIZE, false);
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
38
}
39
40
ShowCreateTable::Generator::Generator(Field **arg) :
1874.2.4 by Brian Aker
Have show functions be invisible.
41
  show_dictionary::Show::Generator(arg),
1812.5.9 by Brian Aker
First pass on moving show create schema out.
42
  is_primed(false)
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
43
{
2059.1.1 by Andrew Hutchings
Refix show_dictionary plugin crash when not using 'SHOW' to access.
44
  if (not isShowQuery())
45
   return;
46
2227.4.7 by Olaf van der Spek
plugin::TableFunction::Generator::statement()
47
  statement::Show& select= static_cast<statement::Show&>(statement());
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
48
2227.4.7 by Olaf van der Spek
plugin::TableFunction::Generator::statement()
49
  if (not select.getShowTable().empty() && not select.getShowSchema().empty())
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
50
  {
2227.4.7 by Olaf van der Spek
plugin::TableFunction::Generator::statement()
51
    identifier::Table identifier(select.getShowSchema(), select.getShowTable());
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
52
2179.6.3 by Stewart Smith
add access check to SHOW CREATE TABLE
53
    if (not plugin::Authorization::isAuthorized(*getSession().user(),
54
                                            identifier, false))
55
    {
56
      drizzled::error::access(*getSession().user(), identifier);
57
      return;
58
    }
59
2179.6.4 by Stewart Smith
style cleanup
60
    table_message= plugin::StorageEngine::getTableMessage(getSession(),
61
                                                          identifier);
2179.6.3 by Stewart Smith
add access check to SHOW CREATE TABLE
62
2179.6.4 by Stewart Smith
style cleanup
63
    if (table_message)
64
      is_primed= true;
2240.3.1 by Andrew Hutchings
Make SHOW CREATE TABLE error if table doesn't exist
65
    else
66
      my_error(ER_BAD_TABLE_ERROR, identifier);
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
67
  }
68
}
69
70
bool ShowCreateTable::Generator::populate()
71
{
72
  enum drizzled::message::TransformSqlError transform_err;
73
1812.5.9 by Brian Aker
First pass on moving show create schema out.
74
  if (not is_primed)
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
75
    return false;
76
77
  std::string create_sql;
1910.2.15 by Brian Aker
Update so that we use shared_ptr from the cache throughout more of the
78
  transform_err= message::transformTableDefinitionToSql(*table_message,
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
79
                                                        create_sql,
80
                                                        message::DRIZZLE,
81
                                                        false);
82
  if (transform_err != drizzled::message::NONE)
83
  {
84
    return false;
85
  }
86
1910.2.15 by Brian Aker
Update so that we use shared_ptr from the cache throughout more of the
87
  push(table_message->name());
1812.5.5 by Brian Aker
Added in possibility of having a blob type returned by a TableFunction.
88
  push(create_sql);
1812.5.9 by Brian Aker
First pass on moving show create schema out.
89
  is_primed= false;
1812.5.1 by Brian Aker
This removes the caller for show create table to be a derived table.
90
91
  return true;
92
}